-
Audit SQL Server login activity with Extended Events: Who connected, when, from where, how often & verify connection pooling
No comments on Audit SQL Server login activity with Extended Events: Who connected, when, from where, how often & verify connection poolingSQL Server Extened Events provide a light weight mechanism for tracking and monitoring various things in SQL Server. In this post, I am going to
-
Reclaim wasted disk space! Have you got gigabytes of unwanted database files quietly eating storage on your SQL Server disks?
This article provides you with a script that identifies all the unwanted, unused files sitting on your SQL Server data and transaction log disks without your knowledge. It also provides you the necessary commands for deleting the junk files.
-
Using Extended Events, how to track who is using a table/view/stored procedure etc. in my SQL Server database?
This article will show you how to identify which user, application or login is using a database object (table/view/stored procedure etc.) in your database. This technique uses the lock_acquired event via extended events. Very useful if you are looking to find out is anyone is using a database object, before dropping it.
-
Script to generate the setspn commands required to create/register SPNs for Always On & standalone SQL Server service accounts
This article offers a script that generates all the necessary setspn commands required to create the SPNs for Always On and standalone SQL Server instance service accounts. Once you run these setspn commands, the SPNs get created and registered in the Active Directory (AD)
-
In a distributed Always On AG setup, how to check the database synchronisation and health status across all nodes/replicas?
This post shows you how to check the synchronisation and health status of your databases and replicas across a distributed Always On setup. The built-in Always On dashboard does not show this information for distributed Always On setups.
-
SQLScriptRunner: A free PowerShell tool for deploying/executing scripts across multiple SQL Servers
Need to run or deploy scripts across multiple SQL Servers in your estate? This page provides you with a free PowerShell script that can be used to deploy or execute SQL Server scripts across any number of SQL Servers in your estate.
-
How to identify and fix all logins with invalid default databases? (Error 4064)
This article shows you how to identify all those logins on your SQL Server instances which have an invalid default dataabase that no longer exists. This article also shows you how to manage this situatoin, and provides you a stored procedure that resolves the issue.
-
How to perform case sensitive searches on SQL Server database columns?
This article shows you how to perform case sensitive searches on the data from the SQL Server table columns. It discusses the pros and cons of different case sensitive search approaches and their performance implications
-
What is SQL Injection? How to prevent it? Examples, best practices, tips and tricks to safeguard your SQL Server databases
This article explains what SQL Injection is, how it works, with easy to understand examples. It also discusses the preventive measures you can take to defend against SQL Injection, along with security best practices, tips and tricks
-
How to check the last backup date of every database on your SQL Server?
This article provides a script to display the last backup date of all the database on your SQL Server. This covers the three main types of backups (full backup, transaction log backup and differential backup)
