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
8 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
8 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
112 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
189 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
99 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
289 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
375 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
30 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)
485 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,641 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
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...