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

Latest Blog Posts

Speaking at Charlotte BI Group Tomorrow

Tomorrow, Tuesday, April 7, 2015, I’ll be speaking at the Charlotte BI user group. The meeting starts at 5:30 PM.

Here’s the info:


Topic: Securing the ETL Pipeline

We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might… Read more

0 comments, 86 reads

Posted in Databases – Infrastructure – Security on 6 April 2015

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance

Great topics for further reading about tuning SQL Server performance:

Exploring SQL Server 2014 SELECT INTO Parallelism

Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO… Read more

2 comments, 81 reads

Posted in Kevin E. Kline on 6 April 2015

MVP Showcase Portugal 2015

É com uma enorme felicidade e orgulho que gostava de partilhar a notícia sobre a criação de um evento Português sobre o programa MVP – MVP ShowCase Portugal 2015. o MVP ShowCase Portugal 2015 será realizado no dia 22 de…

Read more

0 comments, 123 reads

Posted in Niko's blog on 6 April 2015

Exam Prep 70-463: Introduction to Master Data

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 3,257 reads

Posted in Cleveland DBA on 6 April 2015

Constraints and SELECT Statements

I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes sense. But other types of constraints don’t affect execution plans do they?


Let’s take this constraint as an example:

ALTER TABLE Sales.SalesOrderDetail WITH CHECK 
ADD  CONSTRAINT CK_SalesOrderDetail_UnitPrice 

Read more

8 comments, 3,034 reads

Posted in The Scary DBA on 6 April 2015

What is a CTE

CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. But even though they have been around for that decade and are widely used I still find that they confuse people somewhat. Among other things this confusion leads… Read more

1 comments, 111 reads

Posted in SQLStudies on 6 April 2015

Null, empty string, or zero?

The answer: It Depends.

One of the more common problems I encounter when managing data quality, especially in an ETL process, is the handling of null values, blanks, and zeroes. When I put on my preaching shoes to talk about bad data, this is one the areas I have to… Read more

5 comments, 3,754 reads

Posted in Tim Mitchell on 6 April 2015

Designing for offloaded log backups in AlwaysOn Availability Groups – Part 1

AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR in one! Even with AGs, still integral to your DR strategy are backups and with AGs you’re given the option to offload backups to a secondary replica. In this blog… Read more

0 comments, 36 reads

Posted in Anthony Nocentino's Blog on 6 April 2015

Very useful SET XACT_ABORT TIP#94

SET XACT_ABORT is one of the hidden gem we can say. It is helpful in many ways.
Let me explain by an example suppose you are working on a stored procedure which is doing a complex data manipulation. You though this query will run with in 1 minute when you…

Read more

3 comments, 3,646 reads

Posted in Rajat Jaiswal-337252 on 4 April 2015

Best of PASS Summit 2014: Building Bullet-Resistant SSIS Packages

This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s PASS Summit in Seattle. I was pleasantly surprised to learn that my session, “Building Bullet-Resistant SSIS Packages”, was among these. All of these sessions (including lots of other content)… Read more

0 comments, 2,961 reads

Posted in Tim Mitchell on 4 April 2015

Clustered Columnstore Indexes – part 50 (“Columnstore IO”)

Continuation from the previous 49 parts, starting from This blogpost is focused on the reading part of the IO subsystem of the Columnstore Indexes. I will try to explain the improvements in the reading process as well as some…

Read more

5 comments, 128 reads

Posted in Niko's blog on 4 April 2015

Hello SQL Server world!

Hi folks! Look, my very first post, yay!

I’ve been thinking about starting my own SQL-related blog for a long time and I guess I just needed a little kick that eventually came from Ed Leighton-Dick, Brent Ozar, Kevin Kline, Andy Warren and few other members of… Read more

6 comments, 4 reads

Posted in Gorandalf's SQL Blog on 4 April 2015

Toggle Functionality Looses In excel--ssrs 2005

Hi Folks

Highlighting on the issue that I faced last week while working on reporting services 2005.

Requirement :- A data region (table) is to be displayed based on the parameter value. Table has a toggle facility on detail rows of a group like

so on export to excel it…

Read more

0 comments, 95 reads

Posted in Everyday IT Challenges on 3 April 2015

Best of PASS Summit 2014

I am very proud to announce that one of my PASS Summit 2014 sessions was selected as one of the Top 10 of the conference, and the presentation is now available on the Best of PASS Summit 2014 list. The session is “Right-Sizing Your SQL Server Virtual Machine”,… Read more

0 comments, 2,608 reads

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

Power Query – Controlling M Query Functions with User Driven Parameters

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel to show the last years worth of data? All of that data brought across your network and then immediately filtered out. Or maybe Excel just… Read more

0 comments, 124 reads

Posted in Devin Knight on 3 April 2015

Speaker of the Month: April 2015

One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them and I’ve gone to three (had to miss last year, scheduling conflict). It’s a fantastic event and Mark Ginnebaugh (b|t) does a great job putting… Read more

0 comments, 90 reads

Posted in The Scary DBA on 3 April 2015

Generating tSQLt tests from a dacpac

Generating tSQLt tests from a dacpac

I use SSDT and tSQLt in my work and I am always interested in productivity tools to help speed up development and make it more streamlined, if there is something that can help us develop better or faster then we should use it.


Read more

0 comments, 9 reads

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

New Blogger Challenge 1 – Adding a Primary Key

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.

Primary Keys

I firmly believe that every table should have a primary key. At least until you have a reason not to have one. If… Read more

4 comments, 187 reads

Posted in The Voice of the DBA on 2 April 2015

SSDT Myths #1 - SSDT only works with TFS

I was reading a white paper from a Sql Server tools vendor about how to integrate their tools with SSDT and while it was very interesting there were a couple of inaccuracies and I wanted to clear one of them up and also to help people understand that although SSDT…

Read more

0 comments, 8 reads

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

Connect the Nots

Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered servers, nor properties. This has been noted, and closed as “Maybe someday we’ll get to it, maybe”. This rather sucks, as the trend seems to be making more and more…

Read more

1 comments, 144 reads

Posted in SQL Awesomesauce on 2 April 2015

Newer posts

Older posts