2022-04-06
450 reads
2022-04-06
450 reads
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
5,668 reads
2017-03-08
1,045 reads
Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
2016-08-15
3,092 reads
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,528 reads
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
2018-07-20 (first published: 2015-10-12)
8,139 reads
Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.
2016-08-31 (first published: 2014-12-10)
3,841 reads
Marcin Policht shows you how to migrate on-premise data that is already cloud-compliant to Windows Azure SQL Databases by converting it into a BACPAC formatted file.
2014-01-21
4,099 reads
This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.
2014-01-08
3,114 reads
In this article, Marcin Policht looks at migrating existing SQL Server databases to Windows Azure, starting with identifying obstacles associated with such migrations.
2013-10-22
3,910 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers