Why Test Table MetaData Tests with tSQLt
I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our...
2015-05-18
679 reads
Blog Posts
Outlier Detection with SQL Server, part 6.3: Visual Outlier Detection with Reporting Services Plots and SSDM Clustering
By Steve Bolton
…………When the goal is to illustrate how just how outlying an outlier may be, the efficiency with which...
2015-05-17
1,152 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
183 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
643 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
16 reads
003 – The Data Guild - WaterOx Consulting
Reading Time: 5 minutesAre you an Apprentice DBA? in WOxPod!, episode # 003 – The...
The post 003 – The Data Guild appeared first...
2015-05-15
510 reads
How To Get Fired from an ETL Developer Job
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,065 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
507 reads
Learn tSQLt and Unit Testing in Philadelphia
SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not...
2015-05-15 (first published: 2015-05-06)
5,733 reads
Quick Installs with Chocolatey–Screen Capture
I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight...
2015-05-15
913 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers