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

Latest Blog Posts

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, 37 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, 35 reads

Posted in Niko's blog 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, 66 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, 49 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, 31 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, 57 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, 60 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, 40 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, 114 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, 49 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, 134 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, 70 reads

Posted in MSSQLFUN on 5 October 2015

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use of trace flags. There are a number that people recommend you enable by default. Prior to Extended Events for example, I’d say you should turn on trace flag 1222 in order… Read more

0 comments, 70 reads

Posted in The Scary DBA on 5 October 2015

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS is widely used in the MS world, but Git is growing, Subversion is shrinking, as are most of the other platforms.

As a result, I wanted to do a quick… Read more

1 comments, 120 reads

Posted in The Voice of the DBA on 5 October 2015

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit of this information happens to be the metadata for Extended Events, and another bit of this information is tied to the metadata for deployed Sessions.… Read more

0 comments, 57 reads

Posted in SQL RNNR on 5 October 2015

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available on my blog and… Read more

0 comments, 92 reads

Posted in SQLStudies on 5 October 2015

SQL Saturday 467 - Precon - Query processing and internals

Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased to say that on Friday 5th December i will be presenting a day long pre-con on Query Processing and internals at SQL Saturday 467 in Southampton.

We will be spending…

Read more

0 comments, 79 reads

Posted in Dave Ballantynes blog on 4 October 2015

Load Testing Your Storage Subsystem with Diskspd – Part III

In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results. In our first post we showed how performance can vary based on access pattern and IO size. In our second post Read more

0 comments, 29 reads

Posted in Anthony Nocentino's Blog on 4 October 2015

Presentation Downloads from SQL Saturday Columbus GA 2015

Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL Server! And even bigger congrats to those of you who use Google maps and were still able to find the brand new event location at the Troy State University Riverfront…

Read more

0 comments, 99 reads

Posted in SQL Tact on 3 October 2015

Older posts