Volunteering at Work: Teaching Others
I give a few talks on career topics, and one of these is Branding Yourself for a Dream Job. In the talk, I sometimes tell a story in the...
2023-07-21 (first published: 2023-07-10)
202 reads
Why You Should Test Your SQL Server Backups
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is...
2023-07-10
35 reads
Efficient calculation of an ISBN-13 check digit
I thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to...
2023-07-17 (first published: 2023-07-10)
406 reads
SQL Server on VMware Accelerator now free!
My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason...
2023-07-17 (first published: 2023-07-07)
422 reads
SQLSaturday Orlando Scheduled for October 7, 2023
The call for speakers is open! We’re always excited to have experienced and past speakers return (Rob Volk!), but if you’re a first time or relatively new speaker just...
2023-07-07
84 reads
Notes from SQLSaturday South Florida 2023
Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.
2023-07-21 (first published: 2023-07-06)
233 reads
Reading and searching events inside the SQL Server default trace
Note: SQL Trace and SQL Server Profiler are deprecated and will be removed in a future version of Microsoft SQL Server. The replacement technology for them is Extended Events. To Learn More: https://learn.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-ver16SQL Server...
2023-07-19 (first published: 2023-07-06)
378 reads
Wait a minute, CLUSTERED COLUMNSTORE indexes are not ordered?
Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...
2023-07-24 (first published: 2023-07-05)
568 reads
Demonstrating How I Use Voice Access
As part of my effort to inform people on how to use tools with their disabilities and continue working, I created a series of videos that demonstrate how I...
2023-07-14 (first published: 2023-07-05)
154 reads
Talking about the New Open-Source SQLCMD on Data Exposed
I was on the Data Exposed: MVP Edition show recently, talking about SQLCMD. I’ve written a few articles on the topics as well, and a blog post about setting...
2023-07-05
47 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers