(David Dye) This is probably one of the most common posts that I see on the MSDN forums and hear from students. The most common answer is that the database has been set to full or bulk logged recovery model and a transaction log backup has not been completed.

(Arshad Ali) There are several high availability solutions that can be used with SQL Server, like AlwaysOn, Fail-over clustering, or Database mirroring. While these high availability solutions ensure maximum uptime for your databases, you need to setup backup and restore strategies to recover the da

(Edwin Sarmiento) The 2-node Windows Server Failover Cluster (WSFC) running my SQL Server failover clustered instance suddenly went offline. It turns out that my quorum disk and the standby node in the cluster both went offline at the same time. I could not connect to the WSFC nor to my SQL Server f

(Balmukund) SQL Server Data Tools (a.k.a. SSDT) used to part of product installation media in SQL Server 2012. We can install it by selecting “SQL Server Data Tools” from shared features section.

(Derek Colley) You wish to access OLE or COM objects, such as file system objects (files, folders) and their properties directly from SQL Server. This might be, for example, to load data automatically from a raw data source; to check for the existence of a directory before exporting data; or to chec

(Richard_RP) If you’re using, or at least read up on Clustered Columnstore Indexes then you’ll know that the data is stored in segments. You’ll also know that there are 4 states the segments can be in at any one time:

(Shaun J Stuart) I was recently doing some work with a backup verification routine that is meant to run on various versions of SQL Server and came across some variations in the way the RESTORE VERIFYONLY command is reported by sys.dm_exec_requests between SQL Server 2005, 2008 R2, and 2012. I haven’

(Tony Davis and Grant Fritchey) Any SQL Server monitoring tool must gather the metrics that will allow a DBAs to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable co

(Marcin Policht) In our previous article published on this forum, we have presented a somewhat unorthodox (from the perspective of a typical DBA or IT Pro – but certainly not that of a developer) method of managing Azure SQL Database that involves directly invoking REST APIs, providing an alternativ

(Nakul Vachhrajani) In today’s post, I go all the way back to the basics because of a logical bug I saw in production code recently.