Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many...
2012-09-06 (first published: 2012-09-04)
1,909 reads
Capture SQL Server Deadlocks using Extended Events
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,534 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
898 reads
Quick T-SQL Performance Comparison
I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask...
2012-09-03
1,295 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
982 reads
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,135 reads
Troubleshooting Oracle Link Server - Part2
It's my bad that I did not made a post since long lately. I would not make an excuse like...
2012-09-01
1,073 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,524 reads
Demonstration of a simple dashboard created with the Tableau Software
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,875 reads
Thinking on Execution
I read a lot, one the most recent books is The 4 Disciplines of Execution which is, of course, about...
2012-08-31
1,549 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers