Database Management & Programming News, Articles & Tutorials for Database Administrators

Introduction to Running SQL Server 2019 on Kubernetes 06/23/2019

The release of SQL Server 2019 further extends the ability to host SQL Server instances on Linux, including running Docker-based SQL Server images on Kubernetes clusters. This latest release further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. Read on to learn more about the basic characteristics of these deployments!

The Demise of the DBA 06/17/2019

Today most of the tasks done by traditional DBAs are performed by artificial intelligence systems or the database itself. With so few important tasks left to perform, are DBAs really needed anymore?

Oracle's Native JSON Changes May Present a Surprise 06/13/2019

Recently Oracle has updated its JSON functionality in the database and that may present unexpected issues.  Read on to see what changed and how it could affect results.

Filtering Object Explorer Detailed Information in SSMS 06/10/2019

Need to know how to use the “Filter” item in the SSMS Object Explorer Details window to show a specific list of tables that contain a specific string of characters? If so, then read on!

Displaying the Object Explorer Details Pane in SQL Server Management Studio 06/06/2019

You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...

Ten SQL Commands You Should Be Using 06/03/2019

Most developers, regardless of their skill level would know the commands for the basic CRUD (Create, Read , Update, Delete) operations in SQL These include the Create, Update, Insert, and Delete commands. From this article you will be presented with ten other SQL commands that you really should be using, that you might not be as familiar with. Read on...

Database Development in an Open Source World 05/30/2019

Open source database tools are found in many categories, including engine, modeling, script management, metadata, interactive query, semantic layer development, governance and more. Data development in a pure open source environment is possible.

The Demise of Big Data 05/24/2019

Big data as an application (or as a service) is being supplanted by artificial intelligence (AI) and machine learning. Few new requirements for a big data solution have arisen in the past few years. All the low-hanging fruit (fraud detection, customer preferences, just-in-time re-stocking and delivery, etc.) have already been big data-ized. Is this the end of big data?

How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache 05/20/2019

Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.

How to Reseed Your Identity Column Value in SQL Server 05/14/2019

Have you deleted a bunch of rows from a table that has an identity column value and now thins aren't working quite right? If so, read on...

New Preview of SQL Server Management Studio Available for Download 12/06/2018

On September 24^th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now 12/03/2018

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!

How Big is Your Transaction Log? 10/01/2018

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.

SQL Server 2019 is Here 10/01/2018

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to improve performance, integrate your increasing volumes of corporate data, beef up security, and more. 

Line Numbers in SQL Server Management Studio 09/04/2018

Have ever tried to debug a chunk of TSQL code (like a stored procedure) and found yourself trying to figure out which TSQL statement is at a particular line number?  By default, SQL Server Management Studio (SSMS) doesn’t display numbers.  But that is only the default, you can change it.

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data 09/04/2018

There are times when you might need to look at your SQL Server data in hexadecimal format. Occasionally some string data will contain unprintable characters, which can cause downstream problems, if not detected and removed. Read on to learn how to display and remove unprintable hexadecimal characters from SQL Server data.

How to Resize tempdb 08/02/2018

When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.

How to Remove Transparent Data Encryption From a Database 08/02/2018

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.

Placing a Mark in SQL Server's Transaction Log for Fall Back 07/02/2018

How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb 07/02/2018

We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.