SQL Server management, tutorials, scripts, coding, programming and tips for database administrators
Learn about the range of connectivity options available for Azure SQL Database deployments.
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
As a DBA it is important to have a toolbox that supports the work you do. You need to have a toolbox that allows you to work smarter instead of harder. Read on to learn about some key tools every DBA should have in their toolbox!
Read on to step through the process of implementing Azure Data Factories.
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on....
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.
Azure SQL Database, unlike its on-premises counterparts, restricted its integration capabilities to those implemented directly by the database engine. To remediate this shortcoming, Microsoft provided equivalent functionality by relying on integration runtime of Azure Data Factory. In this article, you get an overview of this Azure-based SSIS offering.
Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
Step through a demonstration illustrating a sample deployment of SQL Server 2019 Always On Availability Group cluster on Azure AKS. You'll discover how to leverage the Microsoft Azure-hosted managed Kubernetes service referred to as AKS.
The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using a couple of commands. Read on to learn more!
While the most common methods of interacting with Azure Cosmos DB involve programmatic access, there are times when you might want to perform a quick change or take a peek at some of documents in a collection. In such instances, it is typically more convenient to rely on the graphical interface. Fortunately, there are several options you can use to accomplish.
Learn how to create and execute dynamic SQL in your SQL Server projects!
Polls and surveys are increasing in use. If you are a DBA, developer, or data scientist, then it is good to understand how to structure your systems for transparency and proper use.
MS SQL Archives