Protesting government web surveillance: Feb 11 Blackout
We at the MidnightDBA compound* believe firmly in the right to privacy, and so have watched with dismay over the...
2014-01-13
454 reads
Last Weeks Top “Reading” Links #66
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-13
1,072 reads
The Powershell Challenge–Day 9 The Pipelines, deeper
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-13
1,148 reads
SQL Server 2014 – Delayed Durability
Pop quiz: What does ACID stand for?
That should be a pretty easy question for database professionals:
AtomicityConsistencyIsolationDurabilityIt’s that last property, durability,...
2014-01-21 (first published: 2014-01-13)
2,927 reads
T-SQL to check Data and Log Files are on same drive or not
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
646 reads
Security, Compliance, and SQL Server Webinar on January 29, 2014
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
985 reads
Bradley Ball at MagicPASS on January 15, 2014
First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks. Let them know you’ll be...
2014-01-13
670 reads
Guid vs Identity columns (Ints)
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...
2014-01-20 (first published: 2014-01-13)
4,878 reads
SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
146 reads
SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by...
2014-01-13
269 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