T-SQL Tuesday #50: Automation for LazyDBAs!
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month.
T-SQL Tuesday 50 – Automation
This blog party was...
2014-01-14
833 reads
TSQL-Tuesday#050 – Automation
TweetG’day,
Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to...
2014-01-14
1,312 reads
SQL Server Diagnostic Information Queries for January 2014
I spent some time this month to true up the SQL Server 2005 version, with the other versions for the...
2014-01-14
1,079 reads
SQL in Albuquerque
It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and...
2014-01-14
803 reads
TSQL Tuesday #50 – Automation – Verifying the Backup Chain
I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into...
2014-01-14
787 reads
Independent consultant: How to find work
When I talk to people about switching from being a salaried employee to an independent consultant (see my presentation How to...
2014-01-14
1,842 reads
2014 Polar Plunge #SQLPlunge
In just a couple months… on March 1… I’m going to jump into a lake in Minnesota. Now it’s cold...
2014-01-14
646 reads
T-SQL Tuesday #50–Automation
I missed last month and I was a bit sad, but I was traveling the week before and speaking, and...
2014-01-14
779 reads
T-SQL Tuesday #050 – Automation
In my developer life, my motto was ‘Automate all the things’ and since transitioning to a DBA role, my motto...
2014-01-14
632 reads
Time to Plan For Running For The PASS Board
I know it’s only January, but if you’re at all considering being a candidate you need to get going now....
2014-01-14
438 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers