Query tuning 101: How to measure Query Plan I/O cost
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,381 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made. Here is a summary of the...
2016-11-17
625 reads
#SQLNewBlogger – T-SQL ESCAPE for Wildcards
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-11-17
729 reads
Query Store changes in SQL Server vNext CPT1
Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...
2016-11-17
892 reads
SQL Server 2016 SP1 Release - Thoughts and Comments!!!
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
727 reads
SQL Server on Ubuntu
They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so...
2016-11-16
1,297 reads
SQL Server 2016 SP1: DBCC CLONEDATABASE now with Query Store data!
SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better,...
2016-11-16
1,184 reads
SQL Server 2016 SP1 is Now Available
In the Business Intelligence and reporting space, SQL Server 2016 was a big step forward. Aside from significant relational engine...
2016-11-16
455 reads
SQL Server 2016 SP1 removes the editions’ programming feature limits! Everything from Always Encrypted to XTP/In-memory for everybody!
SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!
Unglaubliche Neuigkeiten, anders kann man es gar nicht sagen:
Mit dem heute erschienenen Service...
2016-11-16
21 reads
SQL Server 2016 SP1 removes the editions’ programming feature limits! Everything from Always Encrypted to XTP/In-memory for everybody!
SQL Server 2016 SP1 entfernt Programmier-Feature-Limits der Editionen! Alles von Always Encrypted bis XTP: In-Memory für Alle!
Unglaubliche Neuigkeiten, anders kann...
2016-11-16
765 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