SQL Server 2016 for Performance Tuning Lovers
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of...
2017-05-02
2,127 reads
Blog Posts
T-SQL Tuesday #90 – Shipping Database Changes
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
420 reads
Always Encrypted
By David Postlethwaite
Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database....
2017-05-01 (first published: 2017-04-24)
15,994 reads
Monday Coffee 2017-05-01
Morning all, I know it’s a bank holiday in the UK & Ireland today but some of us still have to...
2017-05-01
282 reads
SQL Saturdays – down memory lane
A casual twitter-conversation with Karla Landrum and some other peeps led me down memory lane on older events. Our SQL...
2017-05-01
434 reads
Wait Statistics integration inside the Query Store in SQL Server vNext
I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1....
2017-05-01 (first published: 2017-04-23)
1,825 reads
Creating an App Service in Azure that connects to an Azure SQL Database.
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
633 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to SQL Azure" on #DataChannel. Manohar, in this interview provides...
2017-04-30
13 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to SQL Azure" on #DataChannel. Manohar, in this interview provides...
2017-04-30
10 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to...
2017-04-30
561 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers