Recently I was required to write a function that would capitalize the 1st letter in every word. This is a fairly common requirement and I felt that there […]
Boolean Hell – Missed rows when grouping in SQL
I was recently asked about the concept of Boolean hell and thought it would be a good post to discuss. Most database professionals should be familiar with the […]
What is the role of the DBA in a Cloudy world?
What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions […]
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.]
Error IDX21323 – RequireNonce is ‘[PII is hidden by default. Set the ‘ShowPII’ flag in IdentityModelEventSource.cs to true to reveal it.] One of the best features of Azure […]
How to add a Next and Previous Post Button to the WordPress site
Adding a next and previous button to the post footer makes navigation much easier for the reader. Imagine a long post with a lot of content. The user […]
Adding a reusable block to the WordPress Site
A great way to add content to a WordPress site is to use reusable blocks. A block as its name suggests is a unit of code representing […]
Adding a subscribe button to your WordPress site
Recently in a move to improve the subscription rate and overall search ranking of my site I decided to add a subscribe button to all my posts. The […]
Database in Suspect: – DBCC CHECKDB – It has been marked suspect by recovery
A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why […]