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

Latest Blog Posts

Speaking at the SSWUG 2017 Spring Virtual Conference

On May 2, 2017, I’ll be giving two talks at the SSWUG 2017 Virtual Conference. Here are the talks:


Building a Home Grown Auditing Infrastructure for SQL Server

Not everyone has the budget for 3rd party tools to provide audit / security information on their SQL Server environment.… Read more

0 comments, 33 reads

Posted in Databases – Infrastructure – Security on 26 April 2017

Still time to enter the SQL Clone contest

You could win an Amazon Echo from Redgate. Our contest is still open for a few days, so post a comment on my blog and take your chances. I’ll be picking from the comments next week.

Filed under: Blog Tagged: Redgate, SQL Clone, syndicated

Read more

0 comments, 90 reads

Posted in The Voice of the DBA on 26 April 2017

PowerShell Function – Validating a Parameter Depending On A Previous Parameter’s Value

I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for the amazing PowerShell SQL Server Community module dbatools. He was asking my opinion as to how to enable user choice or options for Agent Schedules and… Read more

0 comments, 38 reads

Posted in SQL DBA With A Beard on 26 April 2017

QA, Utility Databases, and Job Executions

Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation are different; there will always be several different ways in most cases that you can arrive at a solid solution.


This post has a few intentions behind it:

  • It…

Read more

0 comments, 39 reads

Posted in The SQL Professor on 26 April 2017

SQL PowerShell 2017 IS HERE!

Cue Princess Jasmine.

What do I mean “Cue Princess Jasmine”?
Well because starting today, it’s a “Whole New World for You & Me”

What on Earth am I talking about??
The SqlServer PowerShell is now available for download in the PowerShell Gallery! http://sqlps.io/sqlserver

What Does It Mean!?

It means that… Read more

0 comments, 63 reads

Posted in SQLvariant on 26 April 2017

Why is a Windows authenticated login more secure than a SQL authenticated one?

I had this question come up at work the other day and while I knew it was true I wasn’t as sure about why as I’d like. The person I was working with wanted a real answer, not just Because I say so, so off to the internet I… Read more

2 comments, 57 reads

Posted in SQLStudies on 26 April 2017

SQLBits Review

I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find it useful (even though it was 2 weeks ago!) To start with I always wanted to go to a SQLBits … Continue reading

Read more

0 comments, 71 reads

Posted in All About SQL on 26 April 2017

SQL Server 2016: A Comprehensive Introduction – Arabic

It has been over a year since I have blogged, I know… that’s a long time!  I have not retired, but rather focused on other parts of my life and career and I hope to get back to blogging.  One of my major focuses for the last year was a…

Read more

0 comments, 67 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 26 April 2017

Pausing index rebuilds in SQL Server 2017

Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –

To see the new Adaptive Join… Read more

0 comments, 61 reads

Posted in The DBA Who Came In From The Cold on 26 April 2017

Updating TSqlModels (DacFx)

This one is for the DacFx nuts out there, it can't be a very big club but judging from the occasional emails I get about it, the quality is very high ha ha.

If you have a TSqlModel and you want to make a change to it, you have a…

Read more

0 comments, 42 reads

Posted in Ed Elliott's Sql Developer Blog on 26 April 2017

Speaking at 24 Hours of PASS

On May 3, 2017, at 2 PM EDT (6 PM GMT) I’ll be speaking as part of the 24 Hours of PASS. Here’s what I’ll be speaking on:


Protecting Data Across the Environment

You are responsible for protecting data within your organization. Wary of how attackers have become… Read more

0 comments, 72 reads

Posted in Databases – Infrastructure – Security on 25 April 2017

Power BI Custom Visuals Class (Module 48 – Time Brush)

In this module you will learn how to use the Time Brush Power BI Custom Visual.  The Time Brush gives you the ability both filter your report and see a graphics representation of your data at the same time. The name Time Brush comes from the behavior used when you… Read more

0 comments, 84 reads

Posted in Devin Knight on 25 April 2017

Quick Script: Finding Specific Columns

I like scripts.  Scripts that help me do things.

Working in the financial industry, there are always things that you have to ensure are protected.  More specifically, social security number and date of birth.

If your environment is like most, there are legacy applications that have a database behind the… Read more

0 comments, 77 reads

Posted in John Morehouse | Sqlrus.com on 25 April 2017

Can a Data Professional Be Organized?

“One of the advantages of being disorderly is that one is constantly making exciting discoveries.”  While this quote is true it is often times too late to act on an opportunity therefore it is missed. If you are a leader at your respective shop it can then be conceived that… Read more

0 comments, 59 reads

Posted in The SQL Professor on 25 April 2017

SSIS Training for Summer 2017

This summer, I will be delivering my popular full-day training class Building Better SSIS Packages in three different cities across the southern United States: Thursday, June 1st: Pensacola, Florida Friday, June 16th: Pasadena, Texas (just outside of Houston) Friday, July 14th: Lawrenceville, Georgia (near Atlanta) This course is designed for… Read more

0 comments, 67 reads

Posted in Tim Mitchell on 25 April 2017

Food On Your Table

I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially said no. I mean after all, it’s just training and networking that could lead to improved knowledge and abilities which… hang on. Just how wrong I can be sometimes when… Read more

1 comments, 79 reads

Posted in The Scary DBA on 25 April 2017

Redgate: SQL Search

I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially when your environment has thousands of objects. Upon some research I found a Redgate tool that is free called SQL … Continue reading

Read more

0 comments, 84 reads

Posted in All About SQL on 25 April 2017

My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.

I have seen quite a few different development teams in wildly different environments and the single fact that really stands out is that you can tell how good a team is by the tools that they use. It isn't always the…

Read more

0 comments, 153 reads

Posted in Ed Elliott's Sql Developer Blog on 24 April 2017

Query Hash Values, Plan Guides and the Query Store

I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does at dinner. As we talked about it, I suddenly thought about both Plan Guides and the Query Store. I wondered what happened to the query hash values in that case?… Read more

0 comments, 104 reads

Posted in The Scary DBA on 24 April 2017

SSMS Tips: Copy Full Path

When you right click on a tab you’ll see a number of different options. You can set up new horizontal or vertical tab groups, pin tabs, close tabs etc. But in this particular case take a look at these options.

  • Copy Full Path
  • Open Containing Folder

They… Read more

0 comments, 77 reads

Posted in SQLStudies on 24 April 2017

Older posts