SQL Saturday Chicago: I’m speaking
If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?...
2018-02-19
256 reads
Confessions of a Microsoft Addict
STORPORT: Reading an ETL trace
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,660 reads
PaaS and the ever changing role of the DBA
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...
2017-12-26 (first published: 2017-12-12)
1,663 reads
How to be a successful innovator
Let’s say you have some obscure list of career goals for the year and one of those is to be...
2017-11-09
317 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
364 reads
Don’t forget to drop your views
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...
2017-10-02 (first published: 2017-09-25)
2,794 reads
SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...
2017-09-22
420 reads
Offtopic: Lifehack: Old tech has many purposes
For those that don’t know, I live in Texas. Been here all my life. There are two main things north...
2017-09-15 (first published: 2017-09-11)
1,625 reads
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,769 reads
Thank you for Microsoft MVP
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....
2017-09-02
375 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