Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

SQL Server Contracting – The first 14 months (or so)

Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem to be adjusted to the world of contracting (or rather adjusted to working more than a mile away from where I… Read more

0 comments, 6 reads

Posted in SQL Server Rocks! on 7 October 2015

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on, or that you read about it on (or one of our newsletters). Or it’s possible that you’ve missed the news. So, ahem. Index Maintenance We have created…

Read more

0 comments, 40 reads

Posted in SQL Awesomesauce on 7 October 2015

Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - WaterOx Consulting

The Assumption I assume you already have a Hyper-V basic configuration on...

The post Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick appeared first on WaterOx Consulting.

Read more

1 comments, 36 reads

Posted in WaterOx SQL on 7 October 2015

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!

The post… Read more

0 comments, 28 reads

Posted in Tim Mitchell on 7 October 2015

Finding the error from a failed job.

This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.

Here is our job that will fail:


Then we run it and it fails!

And when we click on the error… Read more

0 comments, 51 reads

Posted in SQLStudies on 7 October 2015

Exposing Deployed Event Metadata with PoSH

In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is PowerShell. In that article, I focused primarily on introducing PowerShell as a power tool to help in discovering the Extended Event Sessions deployed to the server as well… Read more

0 comments, 33 reads

Posted in SQL RNNR on 7 October 2015

TUGA IT Conference 26-28th of May 2016

Between 26th and 28th of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT. Targeting Microsoft Data Platform, BizTalk, SharePoint, Office365, Azure Infrastructure & much more, this event will be one of the…

Read more

0 comments, 81 reads

Posted in Niko's blog on 6 October 2015

SQLSaturday Portugal – I am not the principal organiser anymore

Unless you have been sleeping under the rock in the past 5 days, if you are a twitter user, you should have definitely seen some of the reactions and pictures from the passed SQLSaturday Portugal Port-Wine edition 2015. Our second…

Read more

0 comments, 69 reads

Posted in Niko's blog on 6 October 2015

TechFuse Minnesota Follow Up


My Session: Using Azure SQL Database for Enterprise Needs

On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some of the highlights from the session included a comparison of the various SQL Server offerings and how Azure SQL Database fits into the overall picture. During the session we… Read more

0 comments, 46 reads

Posted in DataOnWheels on 6 October 2015

Testing Sum By Month

I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to track. As a result, when I look to solve a problem, I’ve written a test to verify that what I think will happen, actually happens.

The Problem

I saw a… Read more

0 comments, 87 reads

Posted in The Voice of the DBA on 6 October 2015

Index selectivity and index scans

There was a question raised some time back ‘If an index is not selective, will the query operators that use it always be index scans’?

It’s an interesting question and requires a look at what’s going on behind the scenes in order to answer properly..

Short answer: No, not always. Read more

0 comments, 67 reads

Posted in SQL In The Wild on 6 October 2015

How I Got my Start at Pragmatic Works

October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a lot over the past seven years. Working with the wonderful people at Pragmatic Works has been quite an amazing journey and incredible opportunity. With that in mind I thought that… Read more

4 comments, 61 reads

Posted in SQL with Dustin Ryan on 6 October 2015

Today at 12pm Central: #MinionEnterprise Talk – Backup Management!

Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how “ME” can help you with your database enterprise. Specifically, this month we’ll show off enterprise backup management. Configure, manage, and report on all backups from a…

Read more

0 comments, 80 reads

Posted in SQL Awesomesauce on 6 October 2015

New Article: Loading Fixed Width Files to Staging Tables

My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on In the article, I provide a design pattern for loading fixed width flat files into staging tables. I also demonstrate a step-by-step example of creating an SSIS package for this pattern.

Head… Read more

0 comments, 95 reads

Posted in Sam Vanga on 6 October 2015

Extended Event Management Power Tools

So far in this series I have introduced a couple of tools that are suitable for helping with the management of Extended Events. The tools introduced so far are the GUI and TSQL scripts. While the GUI is suitable, using a script really is a far better means of managing… Read more

0 comments, 64 reads

Posted in SQL RNNR on 6 October 2015

The Future Virtualization of the Workforce - Telecommuting

Welcome to the 21st century!  20th century habits die hard! What am I talking about today? I’m talking about the virtuous virtue of virtual vocations, more commonly known as Telecommuting or Remote Work. With today’s technology, companies should be adapting more widely to this strategy, and actively creating… Read more

0 comments, 132 reads

Posted in Pearl Knows on 6 October 2015

Handling decimal and non numeric types using Case statement

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the synopsis of challenge and solution:-

Challenge :- You have a varchar column in your input table having values such as 1.1111, 34, John.

CREATE TABLE #TEST ([UpdatedValue] VARCHAR(100))


Read more

0 comments, 61 reads

Posted in Everyday IT Challenges on 6 October 2015

Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing…

Read more

0 comments, 164 reads

Posted in SQLFeatures on 5 October 2015

Implementation of Data Compression – SQL Server

Data Compression

Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It’s a process of reducing size of database & its objects by increasing CPU cycle and reducing I/O effort.

Types of Database Compression

· Row Compression Read more

0 comments, 82 reads

Posted in MSSQLFUN on 5 October 2015

Older posts