SQL Server management, tutorials, scripts, coding, programming and tips for database administrators

MS SQL

Running Database Console Commands (DBCCs) on Azure SQL Database 01/20/2020

Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL Database and explore their role in Database-as-a-Service scenarios.

Suspending and Resuming Transparent Data Encryption (TDE) 01/08/2020

Running Transparent Data Encryption (TDE) in the SQL Server database engine asynchronously might take a while to encrypt the entire database. Read on to learn how to suspend and resume TDE to keep your system performant.

Creating a Data-centric Mobile App 01/03/2020

See step-by-step how to create a data-centric mobile app using common tools including SQLite and C#. To learn about these tools and how to create a simple mobile app, read on!

Overview of Azure SQL Database Serverless 12/30/2019

Azure SQL Database allows for stateful services in the cloud.  Read on to learn about the characteristics and use cases of the Azure SQL Database serverless tier.

A Quick Look at SQL Server Numeric Functions 12/19/2019

If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions

Turning off Parameter Sniffing for a SQL Server Database by Default 12/09/2019

Sniffing could be beneficial to your SQL Queries. Learn about parameter sniffing as well a how to turn it on by default.

Overview of Azure SQL Database Networking 11/25/2019

Learn about the range of connectivity options available for Azure SQL Database deployments.

A Beginner’s Guide to SQL String Functions 11/21/2019

Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!

A Toolbox Every DBA Should Have 11/14/2019

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!

Implementing SQL Server Integration Services with Azure Data Factory 11/04/2019

Read on to step through the process of implementing Azure Data Factories.

Accelerating Database Recovery with SQL Server 2019 10/14/2019

Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”. Read on.... 

Introduction to the Partition By Window Function 10/02/2019

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!

Database Tools and Extensions for Visual Studio 2019 09/23/2019

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.

Implementing SQL Server Integration Services with Azure Data Factory 09/16/2019

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.

Using PowerShell to Generate Logins, Server and Database Permissions 09/09/2019

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.