Enable 32 bit Applications Azure Cloud Service Hosting automation
Enable 32 bit Applications Azure Cloud Service Hosting automation
Sometime dll issues occured on IIS based on 32-bit or 64-bit dlls.Error...
2015-11-17
1,400 reads
Back to SQL Saturday Washington DC
I’ve been to the SQL Saturday in Washington, DC a few times and I’m looking forward to going back. It’s...
2015-11-16
726 reads
Monday Morning SQL Break – November 16, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-16
409 reads
CHECKDB - The database could not be exclusively locked to perform the operation
…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,504 reads
SSMS Setup
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,150 reads
Automatically name primary key constraints in SSDT
Automatically name primary key constraints
There are some things you see when writing t-sql code and schemas that just look sloppy,...
2015-11-16
453 reads
Automatically name primary key constraints in SSDT
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look sloppy, one of those is unnamed constraints, what you...
2015-11-16
11 reads
Automatically name primary key constraints in SSDT
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
50 reads
Automatically name primary key constraints in SSDT
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
34 reads
SQL Server Error Log Reader
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
709 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
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...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
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