24 Hours of PASS: Security: Session Files
Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of...
2017-05-04
724 reads
Comparing Plans via Query Store
A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...
2017-05-04
320 reads
SQL Server Pivot and Unpivot Explained
The Pivot and Unpivot features in SQL Server are I find quite underused. For a long time I got by...
2017-05-04
57 reads
Power BI Premium, Report Server, Apps and API
Announced today are some really cool new Power BI features:
Power BI Premium
Previously available were two tiers, Power BI Free and...
2017-05-03
2,078 reads
Not SQL: Taking a stand against scammers
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
537 reads
SQL Server 2017 Announced
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
97 reads
Understanding Database Backup Encryption in SQL Server
Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as...
2017-05-03
576 reads
Partitioning on a nullable column
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add...
2017-05-17 (first published: 2017-05-03)
2,116 reads
Why CROSS APPLY is AWESOME
CROSS APPLY was introducted as part of TSQL in SQL Server 2005. Origionally it was created as a way to...
2017-05-03
47 reads
Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,268 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers