Another Day, Another City
After a few days in Copenhagen for SQL Nexus, I traveled to London late last night, and am now making...
2016-05-05
462 reads
Free eBook – Azure SQL Databases
PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in...
2016-05-05
621 reads
SQL Server – Row Level Security in SQL 2016 – Part 2
Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...
2016-05-13 (first published: 2016-05-05)
1,493 reads
Refocus
Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I...
2016-05-04
460 reads
Word Wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-04
3,015 reads
New Azure storage account type
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage...
2016-05-04
1,089 reads
Grant Deny Revoke
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them....
2016-05-04
1,108 reads
SSRS and MDX: Think about Cell Properties
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...
2016-05-04
587 reads
Word-wrap in SQL Server Management Studio
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-12 (first published: 2016-05-04)
4,455 reads
How do you audit automatically generated sql deployment scripts?
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because...
2016-05-03
803 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