When should I add an index?
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...
2017-04-21 (first published: 2017-04-19)
2,936 reads
SQL Saturday Chattanooga 2017
Second of the year, I will be presenting at SQL Saturday Chattanooga 2017. Come see my SQL Server 2017 (Linux and Beyond) session
2017-04-19
18 reads
SQLShack Arcticle and Upcoming PASS Events
The latest article on SQLShack continues on the path of Data Warehouse development with SQL Server Analysis Services. The first...
2017-04-19
505 reads
What Exactly is the “Data Platform” Nowadays?
[read this post on Mr. Fox SQL blog] A couple of months ago I was presenting at SQL Saturday Melbourne (582) on Azure Cognitive Services and got chatting with some of the...
2017-04-18
13 reads
What Exactly is the “Data Platform” Nowadays?
[read this post on Mr. Fox SQL blog]
A couple of months ago I was presenting at SQL Saturday Melbourne (582) on Azure Cognitive...
2017-04-20 (first published: 2017-04-18)
2,289 reads
How to write understandable code for your future self
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
22 reads
I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
376 reads
Blogging at SQLPerformance.com
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
373 reads
Tuning Parallelism on SQL Server
Thoughts on how to think about parallelism in SQL Server - and how to tune it.
2017-04-18
19 reads
Blob Auditing for Azure SQL Database
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
648 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