Restore Master From Backup
There are a few posts running around talking about restoring master from backup. Thomas LaRock has a fantastic "How To:...
2014-01-15
629 reads
Not Dead Yet - Text and NText in SQL 2014
I was recently approached by a client who was running SQL Server 2008 with some databases in SQL 2000 compatibility...
2014-01-15
1,162 reads
PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies
Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in...
2014-01-15
626 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.8: PMML Hell
By Steve Bolton
…………In A Rickety Stairway to SQL Server Data Mining, Part 14.3: Debugging and Deployment, we passed the apex...
2014-01-15
1,615 reads
SQL Server Filtered Index Performance
Filtered Index – Database Performance
SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases. ...
2014-01-15
1,004 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part...
2014-01-14
7 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a...
2014-01-14
695 reads
Google Buys Nest
I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve...
2014-01-14
635 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,214 reads
T-SQL Tuesday #50: Doing More With Less
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is...
2014-01-14
1,008 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