Category Archives: SQL

Configuring Red Hat Enterprise Linux 7.2 for YUM without a Redhat Subscription

It has been a very long time since I have installed a Redhat Enterprise Linux distribution having tended to prefer Ubuntu based distributions (such as Linux Mint) or CentOS if I really wanted a Redhat derivative (although for Oracle Database … Continue reading

Posted in Linux, SQL | Tagged | Leave a comment

The Transaction Log, Delayed Durability, and considerations for its use with In-Memory OLTP – Part I

In this mini-series of posts, we will discuss how the mechanics of SQL Server’s transaction logging work to provide transactional durability. We will look at how Delayed Durability changes the logging landscape and then we will specifically see how In-Memory … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Problem removing files from TempDB

I recently ran into an interesting problem while attempting to remove approximately half of the TempDB data files configured in a testing environment. As you might expect, there are various SQL Server tasks that are performed infrequently by a DBA, and this is … Continue reading

Posted in SQL, SQLServerPedia Syndication, Storage | Tagged , , | 3 Comments