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
675 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,129 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
180 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
626 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
5 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
504 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,056 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
504 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,728 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
902 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers