T-SQL Tuesday #60 Roundup – Step Right Up

We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...

PASS SQL Saturday Events: December 2014

 
DateEventDecember 6 SQLSaturday #359 – Istanbul 2014December 6 SQLSaturday #351 – Lima 2014December 6 SQLSaturday #347 – Washington DC 2014December 13 SQLSaturday #356...

How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.

After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with...

MDX #45–Find all the Calculated Sets and Their Calculation Scripts

Now we know how to find all the calculation scripts in a cube by querying the DMV $SYSTEM.MDSCHEMA_MEASURES.
MDX #43–Find a MDX...

SQLCMD and SET QUOTED_IDENTIFIER

Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then...

How to replace a specific string from a large string with Write feature ? TIP #72

 
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...

Update all SSRS reports to apply consistent header / footer on demand

Teaching good old SSRS a new trick…

Background
Not too long ago I had a client with a very simple, yet practical requirement: they...

Memory consideration (Windows + SQL)

We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...

Reblog: November 7 to November 13

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

12 Things To Check With SQL Server To Prepare For Winter

Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...