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

Latest Blog Posts

SSRS 2016 Book Nearly Done… My Brain is now Jell-O

(first excerpt from the upcoming book) “Professional SQL Server 2016 Reporting Services and Mobile Reports” from Wrox Press is content complete!  The book is well into the editing stage– still, another grueling phase of the publishing process, but there is light at the end of the proverbial tunnel.  What is…

Read more

2 comments, 96 reads

Posted in SQL Server BI Blog on 20 July 2016

Extended Event Help Queries

Enjoy this article re-publication from my original work at SQL Solutions Group.

When working with Extended Events, there are times when a little more information is, well, helpful.  You know you want to use extended events to try and monitor for a specific thing to happen.  But sometimes you don’t… Read more

0 comments, 238 reads

Posted in SQL RNNR on 19 July 2016

SQL – MultiServer SQL Inventory – PowerShell

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When server hardware or software changes are taking place, it’s easy… Read more

0 comments, 155 reads

Posted in PowerSQL By Prashanth Jayaram on 19 July 2016

Adding the ReadyRoll Extension in VSTS

As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.

A few weeks ago I needed to do a demo with ReadyRoll for Redgate Software. I built a new project, and wanted to perform a build in Visual Studio Team Services… Read more

0 comments, 175 reads

Posted in The Voice of the DBA on 19 July 2016

T-SQL Tuesday #080–Round Up

The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month with many returning participants along with some newcomers.

We had a wide range of topics with many great insights from everyone, but don’t take my word for it. Check out… Read more

1 comments, 91 reads

Posted in The SQL Professor on 19 July 2016

Using Power BI to list Enterprise Only SQL Features

Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the web.  I pointed them to the Features Supported by the Editions of SQL Server web page and thought I was done.  He stated that this site was good, but did… Read more

0 comments, 188 reads

Posted in SQLDownSouth on 19 July 2016

What's the difference between Scrum, Kanban, Lean and XP?

…I’m about to find out.

Continuing with the July training programme,  this week I producing Learning Tree course 918 Agile Fundamentals: Scrum, Kanban, Lean and XP.

You can read about what I do as a Producer here

This course number 918,  has previously run under  a different course title…

Read more

0 comments, 100 reads

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

Getting started with In Memory OLTP in SQL Server 2016 – Part 1

In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP workloads to achieve the performance by storing data in memory and accessing data from memory. Memory optimized tables can be accessed using Transact –SQL. When memory optimized tables are accessed…

Read more

0 comments, 235 reads

Posted in Kapil Blogs on 18 July 2016

Retrieving diagnostic data from SQL Server’s Default Trace

Have you ever tried to query the contents of the default trace and then spent more time trying to figure out the name of the oldest file than the actually analyzing the data?

A while back I wrote a query to quickly get the oldest file name in the default… Read more

0 comments, 92 reads

Posted in Confessions of a Microsoft Addict on 18 July 2016

Speaking at SQL Saturday #513 in Albany, NY on July 30th – PowerShell and SQL Server

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 91 reads

Posted in on 18 July 2016

Performance Tuning Series – Main Part


Performance tuning is a tricky part. We need to analysis all points of view. Sometimes it is an easy fix and can be solved in a minute and sometimes it take a day or more to find and fix.

I received many emails for performance tuning help. It has… Read more

2 comments, 285 reads

Posted in SQL Server Blog Forum on 18 July 2016

Power BI Custom Visuals Class (Module 08 – Dot Plot)

In this module you will learn how to use the Dot Plot Power BI Custom Visual.  The Dot Plot is often used when visualizing a distribution of values or a count of an occurrence across different categorical data you may have.  Watch this module to learn more!

Module 08 –…

Read more

0 comments, 1,028 reads

Posted in Devin Knight on 18 July 2016

Building locally from VSTS

One of the things that you need with a Continuous Integration server is that ability to build your software on some computer system and verify things work. With Visual Studio Team Services, using Visual Studio online, this seems to be a challenge.

The VSTS team has thought of this… Read more

0 comments, 816 reads

Posted in The Voice of the DBA on 18 July 2016

Monday Morning SQL Break – July 18, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 73 reads

Posted in StrateSQL on 18 July 2016

SQL Saturday Louisville Precon – The Complete Primer to the Infrastructure Underneath SQL Server

I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Louisville on Friday, August 5 called ‘The Complete Primer to SQL Server Infrastructure‘.

The focus of the course is to help those new to the enterprise server… Read more

0 comments, 106 reads

Posted in Technobabble by Klee from @kleegeek on 18 July 2016

Common Table Expression, Just a Name

The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that can be easily reused over and over within another query. The CTE also provides a mechanism for recursion which, though a little dangerous and overused, is extremely handy for… Read more

10 comments, 2,424 reads

Posted in The Scary DBA on 18 July 2016

SSC Editorial: Should I Stay or Go?

Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to change jobs or projects. It’s easy to decide to leave when things are terrible, much harder when it less than optimum – because most jobs are!

Read more

0 comments, 104 reads

Posted in SQLAndy on 18 July 2016

I’m speaking at SQL Saturday Baton Rouge on 8/06/16.

If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is one of the largest SQL Saturday events each year with over 600 actual attendees.


My session is titled “Everything you ever wanted to know about query tuning in SQL… Read more

0 comments, 87 reads

Posted in Confessions of a Microsoft Addict on 18 July 2016

Is the network your last performance bottleneck?

Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options but they still have their limits). Performance is important so you’ve tuned every query, you’ve tested and adjusted each of the server settings. The cloud gives you limited control over… Read more

6 comments, 97 reads

Posted in SQLStudies on 18 July 2016

Whoisactive capturing a SQL server queries Performance Tuning


Whoisactive stored procedure is a powerful script to capture the SQL server queries with tons of information. It’s written by Adam Machanic. It makes DBAs job easier.

It’s a great script with lots of parameter and I am going to show, which are all more important.

Run the stored… Read more

5 comments, 1,794 reads

Posted in SQL Server Blog Forum on 18 July 2016

Newer posts

Older posts