SQL Saturday #107–Houston

Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen...

SQL server failed to start the system cannot find the path specified

AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
 

 
Things you have to do:...

SSAS development quick tip

When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...

SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task

There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...

Thoughts on Twitter

We hear a lot about social media these days:  Facebook, LinkedIn, Google+, Twitter, etc.  More and more, we’re expected to...

Calling Function / UDF using linked server

If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...

The Kimball Approach

The Kimball Approach
There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system....

Why shrink sql server data file failed?

Today I need to shrink a big data file, I know shrink file is not a best practise, and it...

24HOP Spring 2012 recordings

Many of the folks who are the PASS members, can have the possibility to watch 24 Hrs of PASS Spring...

April 2012 Speaking Events

This month I’ll be out and about quite a bit with speaking events.  Thought I’d detail them quickly in case...