T-SQL Tuesday #46 Rube Goldberg Machine aka Automating Deleting Older Certificates
Hello Dear Reader! This is the second Tuesday of the month and you know what that means, T-SQL Tuesday the...
2013-09-12 (first published: 2013-09-10)
1,767 reads
Blog Posts
Upcoming SQL Saturday Sessions
September is a wild month for me! This Saturday, September 14th, I will be at Kansas City’s next SQL Saturday #191...
2013-09-12
739 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
552 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
28 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
737 reads
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 ,however, it does not process large dimensional datasets...
2013-09-11
43 reads
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,138 reads
Database DoS Whitepaper from Securosis
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,037 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
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,092 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers