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

Latest Blog Posts

[Off-Topic] Dealing with Type 2

I had a brief conversation with Stuart Ainsworth yesterday over Facebook. In passing I mentioned that I was doing well managing blood sugar levels and he indicated he didn’t know I had been dealing with anything like that. It reminded me that I hadn’t said anything about being diagnosed with… Read more

0 comments, 4 reads

Posted in Databases – Infrastructure – Security on 28 April 2017

A Couple Weeks until VS Live–Austin

VS Live takes place in Austin on May 15-18, 2017. This is a great conference in a fun city. It’s a full stack event, with the change to learn about cloud computing, ALM/DevOps, SQL, and Visual Studio, all at the same event. You can move from room to room and… Read more

0 comments, 88 reads

Posted in The Voice of the DBA on 28 April 2017

Friday Reading 2017-04-28

Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…

Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community

SQL Server 2017… Read more

0 comments, 61 reads

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

SSDT Dev in Visual Studio Code

I have been quite interested by vs code and have been using it more and more recently. I use it for all my GO (#golang FTW) work and also powershell and I have been toying with the sql tools team's sql extension which is great. For a long time I…

Read more

0 comments, 79 reads

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

DBA 101: Tuning lookups

Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.

Microsoft has a lot of great resources discussing these topics, though I thought I’d take a… Read more

0 comments, 78 reads

Posted in Confessions of a Microsoft Addict on 27 April 2017

Speaking at Syntax Code and Craft Conference 2017

On May 18, 2017, I’ll be giving a talk at the Syntax Code and Craft Conference in Charleston, SC. If you haven’t heard of this conference, it’s a 2-day affair primarily focused on developers. Here is my talk:



An app is a failure if… Read more

0 comments, 94 reads

Posted in Databases – Infrastructure – Security on 27 April 2017

New Course: Understanding and Using Azure SQL Database

At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my course on Azure SQL Database was just published on Pluralsight too! While I am sharing awesome news, we also launched our new 3 day training class on upgrading SQL Server Read more

0 comments, 78 reads

Posted in Tim Radney - Database Professional on 27 April 2017

24 Hours of PASS is coming up!

Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24 back-to-back webinars on a certain theme. The theme this time is data security and data quality, a subject I’m passionate about.

I’m happy to say that I get to present… Read more

0 comments, 67 reads

Posted in The Data Files on 27 April 2017

Limiting the Max–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was chatting with someone the other day about MAX() and how it can work within a set of rows, rather than across an entire result set. That’s… Read more

0 comments, 102 reads

Posted in The Voice of the DBA on 27 April 2017

SSIS – Adding Connections

Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run into something like this I am going to write a quick blog about it.  It’s something new I’m trying

While recently examining an existing SSIS package  before implementing some needed… Read more

0 comments, 55 reads

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

Amt als PASS Regionalgruppenvertreter in Köln/Rheinland niedergelegt

Mit einigem Wehmut darf ich verkünden, dass ich das Amt des Regionalgruppenvertreters (RGV) der PASS Regionalgruppe Rheinland niedergelegt habe. Seit Januar 2011 bin ich RGV gewesen – also für ziemlich genau 6 Jahre.

  • Für die Noch-Nicht-PASS’ler die kurze Anmerkung: Die PASS Deutschland (e.V. um genau zu sein) ist ein…

Read more

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, 64 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, 132 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, 77 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, 72 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, 121 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

4 comments, 105 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

2 comments, 94 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, 86 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

1 comments, 84 reads

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

Older posts