The tail of the log

The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...

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,...