SQL Server DBCC Commands: DBCC SHOWCONTIG
DBCC SHOWCONTIG is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL… Read More »SQL Server DBCC Commands: DBCC SHOWCONTIG
Fighting back against Ransomware
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them… Read More »Fighting back against Ransomware
Our “Beach Side Cabana with Drink Delivery” SQL Service
Yes, our Managed Services is just that! Well almost. This service is the all-inclusive resort of SQL Services. Take look at what’s included. Agile Support… Read More »Our “Beach Side Cabana with Drink Delivery” SQL Service
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU20 for 2019 (15.0.4312.2 – April 2023) CU18 + GDR (15.0.4280.7 – February… Read More »New SQL Update from Microsoft
20% Off Now Until April 30th
Our comprehensive assessments are designed to evaluate the health and performance of your databases, identifying major and minor issues that need to be addressed. By… Read More »20% Off Now Until April 30th
Join Types On Your Wall
As a long-time SQL Server consultant and database administrator, I understand the importance of having a clear understanding of the different join types available in… Read More »Join Types On Your Wall
SQL Server DBCC Commands: DBCC PAGE
SQL Servers DBCC PAGE command is a powerful tool that allows users to view the contents of a database page at the physical level. This… Read More »SQL Server DBCC Commands: DBCC PAGE
JOIN Types Confusion
As someone who has worked with SQL Server for many years, I know firsthand how confusing it can be to work with different join types.… Read More »JOIN Types Confusion
SQL Server Wait Type: CLR_CRST
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: CLR_CRST
Database Health: Monitoring Backups with Database Health Monitor
Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or… Read More »Database Health: Monitoring Backups with Database Health Monitor