Azure SQL Migrations using Azure Data Studio
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
2021-09-20
4,819 reads
Database Migration
Minimal Downtime Storage Migration of Large Databases
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2021-02-24
5,002 reads
SQL Database Migration: Lower to Higher Version
Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.
2016-08-16 (first published: 2015-01-29)
6,016 reads
Blogs
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Forums
Convert columns result into rows with comma and single quotes
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi-subnet with standardeditionofsqlserver supports DB Mirror Or AG group
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...
post steps for Table PARTIONING
Any one did Table partitioning in Prod, please list steps here. we have a...
Ask SSC