-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

SQL Tuning: Finding statements for missing indexes

Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.

The missing index DMVs are great but they’ve always been missing something.

What are they missing you ask? They currently tell… Read more

0 comments, 44 reads

Posted in Confessions of a Microsoft Addict on 20 April 2018

Checking Tempdb with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

In SQL Server 2016, the setup program was… Read more

0 comments, 60 reads

Posted in The Voice of the DBA on 20 April 2018

The Prompt Actions Menu

A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that appears when you highlight code. I’ve got a quick animation of this working.

In the gif, I highlight code, click the Actions icon, and then I can add a BEGIN..END… Read more

0 comments, 118 reads

Posted in The Voice of the DBA on 19 April 2018

Overview of SQL Server Backup Types

SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this article, however, we are going to focus on the types of backups that are available to us, and understand how to pick what we need, and what aspects we base… Read more

0 comments, 98 reads

Posted in PowerSQL By Prashanth Jayaram on 19 April 2018

Bring Your Own Key to Azure SQL Database TDE

I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure SQL Database there has long been an option to enable TDE with just the click of a button. A lot of… Read more

0 comments, 140 reads

Posted in Bradley Schacht on 19 April 2018

Power BI Custom Visuals Class (Module 99 – Drill-Down Donut Chart

In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to visualize categorical data in an interactive drill-down chart.

Module 99 – Drill-Down Donut Chart

Downloads

Read more

0 comments, 141 reads

Posted in Devin Knight on 19 April 2018

Finding Untrusted Foreign Keys and Constraints

In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the data that goes into your tables. But, sometimes when you need to load a lot of data quickly, SQL Server allows you to temporarily disable any CHECK or FOREIGN KEY… Read more

0 comments, 98 reads

Posted in SQL Geek on 19 April 2018

Python Jupyter Notebooks in Azure

There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can’t remember who, but I did click on the Azure Notebooks link and was intrigued. I’ve gotten Jupyter notebooks running on my local laptop, but these are often just on… Read more

1 comments, 292 reads

Posted in The Voice of the DBA on 18 April 2018

Why Don't I have a Preferred Replica?


The client reported that the log file on their main database was growing unusually large, and when they checked the backup target the database didn't have any LOG backups!

Oh, and the database was part of an Availability Group.

https://imgflip.com/i/28n8j8
--

After some investigation we found that while the Availability…

Read more

0 comments, 101 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 April 2018

Dates and Times in SQL Server: the science of time redux

Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of you are students of Albert Einstein and his theory of relativity, this might seem familiar. How does a computer know what time it is? Inside the guts of every computer… Read more

0 comments, 124 reads

Posted in Born SQL with Randolph West on 18 April 2018

SSMS: Batch Separator (Day 35)

SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go jump into batch separators, let’s first talk about what a batch is.

Batch

Microsoft explains exactly what a batch is at this link:

A batch is a group of…

Read more

0 comments, 94 reads

Posted in A Discussion of SQL Server-Related Topics on 18 April 2018

Script to review replications

This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for whatever reason. This is my last resource before getting the need to reinitialize or drop and recreate my publications.

use distribution

Read more

0 comments, 88 reads

Posted in SQLDbaInternals on 18 April 2018

An Open Letter to PASS and John Q Martin

Dear Mr. Martin and the PASS Organization,

In the spirit of advocating for change in a public way, I’m writing this letter to ask you to revisit your policies and processes and embrace the transparency that we, members of the PASS organization, deserve with regards to the SQL Saturday events. Read more

13 comments, 179 reads

Posted in The Voice of the DBA on 18 April 2018

Exploring system tables, views, SPs etc

I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. sys.all_objects and sys.all_columns. Note the All. These system views are almost exactly the same as sys.objects and sys.columns but with the single… Read more

0 comments, 112 reads

Posted in SQLStudies on 18 April 2018

Free Training 24HOP

In my sessions, I always talk about how to build your skill set when you don’t have a budget for training. Well next week April 25-26 is one of those free opportunities I take advantage of each year. 24 hours of PASS, affectionately referred to as 24HOP, is an online… Read more

0 comments, 114 reads

Posted in SQLEspresso on 18 April 2018

24 Hours of PASS – April 25th–26th

Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours. This is free training usually on a certain topic. The topic this time around is Cross Platform SQL Server Management.


The… Read more

1 comments, 86 reads

Posted in The Smiling DBA on 18 April 2018

Fix WHERE clause AND/OR/NOT confusion with truth tables

The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!

The post Fix WHERE clause AND/OR/NOT confusion with truth tables Read more

2 comments, 147 reads

Posted in SQL Awesomesauce on 17 April 2018

RDS encryption vs TDE

If you’re starting to use cloud services, the number of options available can be confusing. Particularly when they may seem to do the same thing.

If you’re on AWS, and you want to create a SQL Server instance on RDS (Relational Database Service), then you potentially have a couple of… Read more

0 comments, 122 reads

Posted in Matthew McGiffen DBA on 17 April 2018

Webinar: 6 Principles of the GDPR and SQL Provision

On April 24, I’ll be hosting a webinar that talks about the GDPR and how you can help ensure compliance in your development environments. I’ll talk about some of the issues and show how SQL Provision can help.

The GDPR is complex, but it certainly does ask us to protect… Read more

0 comments, 209 reads

Posted in The Voice of the DBA on 17 April 2018

Guide for Set Up of Telegraf for Monitoring Windows

Problem

As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system admins and share our new shiny toys and watch Windows using the same tools as SQL Server.

Install and Configure Telegraf for on Windows

The solution for this is… Read more

0 comments, 143 reads

Posted in Database Superhero’s Blog on 17 April 2018

Older posts