SQL Server Education (by the geeks, for the geeks)
Hello Geeks, The time is flying by as I rejoice in the aftermath of the SQLServerGeeks Annual Summit 2015. It has been a wonderful event and once in a life time …
Backup and Restore Sequence in SQL Server Read MoreHello Geeks, My good friend Jay Vemula has posted a blog about an error you may face if you are selecting all features while installing SQL Server 2016. As a DBA, …
TempDB Configuration – SQL Server 2016 Setup Read MoreProblem Statement: Theoretically online index rebuild does not block. Practically boom… They do. Online index rebuild operations does not take down your indexes. But there is a point in the index …
Hidden Gems of SQL Server 2014 – Managed Lock Priority Read MoreSQL Server Get free space in all files in an Instance: As DBAs we are always challenged of unexpected size growth of log or data files and need to shrink files …
SQL Server Get free space in all files in an Instance Read MoreHello, Recently we had an issue with chain blocking and most of the jobs are complete but do not finish. When observed in Job Activity Monitor most of the jobs say …
SQL Server Job Performing Completion Actions Blocked: An Interesting case Read MoreInstall SQL 2005 cluster on Windows 2008 R2. It’s always a new issue. Most of them are known. But last night I installed SQL server 2005 cluster on Windows 2008 R2 …
SQL Server – Cluster resource ‘SQL Server’ in clustered service or application ‘[ServerName] (MSSQLServer)’ failed. Read MoreMany DBAs need to perform SQL Server security audit and save the permissions for each account at server level and database level. This will be done time to time and verified …
SQL Server Security Audit – A (time consuming) task for DBA simplified Read MoreHello, I had a SQL Server fee disk space monitor job in my environment which throws an alert when the free space on any drive drops below a threshold free space. …
SQL Server Free Disk Space Monitor Alerts – SQL Script Read MoreHello Geeks, I have been writing technical blogs for some time now. Thank you for following my One DMV a Day series, a wonderful sprint of 80 days. It has been …
DBA – How to choose a career path Read MoreHello Geeks and welcome to the Day 80 of the long series of One DMV a day. Finally the day has come to end this series. A journey started on 18th …
Consolidated DMV Series – Final Part – Day 80 – One DMV a Day Read More