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)
621 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
108 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
50 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
118 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
142 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
11 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
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
6 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
16 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)
529 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers