(Ahmad Yaseen) Network maintenance was performed in one of our data centers, causing SQL Server to reboot several times. Directly after the maintenance window, SQL Server was checked and no issues were found. The day after the maintenance, we found that the transaction log backups failed due to log

(Greg Larsen) This is the third article in my exploring SQL Server 2016 Always Encrypted series. In this article I will be looking at the differences between an Always Encrypted column that uses encryption type of Deterministic and those that use encryption type of Randomized.

(Niladri Biswas) Sometime back, in the DNF forum a question has been asked about implementing an search like Android one. This post is an attempt to provide an answer for the same using TSQL.

(Jack Vamvas) We’ve all been there as DBAs. You hit a problem – which you spend hours days troubleshooting. You reach a point where the problem persists. Maybe you have found a workaround, but as a professional you have this nagging feeling that a root cause analysis and fix must be applied.

(Jon Gallant) I had an On-Demand Azure WebJob and wanted to convert it to a scheduled WebJob. It took me a while to figure out how, so I thought I’d share to save you some time.

(Daniel Farina) You have learned about the importance of statistics in a SQL Server database, but you don’t understand it very well. Furthermore, when you learn that the DBCC SHOW_STATISTICS command gives you information about statistics, you execute it and its output adds more confusion. In this ti

(Rick Strahl) Here’s a short post that’s more of a CSS tip that I’ve found useful when styling an application. If you’re working with CSS in an application that has more than a handful of forms you’re likely dealing with a number of different input types.

(Jason Brimhall) In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I mentioned the ability to customize the display in the GUI for the merged log files.

(Joe Celko) SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to provide a lot of logic elsewhere. CHECK() and DEFAULT can do a lot to ensure that your d

(Pinal Dave) My laptop is exposed to the internet and I have a passion to learn new software. Due to this, sometimes, I download some random software (unknowingly malware) on my machine and end up in infecting my laptop with a virus.