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

Latest Blog Posts

Sights that just scream, “No!”

I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific connections and the MiFi and cellphone uplinks I spotted this one:

That just screams, “No!” TANSTAAFL.

Read more

0 comments, 152 reads

Posted in Databases – Infrastructure – Security on 7 June 2016

Power BI Custom Visuals Class (Module 02 – Enlighten Aquarium)

In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual.  While it might not be the most practical visualization it does provide a fun way to show categorical data and can have multiple series shown as well.

Module 02 – Enlighten Aquarium


  • Power…

Read more

0 comments, 599 reads

Posted in Devin Knight on 7 June 2016


This is about analytics. This is about day to day life. This is also about how the things should not being done. Incomp… lete? I have had a friend at home yesterday and the conversation besides other things went on…

Read more

0 comments, 300 reads

Posted in Niko's blog on 7 June 2016

InsideSQL–The Deep Dive

There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near Liverpool Stree and the Moorgate stations.

And I want to go.

I can’t. I’m a bit traveled out, my family is a bit tired of travel overall, and I need… Read more

0 comments, 182 reads

Posted in The Voice of the DBA on 7 June 2016

AG Worker Thread Blocked by Log Backup

We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email stating that system thread with session ID 44 had been blocked for at least 599 seconds (10 minutes, basically). This was in the middle of the night, and I looked…

Read more

PowerShell – Install PowerShell

Recently got a question regarding PowerShell installation hence this post took an existence.

How to Install PowerShell various versions

Can we have more than one version of Powershell?

Yes, You can have multiple versions PowerShell.

How to switch between Powershell version?

ps:\>Powershell -version 4

ps:\>Powershell -version 3

ps:\>Powershell… Read more

0 comments, 248 reads

Posted in PowerSQL By Prashanth Jayaram on 6 June 2016

Painting with PowerShell: SQL Server Administration

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.

Here is a link to the YouTube Video of the presentation.

Check at the bottom of this blog post for a zip file containing the PPT as well as… Read more

0 comments, 165 reads

Posted in on 6 June 2016

SQLSaturday Iowa City is this weekend!

If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!  We have a fantastic weekend planned:

  • On Saturday, June 11, we have our free conference, with around 30 sessions on all aspects of SQL Server, plus a Women in Technology…

Read more

0 comments, 137 reads

Posted in The Data Files on 6 June 2016

Monday Morning SQL Break – June 6, 2016

It’s Monday time for this week’s Monday Morning SQL Break.  A chance to catch up on links I’ve shared and popular post from this blog.  To keep the conversation going through the week, follow me on twitter (@StrateSQL).

To kick things off this week, it’s Monday so let’s… Read more

0 comments, 103 reads

Posted in StrateSQL on 6 June 2016

SQL Compare 12 Beta

The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve been involved in looking at some early designs and functionality, and have been waiting for the product to get to the point I could play with it more.

Be sure… Read more

0 comments, 739 reads

Posted in The Voice of the DBA on 6 June 2016

Congrats to MSSQLTips on 10 Years!

MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the bulk of my writing these days, mainly because I like the problem/solution format. However, the folks at MSSQLTips didn’t just write to acknowledge their 10th birthday. 

They also posted… Read more

0 comments, 123 reads

Posted in Databases – Infrastructure – Security on 6 June 2016

Elastic Query in Azure SQL Database and Views

The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to create views that join across databases. Since I haven’t tested this myself, and I haven’t seen anyone else doing anything with it yet, I decided to set up a test.… Read more

2 comments, 1,293 reads

Posted in The Scary DBA on 6 June 2016

I need help with DBCC

Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I think I was able to name 3. Ever since then I’ve paid particular attention to DBCC commands in preparation of the day when I hear that question again. Well not… Read more

0 comments, 957 reads

Posted in SQLStudies on 6 June 2016

Broadening Horizons: From DBA to Data Science #2 Math Fundamentals

In the previous article in this blog series I told you my plans of expending my horizons towards the Data Science field. As I noted in that article my first steps towards Data Science consists of getting my math knowledge up-to-date again on math areas like linear algebra and matrices. Read more

0 comments, 891 reads

Posted in DotNine SQL Server and more on 6 June 2016

SQL Server 2016 RTM – Is Anyone Still Waiting for the First Service Pack?

Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM dropped on 1st June and a quick twitter poll, suggests that some  people at least will be deploying SQL Server 2016 in production before the end of the year.

  Read more

0 comments, 1,829 reads

Posted in The SQL DBA in the UK on 6 June 2016

SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016

Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all the script files, including the demos we skipped for sake of time, and the entire info-packed slidedeck are available for download here on the official SQLSaturday Pensacola 2016 website.

Read more

0 comments, 191 reads

Posted in SQL Tact on 5 June 2016

How To Get A Free SQL Server Indexing Book – Week 1

Free indexing books, awesome!

Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey (Blog | @gfritchey) to update Expert Performance Indexing for SQL Server. The new edition jumps from 10 to… Read more

17 comments, 232 reads

Posted in StrateSQL on 3 June 2016

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQL User Group

Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along with key observations which DBA should verify and share with IT stakeholders for increasing transparency and improved efficiency

Read more

0 comments, 414 reads

Posted in SQLFeatures on 2 June 2016

Speaking at Downtown Chicago SQL Server User Group June 9th

I’m going to be speaking for the downtown Chicago SQL Servers User Group at 5:30pm on June 9th! I plan to start the session with my constantly evolving session – Virtual SQL Servers. Actual Performance. – and moving into more of a round-table format, where all of your questions… Read more

0 comments, 178 reads

Posted in Technobabble by Klee from @kleegeek on 2 June 2016

Quick Tests for a Function

I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing one. However, I wanted to be sure that the function was the acting the same externally. In other words, does all my code that calls the function work the same? Read more

0 comments, 1,326 reads

Posted in The Voice of the DBA on 2 June 2016

Newer posts

Older posts