In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
2020-01-29 (first published: 2018-07-18)
4,186 reads
After much reading through the internet looking for Amazon’s equivalent of Microsoft’s Azure functions (Lambda), I found this outstanding link that ” helps you understand how Microsoft Azure services...
2020-01-13
231 reads
This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure...
2020-01-08
55 reads
This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...
2020-01-06
42 reads
Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...
2019-12-19
56 reads
Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so: CREATE INDEX DROP INDEX FORCE LAST...
2019-12-09
61 reads
SQL Server 2019 is ready available for use, but before you download you should review the webinars, white papers and eBook available on the technology (definitely the eBook ??...
2019-12-02
272 reads
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
A way to enforce good practice and standards is by Azure Policy. As stated by Microsoft “Azure Policy is a service in Azure that you use to create, assign,...
2019-11-12
59 reads
I think many have covered how you should backup your SQL Server database to Azure storage (also known as backup to URL) but what about restoring? Lets assume you...
2019-11-07
440 reads
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers