SQL Server 2016 Service Pack 1 Changes Everything
Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this...
2016-11-16
482 reads
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
464 reads
This Week in Data – Episode 13 (Building Your Personal Brand)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-16
513 reads
SQL Server 2016 Service Pack 1 – What’s New
With the release of the most epic Service Pack 1 for SQL Server 2016, the biggest attention of everyone should...
2016-11-16
843 reads
SQL Server 2016 SP1 – Programmability Surface for everyone!
This is the most important blog post about SQL Server that I have ever written. As far as I am...
2016-11-16
573 reads
DLM Automation–Making a Database Connection
One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...
2016-11-16
683 reads
SQLSkills waits and latches library
SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails...
2016-11-16
679 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
237 reads
SQL Server & Containers – Part One
Containers are a hot topic at the moment, there seems to be a new article about them on Hacker News...
2016-11-16
657 reads
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I'm still working...
2016-11-16
3,389 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Buy driver’s license to legally drive in any EU country.
Buy driver’s license to legally drive in any EU country. We will help...
review about registered documents.
review about registered documents. Hello have you been wondering how to get your documents...
Review about how people can get documents online without any stress
Review about how people can get documents online without any stress, Get driving license...
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