Busy times
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
447 reads
DotNine SQL Server and more
Wait Statistics #4 LCK_M_xx
In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...
2014-09-26
1,310 reads
Speaking at SQLSaturday #311 Bulgaria
More good news! I will be speaking on SQLSaturday #311 Bulgaria.
If you read this blog and will attend the event,...
2014-09-16
528 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,351 reads
Speaking at SQLSaturday #336 Holland
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This...
2014-08-23
714 reads
New website
As you can see the webpage has changed!
New features are:
– Syntax highlighting on code snippets (and easy copy/paste)
– Better readability
–...
2014-08-11
514 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we...
2014-07-11
588 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...
2014-07-11
3,456 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,246 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
433 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers