Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
389 reads
All About SQL
SQL Server Wait Types Library – UPGRADED!
Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...
2017-05-11
363 reads
Extended Events – I am dangerous (sometimes)
I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was...
2017-05-09
347 reads
SQL Server Recovering Data via a Hex Editor
I got bored (really bored) one weekend I decided to challenge myself. I had corruption within a specific table (localised...
2017-05-08
409 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
315 reads
Adaptive Query Processing – Interleaved Execution
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
478 reads
SQLBits Review
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
497 reads
Redgate: SQL Search
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
453 reads
I Escaped from a SQL Server Service Pack Nightmare
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
361 reads
Getting intimate with Brent Ozar (The First Responder Kit)
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
515 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers