(Vadivel) When using SQL Server Management Studio I feel it be a pain and waste of time to choose the same SQL server instance, authentication details again and again.
Tag: sql server
Checking compatibility for a SQL Server database migration to Azure with sqlpackage.exe
(Jack Vamvas) The SSMS installation comes with a command line utility called sqlpackage.exe . Commonly used to export sql server databases to Azure.
How-to set up point-to-site peering with Azure SQL Managed Instance and self-signed certificates
(Julio Calderón) This tutorial assumes the Managed Instance is already created and that connections from the jumpbox also work.
Retrieve the column causing an error in SQL Server Integration Services
(Koen Verbeeck) When there is an error in the SQL Server Integration Services (SSIS) data flow, you have the ability to redirect the error onto an error path
Uncovering Hidden Complexity
(Michael J. Swart) The other day, Erin Stellato asked a question on twitter about the value of nested SPs. Here’s how I weighed in:
SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid
(Pinal Dave) While using SQL Server on Virtual Machines in Azure, I ran into an interesting error. In this blog we would learn how to fix Msg 45207 – SQL Server Managed Backup to Microsoft Azure cannot configure the database ‘sqlauthdb’ because a container URL was either not provided or invalid.
Overview of Azure SQL Database Information Protection
(Marcin Policht) Information protection becomes one of the dominant factors that drive modern database design and implementation.
Which is faster? IN (list) or IN (SELECT FROM Temp)
(Kenneth Fisher) If you’ve done much with IN (list) then you’ve realized that it basically translates out to
No, You Don’t Need a Blockchain
(Thomas LaRock) The hype around blockchain technology is reaching a fever pitch these days. Visit any tech conference and you’ll find more than a handful of vendors offering blockchain.
How to create a native PowerShell app registration to connect to Azure SQL DB
(Fernando Cobo Enriquez) This guide assumes that you already own an Azure Subscription, an Azure Active Directory properly setup and your PowerShell environment properly set for running scripts.
