(Mohammed Moinudheen) We have an on-premises SQL Server database and plan to migrate it to Azure SQL Database or to SQL Server on an Azure Virtual machine. Is there a tool we can use to check for any sort of compatibility issues before migrating?
Tag: sql server
(Jack Vamvas) In a Profiler trace you can see INSERT BULK statements , which are a mechanism for interface between SQL Server and a client bulk copy API.
(Melissa Coates) When working on big data systems, it can be very helpful to include file properties and other metadata directly within the data results. Capturing data lineage can come in very handy, especially if reconciling or troubleshooting issues (for instance, if retry logic occurred in the d
(K. Scott Allen) In previous posts we look at decryption with Azure Key Vault and how to think about the roles of the people and services interacting with Key Vault. In this post I want to call attention to an Azure feature that you can use in combination with Key Vault – the Managed Service Identit
(Pinal Dave) As a part of my AlwaysOn related consultancy, one of my clients was having challenges to install SQL Server 2016 in a clustered environment. In this blog, we would learn about the cause of Slow SQL Server 2016 Installation in Cluster.
(Jason Brimhall) One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows User.
(blobeater) You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally installed SQL Server. One reason could be to pull down some reports from an Azure SQL Database to a local file share.
(Cameron) This short blog discusses how to avoid overloading an on-premises or Azure Proxy server with Backup to URL. Creating a typical .Net configuration file to disable a proxy server will allow BackupToURL.exe to communicate via https directly to Azure blog storage.
(Robert Pearl) We’ve all used the command DBCC CHECKDB from time to time in our DBA careers to verify database integrity and repair corrupt databases.
(Jack Vamvas) 1) SQL Server Service Broker is enabled per database , so If you need to enable Service Broker on multiple databases , some sort of dynamic level sql is required , as there is no Server level command to activate all databases .