Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...
2013-09-11
1,146 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle Poolet summarizes it beautifully – “consider the data warehouse...
2013-09-11
39 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...
2013-09-11
749 reads
Managing Data in a FileTable with T-SQL
I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do...
2013-09-11
1,094 reads
MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified Master is now on life support until December 31st,...
2013-09-11
8 reads
MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified...
2013-09-11
714 reads
SQL PASS Virtualization VC Presentation Wrapup
Everyone, thank you for attending the SQL PASS Virtualization Virtual Chapter presentation entitled “SQL Server High Availability Options After Virtualization”...
2013-09-11
686 reads
Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,735 reads
Encryption Decryption Routine
In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...
2013-09-17 (first published: 2013-09-11)
3,887 reads
Certifications: What are they good for?
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and...
2013-09-11
553 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
India is home to the calibration lab FARE Labs Pvt. Ltd.
The NABL-accredited calibration lab at Fare Labs offers the best calibration services in India...
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers