7 Best Online Advanced SQL Training Courses to Learn in 2024
The world runs on data, and SQL is the key to unlocking its secrets. If you're ready to level up your SQL game, online training is a power move....
2024-07-23
278 reads
Blog Posts
THAT Conference 2024 in Wisconsin Dells
I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is my second time in Wisconsin and third THAT overall. This time I didn’t submit, but...
2024-07-23
9 reads
Identify Tables With Dropped Columns
On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...
2024-07-22 (first published: 2024-07-09)
327 reads
Latest Update for Undercover Catalogue Powershell Interrogation Script
We’ve been hearing of a few people getting errors from the latest Undercover Catalogue, Powershell interrogation script. The issue seems to be happening when the scripts tries downloading automatic...
2024-07-22
18 reads
Microsoft 365 Security and Compliance for Administrators, a Book Review
I was asked to review the following book by the publisher, and I must say that it was a good experience for me. I used the book to help...
2024-07-22
5 reads
Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics
This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how this works (and how it doesn’t). This is part of a series of posts on...
2024-07-22
61 reads
Set a Runtime Variable in an Azure DevOps Pipeline
Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there...
2024-07-22 (first published: 2024-07-05)
317 reads
A New Word: Solysium
solysium – n. the unhinged delirium of being alone for an extended period of time – feeling the hours stretch into days until a weird little culture begins to...
2024-07-19
9 reads
Not Selected for the PASS Data Community Summit 2024
I got this in an email about a week ago from the PASS Data Community Summit. There’s more to it, but essentially I submitted 3 talks (2 on deployments,...
2024-07-19 (first published: 2024-06-28)
158 reads
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But, you only want to capture them between 3AM and 4AM. Can you do it? Output...
2024-07-19 (first published: 2024-07-01)
174 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers