SQL Server Diaries
  • Home
  • About Me
  • Tags
  • Author's home
Navigation bar avatar

SQL Server Diaries


Nothing you learn is of any value unless you're willing to share it with others

Domestic Appliance and Database Locking Troubles

Posted on October 30, 2022

A couple of weeks ago, a domestic appliances purchased recently started flashing a light on the display panel, indicating that something was wrong. I checked the manual that came with it, followed the troubleshooting steps, yet the issue persisted. So I called the Customer Care number and, after a couple... [Read More]
Tags: Database Administration Development Locking Blocking Deadlock

Automate AG Failover on Standard Edition

Posted on February 20, 2022

Availability Groups (AGs) on Enterprise Edition can be used to group databases and have them failover together to Secondary nodes for example - the key words here are “Enterprise Edition” and “together”. [Read More]
Tags: Database Administration Availability Groups Automation

Creating a SQL Firewall

Posted on February 12, 2022

The idea of a SQL Firewall came to me a number of years ago, probably sometime around 2008, however I have not given it much thought since. It has come up a number of times in discussions with colleagues, managers, and clients however the discussions did not move further. [Read More]
Tags: Database Administration Development Security Firewall

SQL Linter - Code Analysis

Posted on February 5, 2022

During the course of our development (yes, DBAs do develop code) we use and sometimes write our own tools, scripts, and so forth. Some I use regularly to format code for readability (such as PoorSQL), and others not that often. One of the latter is a SQL linter. [Read More]
Tags: Database Administration Development Linter

DBCC CHECKDB Fails with 'Cannot find the FILESTREAM file'

Posted on January 27, 2022

SQL Server has allowed storage of binary data in the database at least since SQL Server 2000. With the release of SQL Server 2005, the IMAGE data type was subsequently planned for deprecation and replaced by VARBINARY(max). The IMAGE data type still works and is still supported in SQL Server... [Read More]
Tags: DBCC CHECKDB FILESTREAM Security Database Administration
  • Older Posts →
  • RSS
  • Email me
  • GitHub
  • Twitter

Reuben Sultana  •  2022  •  sqlserverdiaries.com

Powered by Beautiful Jekyll