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

Latest Blog Posts

April Blogging Challenge 2 – Primary Key in CREATE TABLE

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on.

Designating a Primary Key at Design Time

In the first post on this subject, I noted that I often add a primary key after the… Read more

1 comments, 209 reads

Posted in The Voice of the DBA on 9 April 2015

Live Microsoft Event - Power BI Dashboard in a Day - Baton Rouge

Join BRSSUG Founder and Microsoft TSP Patrick Leblanc to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI. In the first part of the session, the instructor will lead you through a Microsoft dataset and demo teaching you the basic elements of Power BI.

Each attendee should bring his…

Read more

0 comments, 124 reads

Posted in SQL Tact on 9 April 2015

On Automation

I’m a big fan of automation. I’ve been in IT for 27 years now. One unchanging rule during that time is there is always more to do than there is time to do it. Automation helps close that gap. And when I can automate something, I can do more than… Read more

0 comments, 2,165 reads

Posted in Databases – Infrastructure – Security on 9 April 2015

On Failure: On Being a Screw-Up

“He’s a screw-up. Always trying things that don’t work.”

I’ll be honest: I used to be afraid of being the person described above. I didn’t want to be known as someone whose ideas didn’t work. And to that end, I was successful: most of what I tried was successful. The… Read more

7 comments, 2,926 reads

Posted in Tim Mitchell on 9 April 2015

Microsoft's 1st MVP Virtual Conference - Everyone's Invited!


The Microsoft MVP community is very excited to announce it’s very first 2015 Microsoft MVP Virtual Conference (Microsoft V-Conf) coming to directly to a browser near you from May 14-15, 2015 8:00AM-6PM PDT (Thursday-Friday) offering a variety of technical sessions and professional tracks of all things Microsoft. These expert…

Read more

0 comments, 581 reads

Posted in Pearl Knows on 9 April 2015

Learn about SQL Server 2014 Performance Improvements

On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in Wroclaw/Poland. I have already done intensive work on SQL Server 2014 and helped various customers around Europe to move their workload to SQL Server 2014. In this precon I will… Read more

0 comments, 9 reads

Posted in Klaus Aschenbrenner on 9 April 2015

Journey to Becoming a Consultant – Webinar Wrap up

Today I presented a new session on the various paths to becoming a consultant to the PASS Professional Development Virtual Chapter. I thoroughly enjoyed presenting this session, and the questions were great! Plus, the coordinators for the VC have the session up on YouTube already!

The slides for this… Read more

0 comments, 106 reads

Posted in Technobabble by Klee from @kleegeek on 9 April 2015

An Even Faster Method of Calculating the Median on a Partitioned Heap

Back in 2013 I wrote an article kindly accepted for publication on the Simple Talk web site called Calculating the Median Value within a Partitioned Set Using T-SQL.  In that article, I was delighted to propose a previously unpublished solution for calculating the median over a partitioned set that… Read more

1 comments, 117 reads

Posted in DwainCSQL on 8 April 2015


Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are but then you realise that your project is like an empty void, completely devoid of any emotion, love or joy - there is no schema and code in the project…

Read more

0 comments, 85 reads

Posted in Ed Elliott's Sql Developer Blog on 8 April 2015

Trust No One Implicitly

At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk on Securing the ETL Pipeline was this:

“So you’re basically saying we should trust our DBAs?”

My response caught several people off guard:

“No, I’m saying to trust no one

Read more

2 comments, 2,803 reads

Posted in Databases – Infrastructure – Security on 8 April 2015

What is a data lake?

A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its native format until it is needed.  It’s a great place for investigating, exploring, experimenting, and refining data, in addition to archiving data.  Some characteristics of a data lake include:

  • A…

Read more

0 comments, 215 reads

Posted in James Serra's Blog on 8 April 2015

Journey to Being a Consultant – Webinar Today

Today at 11am Central time I will be presenting a new session entitled “Journey to Being a Consultant” for the PASS Professional Development Virtual Chapter. For those of you who are interested in exploring the options in becoming a consultant, sign into this free session here! Read more

0 comments, 98 reads

Posted in Technobabble by Klee from @kleegeek on 8 April 2015

Make sure you back up the Service Master Key

I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master Key is the top of the encryption chain on an instance. This means that any certificate or key will be encrypted using, in part, the Service Master Key. So if… Read more

3 comments, 115 reads

Posted in SQLStudies on 8 April 2015

How to Measure IO Latency for Database Files in SQL Server

In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called sys.dm_io_virtual_file_stats.

In addition to information about number of reads and writes, and the amounts of bytes read and written, we also have the io_stall_read_ms, io_stall_write_ms and io_stall, which… Read more

0 comments, 122 reads

Posted in Matan Yungman on 8 April 2015

How to move Resource DB in SQL Server ?

The Resource database is a read-only database that contains all the system objects. This DB included with SQL Server 2005 to increase security of system metadata. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of… Read more

0 comments, 119 reads

Posted in MSSQLFUN on 8 April 2015

A New Use Case for SQL Prompt – Shrinking Code

I thought this would work, but I wasn’t sure. I saw some code the other day like this:

DECLARE @char AS CHAR(1); SET @char = NULL; SELECT ISNULL(@char, 0); SELECT COALESCE(@char, 0); SET @char = 'E'

Read more

0 comments, 196 reads

Posted in The Voice of the DBA on 7 April 2015

SQL Server Quickie #23 – Plan Cache Pollution

Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in SQL Server.

[viral-lock message=”Like or share to get the source code.” tweet=”SQL Server Quickie #23 – Plan Cache Pollution by @Aschenbrenner:” url=””]You can find the script used during the demonstration… Read more

0 comments, 4 reads

Posted in Klaus Aschenbrenner on 7 April 2015

SSMS regular expressions: format text into a block

Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a RegEx thing in SQL Server Management Studio. Here’s the problem: Sometimes I document an SP in MS Word, then copy-paste the paragraph into a comment block in the SP. Of…

Read more

2 comments, 169 reads

Posted in SQL Awesomesauce on 7 April 2015

Excel Tip #24: Removing “Buttons” from Excel Charts

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 145 reads

Posted in DataOnWheels on 7 April 2015

How to Add Users to Roles in SSAS, a.k.a., Where the Heck are the Buttons?

I’ve been responsible for administering Analysis Services (SSAS) on a regular basis for the past 7-8 years via SQL Server Management Studio (SSMS), but developing is a whole different ball game (and set of tools). I only recently started doing development work with SSAS on a regular basis. Prior to… Read more

0 comments, 117 reads

Posted in SQL Swimmer on 7 April 2015

Newer posts

Older posts