Query Timeout of the Distribution Agent
Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...
2016-08-22
3,893 reads
Cloud Security
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...
2016-08-22
660 reads
Who did what to my database and when…
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,850 reads
Power BI Custom Visuals Class (Module 13 – Aster Plot)
In this module you will learn how to use the Aster Plot Power BI Custom Visual. The Aster Plot is...
2016-08-22
1,091 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
779 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
72 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
58 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how...
2016-08-21
20 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell? In Linux systems you’re given options, tons of options, you can set, reconfigure, add/remove...
2016-08-20
13 reads
Setting PowerShell as your default Linux shell
In this post we’re going set PowerShell as your default Linux shell.
What is a shell?
In Linux systems you’re given options,...
2016-08-20
726 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
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