What I’ve learned in my first 100 days with a consulting group
In case you don’t follow me on LinkedIn or Twitter, your humble host joined the smart folks at Straight Path Solutions in March. This is a talented group of...
2022-06-30
9 reads
In case you don’t follow me on LinkedIn or Twitter, your humble host joined the smart folks at Straight Path Solutions in March. This is a talented group of...
2022-06-30
9 reads
This is a follow up post to the previous one about tables with no records using data space, with the idea coming from twitter of all places. Sometimes on...
2022-03-11
114 reads
Just like that puppy you got during the pandemic, your databases hunger for more. And they grow. And occasionally make a mess. I’ll stop the analogy. Anyhow, it’s worthwhile...
2022-02-28
191 reads
If you’ve ever had to implement Change Data Capture (CDC) for a database in an Availability Group, then you know that the CDC jobs don’t really consider the Availability...
2022-02-03
114 reads
Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited...
2022-01-28
294 reads
I’m not sure how many of you use Change Data Capture (CDC) on your instances, but I’ve had to support it for a while now and I thought I’d...
2022-01-20
392 reads
For this month’s #TSQL2day, Andy Yun asked folks to share about “something you’ve learned, that subsequently changed your opinion/viewpoint/etc. on something.” Now, there are technical subjects I could share...
2022-01-11
34 reads
Managing permissions is a constant issue for Database Administrators, but rarely do DBAs consider permissions for tempdb. Everybody’s looking for something, but how often do you get requests for...
2022-01-19 (first published: 2022-01-06)
494 reads
If you’ve ever had to play administrator to a SQL Server instance, you’ve probably had to deal with TempDB data or log files that have grown unexpectedly. I know...
2021-06-03
1,653 reads
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-03-05 (first published: 2021-02-28)
172 reads
By Steve Jones
A recent change made to Redgate Monitor to add a new alert for VLF...
In this post, the fifth in our series, I want to illustrate an example...
By Steve Jones
tangency– n. a fleeting glimpse of what might have been. I tend to live...
While I know that it will speed my learning to type queries as I...
I struggled with remembering the conventions I'd chosen when creating column names and data...
How do you configure the cluster resources to be able to use Distributed Transactions...
What is a partial backup for a read-only database?
See possible answers