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

Latest Blog Posts

Dark Theme in Office 2013 & 2016

Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.

As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more

0 comments, 60 reads

Posted in SQLvariant on 5 February 2017

I have been hacked

I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.

The post I have been hacked appeared first on Grant Fritchey.

Read more

3 comments, 311 reads

Posted in The Scary DBA on 5 February 2017

Friend of Redgate – 2017

I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development.

As a multi-year awardee in the… Read more

0 comments, 127 reads

Posted in Anthony Nocentino's Blog on 5 February 2017

SQLite and the Performance Implications of Indexes

Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes is a significant part of improving overall database performance. We can use SQLite and Python to demonstrate how much of … Continue reading

Read more

0 comments, 308 reads

Posted in SQLWise on 5 February 2017

Monitoring SLAs with SQL Monitor Reporting

Proactive Reporting for SQL Server

If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big proponent of using monitoring techniques to ensure you’re meeting your service level agreements in terms of recovery time objective and recovery… Read more

0 comments, 1,320 reads

Posted in Anthony Nocentino's Blog on 4 February 2017

SQL Server on Linux

Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it and would love to write more blogs soon.    

Read more

0 comments, 174 reads

Posted in Vinay Thakur on 4 February 2017

Get Your SQL Server Product Key with Powershell #dbatools

There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.

Get-SqlServerKey is a command that will find your product keys. It’s not often you might need this, but it’s a pain to track them down from the registry and be sure you get them for… Read more

4 comments, 279 reads

Posted in The Voice of the DBA on 3 February 2017

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more

10 comments, 1,386 reads

Posted in cjsommer.com on 3 February 2017

Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))

In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual.  This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to… Read more

0 comments, 780 reads

Posted in Devin Knight on 3 February 2017

The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some of the best technical forum conversation on the subject.  I was on Twitter and my friend Kenneth Fisher asked a question.…

Read more

1 comments, 1,224 reads

Posted in SQLBalls on 3 February 2017

SQL Server vNext

I have been pretty busy recently working with Joe Sack from Microsoft and  getting my hands dirty with SQL Server vNext accessing some cool stuff (which obviously I can’t talk about – under NDA) and believe me it is pretty … Continue reading

Read more

1 comments, 354 reads

Posted in All About SQL on 3 February 2017

Friday Reading 2017-02-03

2017 is trundling along now, this week I’ve been reading…

The GitLab incident report
We’ve all had that moment of “what did I just do??” Here’s how the guys at Gitlab responded to such a moment.

Linux OS Fundamentals for the SQL Admin
I don’t know how I missed this… Read more

0 comments, 142 reads

Posted in The DBA Who Came In From The Cold on 3 February 2017

Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark


In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.

In diesem Artikel zeige ich einige Techniken zum Troubleshooten eines Performance- und sicherheitsrelevanten „Phänomens“, das mir kürzlich aufgefallen ist, als…

Read more

0 comments, 1,053 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 2 February 2017

GitLab for SQL Server Projects

This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build SQL Server projects. I use ReadyRoll for my SQL Server projects but SSDT projects could also be built with GitLab. Topics covered so far in this series… Read more

0 comments, 1,908 reads

Posted in The Database Avenger on 2 February 2017

Using a DMK in TDE

When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t exist. This key forms the basis of a chain of protection for your data inside of the SQL Server instance. The hierarchy is:

  • The DMK exists in the master…

Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 2 February 2017

DBA 101: Altering a column

People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly say that I don’t love any tools and you shouldn’t either.

My time at Microsoft placed me at nearly 300 different clients. As a Microsoft employee I never liked saying,… Read more

3 comments, 1,497 reads

Posted in Confessions of a Microsoft Addict on 2 February 2017

Microsoft Data Platform MVP Award

I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is a great honor and I’m grateful for all the support I’ve received of Microsoft, my peers and the SQL Server community over the past years. I’d like to… Read more

3 comments, 169 reads

Posted in Koen Verbeeck on 2 February 2017

Compare Execution Plans

Have you ever wanted to compare execution plans from SQL Server Management Studio? Well with the newer version of the software (SQL 2016 onward https://msdn.microsoft.com/en-us/library/mt238290.aspx) you can. Lets dive in. Once you have an execution plan ready right click on it … Continue reading

Read more

0 comments, 195 reads

Posted in All About SQL on 2 February 2017

Speaking at SQL Konferenz 2017

I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt (near Frankfurt). I was fortunate to be picked to speak in 2015, but skipped 2016 as the timing wasn’t good. This year, things lined up for me, and I’ll… Read more

4 comments, 242 reads

Posted in The Voice of the DBA on 1 February 2017

Changing what SSMS opens on startup

When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and password (if needed) you get an object explorer connection.

But what if that isn’t what you want?

In my second ever post (way back in August of 2012) I… Read more

0 comments, 196 reads

Posted in SQLStudies on 1 February 2017

Newer posts

Older posts