Speaking at SQL Saturday 513 in Albany, NY on July 30th - PowerShell and SQL Server
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
140 reads
SQL Saturday Louisville Precon – The Complete Primer to the Infrastructure Underneath SQL Server
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Louisville on...
2016-07-18
413 reads
Common Table Expression, Just a Name
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,609 reads
SSC Editorial: Should I Stay or Go?
Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to...
2016-07-18
362 reads
I’m speaking at SQL Saturday Baton Rouge on 8/06/16.
If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is...
2016-07-18
312 reads
Is the network your last performance bottleneck?
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options...
2016-07-18
445 reads
Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported
Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...
2016-07-17
483 reads
Karla Set the Standard
Last week Karla Landrum announced that she will be leaving her position as Community Evangelist later this year after five...
2016-07-22 (first published: 2016-07-17)
1,641 reads
SQLSaturday Baton Rouge 2016!
Free SQL Server, SharePoint and .NET training
SQLSaturday is a global event to bring Information Technology speakers and professionals together for...
2016-07-16
454 reads
MeasureUp 2016
I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help...
2016-07-16
558 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