(Kenneth Fisher) I had one of my developers ask me why he keeps seeing the following warning when he tries to modify a table:

(Daniel Farina) At some point you are going to experience issues with database performance. You need to have a process to follow and certain tasks that you should perform. In this tip I provide steps to help you build a standard troubleshooting guide.

(Steve Hood) Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes something changes without our knowledge and is running differently than normal, this is the first place you look to see what’s going on.

(Marcin Policht) In our articles recently published on this forum, we have been covering high availability and disaster recovery features incorporated into Azure SQL Database. However, it is important to point out that Microsoft cloud platform also allows you to provide resiliency for your on-premis

(Gigi Sayfan) SQLAlchemy is a very sophisticated toolkit for databases in Python. It has many layers that have different levels of control and ease-of-use. SQLAlchemy is designed to provide superb performance, but it is sometimes too difficult to harness all the power.

(Kenneth Fisher) Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts.

(Greg Robidoux) Over the years the licensing model for SQL Server has evolved in many ways. One of the biggest changes was when SQL Server 2012 was released and licensing was switched from physical processor to core-based licensing. Another big shift has been the move to virtual machines and how the

(Koen Verbeeck) SQL Server 2016 comes with the integration of the popular language R into the database engine. This feature has been introduced in SQL Server 2016 preview CTP3.0 and is called SQL Server R Services. This tip will guide you through the set-up and configuration of the server components

(Michael J. Swart) Yesterday I had my mind changed about the best way to do concurrency. I describe several methods in Mythbusting: Concurrent Update/Insert Solutions. My preferred method is to increase the isolation level and fine tune locks.

(Derik Hammer) Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group.