Tag: SQL Server

Miscellaneous

Ola Hallengren’s SQL Server Maintenance Solution

This is the second article in Ola Hallengren’s SQL Server Maintenance Solution series. It will cover the jobs for database integrity, backup history cleanup and job history cleanup. The installation of Ola Hallengren’s Maintenance Solution is covered in the first article in the series: Ola Hallengren’s SQL Server Maintenance Solution – Installation and SQL Server …

Miscellaneous

How to implement array-like functionality in SQL Server

Introduction I was training some Oracle DBAs in T-SQL and they asked me how to create arrays in SQL Server. I told them that there were no arrays in SQL Server like the ones that we have in Oracle (varray). They were disappointed and asked me how was this problem handled. Some developers asked me …

Miscellaneous

Top 8 new (or enhanced) SQL Server 2017 DMVs and DMFs for DBAs

Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system state. On querying the related system objects, database administrators can understand the internals of SQL Server. It allows us to monitor the performance of the SQL Server instance, and diagnose issues with it. SQL Server …

Miscellaneous

Understanding SQL Server query plan cache

Whenever a query is run for the first time in SQL Server, it is compiled and a query plan is generated for the query. Every query requires a query plan before it is actually executed. This query plan is stored in SQL Server query plan cache. This way when that query is run again, SQL …

Miscellaneous

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

Overview In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. This activity will help you to understand …

Miscellaneous

How to Change the Default Backup Directory

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups.  If you don’t change the default location for your installation your default backups location will be “C:Program FilesMicrosoft SQL ServerMSSQL13.MSSQLSERVERMSSQLBackup”  (default location for a SQL Server 2016 installation).   Overtime you might decide you want …

Miscellaneous

Has Your Database Been Backed up in the Last 24 Hours?

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up.  Without recent backups you will not be able to recover your database without potentially losing many days of database updates.  Therefore, you need to make sure on a daily basis that your backups are running …

Miscellaneous

Azure Cosmos DB Consistency Levels

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. This behavior exemplifies strong consistency, which implies that multiple, concurrent processes will always have the same view of database content. While such assurances are frequently desirable, they involve …