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

Latest Blog Posts

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, 51 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, 34 reads

Posted in SQL In The Wild 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, 36 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, 35 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, 20 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, 51 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, 44 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, 124 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, 68 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, 67 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, 116 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, 55 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, 90 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, 77 reads

Posted in Dave Ballantynes 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, 95 reads

Posted in SQL Tact on 3 October 2015

Atomic Commit In Multiple Files Of SQLite Database

Introduction to Atomic Commit

In my previous post, we have discussed how to view and analyze SQLite BLOB data and know why BLOB data is important in SQLite database. Now, in this blog section we will know the role of atomic commit in SQLIte multiple files. SQLite has become the…

Read more

0 comments, 95 reads

Posted in Zora's SQL Tips on 3 October 2015

Standing Desk Update

It’s been a long time since I wrote about my workspace, however I made a change recently. This was the "short term test" situation I set up a couple years ago:

After just using boxes for a few days, I decided I liked things and got monitor stands. However… Read more

1 comments, 151 reads

Posted in The Voice of the DBA on 2 October 2015

Speaker of the Month: October 2015

Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of people to award it to. Most months, if I’ve been able to go to a community event or two, I have three or four candidates.  Same this month.

Speaker of… Read more

4 comments, 114 reads

Posted in The Scary DBA on 2 October 2015

019 – 24 HOP Questions Answered - WaterOx Consulting

  24 HOP Questions Answered In WOxPod!, episode # 019 – “24...

The post 019 – 24 HOP Questions Answered appeared first on WaterOx Consulting.

Read more

0 comments, 121 reads

Posted in WaterOx SQL on 2 October 2015

Older posts