Tag: SQL Server

Miscellaneous

RDBMS Management on macOS

There was a time not so long ago that Database Administrators (DBAs) worked with database servers that were running on their company’s infrastructure, perhaps even nearby on the same floor.  Since the emergence of cloud database services like Amazon Aurora, Google Cloud SQL, and Oracle Database Cloud Service, this arrangement is all but obsolete.  Although …

Miscellaneous

What is the State of My Transparent Data Encrypted Database?

When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?”  There are many different states that a transparent data encrypted database might go through.  Those states go from not being encrypted to being completely encrypted, and a few others related to managing the encryption keys. You probably …

Miscellaneous

How to Send a TDE Encrypted Backup to Someone Outside Your Organization

Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted.  If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization? The easiest way to share a TDE enabled database to …

Miscellaneous

Data Encryption Using Always Encrypted in SQL Server

Introduction Data security is always a matter of concern for organizations and application users. The key challenge for any developer or architect is to understand all the concerns and build a foolproof system to ensure data security.  This is not only more intense, but more complex these days, as many organizations are planning to move …

Miscellaneous

SQL Server table hints – WITH (NOLOCK) best practices

SQL Server table hints are a special type of explicit command that are used to override the default behavior of the SQL Server query optimizer during the T-SQL query execution This is accomplished by enforcing a specific locking method, a specific index or query processing operation, such index seek or table scan, to be used …

Miscellaneous

Azure Cosmos DB Partitioning

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review …

Miscellaneous

The History of SQL Server

Introduction This article will explain the main features in SQL Server 2017, 2016, 2015, 2014, 2012, 2008, 2005, 2000, 7, 6.5, 6.0, 4.2, 1.1 and 1.0. In the past, the first SQL Server versions supported OS/2 (an operative system created by Microsoft and IBM) and Windows. Now, the new versions of SQL Server (vNext and …

Miscellaneous

How to Move a TDE Encryption Key to Another SQL Server Instance

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data.   Because the database backup contains encrypted data you can’t just restore it to any instance.  You can only restore the database backup to an instance that contains the same certificate used to originally encrypt …

Miscellaneous

How to Enable Transparent Data Encryption

Security of data is a hot topic these days.  One of the security concerns auditors have is whether or not your SQL Server data is encrypted when stored At-Rest–meaning auditors would like to see all data encrypted on the actual disk platters that store the data.   By default, SQL Server does not encrypt data in …

Miscellaneous

Introduction to mssql-cli, a new interactive command line tool for SQL Server

Microsoft recently released a new and interactive command-line query tool for SQL Server with modern features such as auto-completion and syntax highlighting. It’s called mssql-cli and this fully open source tool works on cross-platform under the BSD-3 license.   Mssql-cli was created and released with the goal to provide the following key enhancements over sqlcmd …