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 and […]
Popular Posts
Trending Posts
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
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.]
One of the best features of Azure is the ability to authenticate with Azure Active Directory. This is easy to implement and therefore a very nice way to […]
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 a […]
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 […]
SEO – Expire Headers for WordPress site hosted on IIS
One of the most important things you can do to improve your Google search index ranking is to improve the load time of your website. What this means […]
Memory for Servers – Hardware
Most database administrators are at least to some extent familiar with what memory does for SQL server. This is especially true for scenarios such as configuring minimum memory in maximum memory, checkpoint, lazy […]