dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....
2017-06-28 (first published: 2017-06-19)
1,707 reads
The Three T’s of Backups
I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume,...
2017-06-26 (first published: 2017-06-19)
1,824 reads
PASS Board Elections
Well, it is almost that time of the year again. Elections for the PASS Board. This is a great way to show your passion for this wonderful community...
2017-06-19
12 reads
Webinar with Rubrik: Simplifying SQL Server Data Protection – Near Zero RTO
I am very proud to contribute to a new webinar with Rubrik on Thursday, June 22 at 8AM PT / 11AM ET...
2017-06-19
372 reads
SQL Server TDE – Is TempDB Encrypted?
A really quick one today, something that made me think for a minute and I thought it might make others...
2017-06-19
674 reads
Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
2,761 reads
Microsoft Professional Program in Data Science – Continued
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...
2017-06-27 (first published: 2017-06-19)
2,861 reads
Understanding Relative Risk – with T-SQL
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,973 reads
Monday Coffee: SQL Saturday Dublin
Last weekend was SQL Saturday Dublin, and it was a good one.
My session on An introduction to SQL Server & Containers...
2017-06-19
315 reads
SQL Server Installed and Running on macOS In Less Than 5 Minutes (With Video)
SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...
2017-06-19
47 reads
Blogs
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...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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