-
Identifying SQL Server cross-database dependencies when migrating
No comments on Identifying SQL Server cross-database dependencies when migratingAre you moving a database to a different SQL Server? Worried the database might have cross-database dependency on other databases that are not part of this move? This post will show you how to identify any cross-database dependencies as part of your pre-checks for the migration
-
Management Studio tip – A menu driven RunAs launcher batch file to open SSMS using multiple different login credentials
Tired of repeatedly launching SQL Server Management Studio (SSMS) with different Windows accounts? This post provides a lightweight, menu-driven batch file that lets you choose the required security context and open SSMS instantly. It’s a simple productivity tool that’s ideal for DBAs and developers who regularly work across multiple domains, environments, or privileged accounts.
-
dutyDBA Case Files #2 – Who dropped the tables and deleted/recreated stored procedures on the production database?
In this edition of dutyDBA case files, I show you how to investigate an unauthorised production database change to figure out who made the changes. This walks you through the process of recovering from the application outage, and identifying the root cause.
-
How to compare the server configuration and settings (sp_configure settings) of two SQL instances and identify the differences?
Have you ever wanted to compare the server configuration settings of two SQL Servers, but struggled with creating linked servers between the servers or by manually comparing the data? No longer! This post provides you with a PowerShell script, that takes two SQL Server names as input parameters, quickly compares the server configuration and highlights…
-
SQL Server ‘max server memory (MB)’ – the magic formula for calculating buffer pool size
As an SQL Server DBA, have you got a formula for calculating the value for ‘max server memory (MB)’ parameter, that restricts the memory used by SQL Server buffer pool? If not, read on and use the script provided in this post, to come up with a suitable value using various different formulae.
-
Script for a quick SQL Server memory overview – useful for creating a snapshot of current memory configuration
This post provides a quick memory overview of your SQL Server. The output includes the total amount of RAM on the SQL Server box, amount of unused RAM at host level, SQL Server memory allocations, current buffer pool and procedure cache sizes.
-
Robot vs Router – Vodafone ultra hub firmware update clashed with a robot vacuum cleaner, resulting in internet outage
This post is about a strange issue I’ve had with my Vodafone WiFi 7 Ultra Hub. A firmware update pushed by Vodafone caused a clash with my smart robot vacuum cleaner, resulting in loss of internet access for over two days.
-
Too many Extended Events sessions? Take control, see what’s running and stop unnecessary sessions
Have you got too many extended events sessions running on your production server? Not sure which ones are running and which ones are needed? Read this article and learn how to take control of your extended events sessions
-
dutyDBA Case Files #1 – Unable to change the database owner on secondary replicas to sa
This case notes is from a real world incident, where a DBA account could not be dropped because it owns the databases on an Always On secondary replica. I investigate how it happened and show you how to resolve it, and prevent it from happening again.
-
Audit SQL Server login activity with Extended Events: Who connected, when, from where, how often & verify connection pooling
This article provides you with a stored procedure that sets up an Extended Events session in SQL Server to track all the successful logins. It then summarises the data from the .XEL file into usable format, so you can see which logins are connecting from where, via which application, how often they connect, is connection…
