I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-12-09 (first published: 2019-11-25)
473 reads
I’m a creature of habit. I have my routine when I get to my hotel room on business trips. I have a way I like my email and notes...
2019-11-27 (first published: 2019-11-19)
922 reads
It’s that time of the year again. No, not fall, although I do love the weather change that’s around the corner. It’s time for me to rebuild my Azure...
2019-11-14 (first published: 2019-11-06)
476 reads
Most people connect to a database, create tables, run update statements, tune queries, add indexes, and never once think about the underlying data and log files that support all...
2019-09-04
29 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-09-02 (first published: 2019-08-22)
271 reads
In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...
2019-08-13 (first published: 2019-07-30)
625 reads
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
40 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)
992 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)
271 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,834 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA...
Every once in a while there is an extremely valuable tool that comes along....
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the...
Comments posted to this topic are about the item Verify your SQL Server database...
Hi all, I´m not sure what I´m doing bad with this query: Situation: I...
HI Guys, can I use Stretch database to migrate the database to azure.?...
Ask SSC