Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
498 reads
Confessions of a Microsoft Addict
New SSMS bug?
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
623 reads
DBA 101: File growth
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...
2017-03-03
467 reads
DBA 101: Unique Constraint vs Unique Index
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,513 reads
DBA 101: What you may be missing with “Missing indexes”
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...
2017-02-15 (first published: 2017-02-08)
3,373 reads
DBA 101: Altering a column
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...
2017-02-06 (first published: 2017-02-02)
2,213 reads
Query tuning 101: Non-trusted Foreign Keys
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...
2017-01-05 (first published: 2016-12-30)
3,525 reads
Off topic: The two cycle engine and your career path
I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One...
2016-12-30
774 reads
Using Memory Optimized tables for reporting
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,300 reads
Nintendo NES Classic Edition giveaway! #SQLFamily
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
700 reads
Blogs
Do Yourself a Favor, Check Out Woodler
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...
Vertically scaling SQL Server online in Kubernetes
One of the new features in Kubernetes v1.33 is the ability to resize CPU...
Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
Forums
What’s the Difference Between AWS RDS and DynamoDB?
When comparing AWS RDS and DynamoDB, the core difference lies in structure and use...
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers