Snow, Heathrow Airport, Disaster Recovery
I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...
2018-01-02
695 reads
The Scary DBA
SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations
In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...
2017-12-26
816 reads
Query Store Wait Statistics with sys.query_store_wait_stats
The second best thing to questions that people ask is when I sit down to write a book. It’s so...
2017-12-18
741 reads
Execution Plan Metrics and Units of Measure
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,444 reads
SQL in the City 2017
Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...
2017-12-08
318 reads
Why I Use AdventureWorks for Demos
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
377 reads
Automating T-SQL Code Analysis
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,256 reads
Database Fundamentals #15: Modifying Data With T-SQL
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,810 reads
I May Never Be a Data Scientist
Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what...
2017-11-22
406 reads
Get That Profiler Feel in Extended Events
I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...
2017-11-29 (first published: 2017-11-20)
1,401 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