Introduction to Integrity: Corruption in Nonclustered Indexes
It’s day four of our six part series Introduction to Integrity, sponsored by Idera, and tonight’s topic is going to...
2013-09-12
1,141 reads
Blog Posts
Microsoft Certified Master program killed
The Certified Master and Architect community was collectively notified Friday, August 30, at 10PM PST that the Certified Master (MCM/MCSM)...
2013-09-12
1,494 reads
Microsoft Expands Data Centers… Again
Didn’t they just do this in the spring? Word is out that they’re expanding even more data centers. The cynical...
2013-09-12
678 reads
SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
879 reads
TPC-E Benchmark Results for Intel Xeon E5-2697 v2
Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697...
2013-09-12
1,671 reads
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,755 reads
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
735 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
535 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
15 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
726 reads
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers