Docker, Git and DBATools
For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...
2019-11-20 (first published: 2019-11-11)
620 reads
Blog Posts
Execution Plans in Azure SQL Database
Yes you can still get execution plans for Azure SQL Database, you cannot get this from the Azure Portal so it is good to know for your tuning days....
2019-11-20
107 reads
Installing SQL Server on Windows? Don’t forget these two useful switches
A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press...
2019-11-20
48 reads
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was testing some security change, and...
2019-11-20
113 reads
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of being a guest Author and explain Azure storage options. I cover types of storage accounts,...
2019-11-20
141 reads
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month.
The post T-SQL Tuesday #120 – Recap appeared first on Wayne Sheffield.
2019-11-20
10 reads
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes
Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if you’re pulling a new container image. But what if you’re using a 2017 container running...
2019-11-20
4 reads
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes
Recently Microsoft released a Non-Root SQL Server 2019 container and that’s the default if you’re pulling a new container image. But what if you’re using a 2017 container running...
2019-11-20
5 reads
Why oh Why? Effects of Antivirus on a DB Server
At best these phantom backups cause undue headache in troubleshooting. At worst, they make it impossible to recover in the event of a database related disaster. Join me for...
2019-11-20
15 reads
Azure Synapse Analytics new features
Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...
2019-11-19 (first published: 2019-11-11)
528 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers