Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

I wrote a SQL Server auditing whitepaper!

I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server (database engine). You can grab it for free here (registration required):

Whitepaper: Top 5 Items to Audit in SQL Server

None of this is earth shattering. The whitepaper contains the… Read more

0 comments, 78 reads

Posted in Databases – Infrastructure – Security on 27 July 2016

When was this database restored?

I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years as a DBA I can count the number of database restores for a disaster on my fingers? (Which is good because taking off your… Read more

0 comments, 63 reads

Posted in SQLStudies on 27 July 2016

An update on AutoAdjustBufferSize in SSIS 2016

This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible.

Anyway, one of the particular updates that caught… Read more

0 comments, 124 reads

Posted in Koen Verbeeck on 27 July 2016

Bug fixes in SQL Server

SQL Server 2016 CU1 has been released and one thing I noticed was: –

FIX: Canceling a backup task crashes SQL Server 2014 or 2016

That’s pretty nasty, when I originally clicked on the link I was expecting to see detailed a pretty precise set of circumstances in which that… Read more

1 comments, 56 reads

Posted in The DBA Who Came In From The Cold on 27 July 2016

Day1 - Assertiveness Skills: Communicating with Authority and Impact

This is the last course of my July training month. This is my second course this week. Yesterday I was teaching a 1-day course Writing SQL Queries. That went very well. You can read all about how that day went here.

For the rest of this week I…

Read more

0 comments, 77 reads

Posted in The SQL DBA in the UK on 27 July 2016

Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk

When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult to know the best option to deploy the SQL Server tempdb database.

In many of the SQL templates on the marketplace it is often deployed to the C:\ by default after which you… Read more

1 comments, 105 reads

Posted in Mr. Fox SQL on 26 July 2016

Check out the latest and greatest...Great Value It Training Offers

Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail

1902: Linux Virtualisation 4 Day starting   4days 30th August
1197 Achieving ITIL Foundation Certification  30th August
450 Introduction to Networking 4 Days 30th August
2413 Microsoft Azure Infrastructure Services 4 Days 30th…

Read more

0 comments, 82 reads

Posted in The SQL DBA in the UK on 26 July 2016

PowerSQL – Get SQL TraceFlag SQL Service and Config Information

Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers.

This script outputs sql server configuration, service, start type, Service Account along with startup trace flags. The script will work on SQL Server 2005 and up.

function Get-SQLAndGlobalTraceFlagsDetails { 

Read more

0 comments, 69 reads

Posted in PowerSQL By Prashanth Jayaram on 26 July 2016

Webinar Followup: New Security Features in SQL Server 2016

I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used and answer a few… Read more

0 comments, 101 reads

Posted in Bradley Schacht on 26 July 2016

Azure SQL Database Live Migrations

Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on an Azure SQL Database server.  We are talking about Microsoft’s database as a service (DaaS)  offering, not Azure VMs also known as infrastructure as a service (IaaS).  The only current… Read more

0 comments, 67 reads

Posted in John Sterrett on 26 July 2016

Slimmer SQL Saturdays

I’ve had this idea for some time. It’s been bugging me, but I haven’t really been pressured to write, nor inspired. That changed a bit with the announcement of the rules change for SQL Saturdays, as well as a few discussions I had with people.

I dislike the announcement for… Read more

23 comments, 146 reads

Posted in The Voice of the DBA on 26 July 2016

SELECT * FROM....Writing SQL Queries...

This week is my fourth week on the spin being involved in a Learning Tree Course. This week we have double bubble. I teaching a Course today and I'm Producing a course tomorrow.
Today I will be teaching a one day course titled Writing SQL Queries. This course provides…

Read more

0 comments, 105 reads

Posted in The SQL DBA in the UK on 26 July 2016

Speaking at SQLSaturday Baton Rouge!

I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my forth SQLSaturday event this year and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! 

If you don’t… Read more

0 comments, 84 reads

Posted in Anthony Nocentino's Blog on 25 July 2016

You Deserve to be an MVP

I have been sitting on this article for a while now. I have been tossing around some
thoughts and finally it is time to share some of those thoughts with the masses. I hope to provoke further thought on the topic of being an MVP.

I want to preface all… Read more

2 comments, 83 reads

Posted in SQL RNNR on 25 July 2016

Power BI Custom Visuals Class (Module 09 – Chord)

In this module you will learn how to use the Chord Power BI Custom Visual.  Chord diagrams show directed relationships among a group of entities using colored lines (chords); this allows for an easy representation of correlating data.

Module 09 – Chord


  • Power BI Custom Visual – Chord
  • Dataset…

Read more

0 comments, 98 reads

Posted in Devin Knight on 25 July 2016

SQL Server 2016 FK operator bug?

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016. One of the topics covered was a new operator for foreign key checks.

This new operator certainly looked like it simplified the graphical plan considerably; so, I thought I’d test… Read more

0 comments, 164 reads

Posted in Confessions of a Microsoft Addict on 25 July 2016

Deploying Row Level Security with SQL Compare

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for some time, but we now have it on premise. It’s easy to setup and use, and worth taking a look at if you have multi-tenant scenarios, or need more granular… Read more

0 comments, 141 reads

Posted in The Voice of the DBA on 25 July 2016

Monitor Query Performance

Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.

Sooner or later when you’re working with SQL Server, someone is going to complain that the server is slow. I already pointed out the first place you should look when this… Read more

2 comments, 101 reads

Posted in The Scary DBA on 25 July 2016

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. I’ve become a huge proponent of blogging and… Read more

2 comments, 89 reads

Posted in SQLStudies on 25 July 2016

Fourth Week in July

This is the fourth week of four of my July training programming and this week we have two courses that I am involved in

Tomorrow 26th July I will be teaching a one day course titled Writing SQL Queries. This course provides and introduction to writing queries, using…

Read more

0 comments, 69 reads

Posted in The SQL DBA in the UK on 25 July 2016

Older posts