Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design

Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less...

WWH in SSIS ? Zero to Hero in SSIS series TIP#111

Dear Friends,
As shared in last post Post #110, We are starting SSIS tutorialseries ( A Step by Step  SSIS learning tutorial)...

016 – Me, Myself and I - WaterOx Consulting

Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...
The post 016 – Me, Myself and I appeared first on WaterOx...

Versions (Master Data Services) - Where to use

Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...

Versions (Master Data Services) - Where to use

Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...

Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A

 Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...

Your Devs' Questions Answered With sys.dm_server_services

It starts with "I'm a developer...

"... with no RDP access, how can I tell if the SQL Server Agent service...

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...

Importing Power Pivot & Power View into Power BI

The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool,...

Changing Cell Phones Again

Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that...