Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or looking to make a move to the cloud there are a few key performance metrics...
2019-07-23
132 reads
In a recent post about creating Azure VMs using PowerShell, I noted a common issue that I run into where the name of the OS disk does not conform...
2019-08-08 (first published: 2019-07-16)
8,911 reads
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on...
2019-07-25 (first published: 2019-07-09)
385 reads
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key....
2018-06-12 (first published: 2018-06-05)
1,878 reads
In a recent post I wrote about a new functionality for Azure SQL Database’s TDE feature: Bring Your Own Key. At the time the only way to bring your...
2018-06-05
7 reads
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that...
2018-06-07 (first published: 2018-05-29)
1,752 reads
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of...
2018-05-29
53 reads
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came...
2018-05-30 (first published: 2018-05-22)
2,179 reads
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do...
2018-05-22
34 reads
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure...
2018-05-22
10 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers