Introduction
The Microsoft documentation tells us that the SessionId column, within ASPStateTempSessions, consists of the Session ID plus the App ID. Although accurate, the method used for this does not make it obvious.
PowerShell to Remove Old SQL Error Logs
28 Feb
Introduction
In a previous article article, I wrote about how to find out where the SQL Server error log is located. That particular article was in case your server instance did not start and you needed more information.
If your SQL Server instance is working, there is another way to find the location of the error logs – with a SQL query, which can then be used within PowerShell.
Partial Restore from a Full Backup
28 Oct
Background
So, you have a multi-terabyte database and a SQL Server full backup. Just imagine that you do something that wrecks the data in one table (and of course, that has never happened), the only secure copy is within a backup file that will take several hours to restore and you don’t have the time or the space for such an act. Continue reading
Installing PowerShell Module Without Internet Access
30 Sep
Background
I need to install a new PowerShell module onto a server that has no access to the Internet, so I am unable to use the Install-Module command.
Continue reading
Availability Groups Can Use Snapshot Isolation
7 Aug
Background
Whilst reading up on the finer details of High Availability Groups (HA Groups) I have discovered that it can, under certain circumstances, use Snapshot Isolation Level and therefore, row versioning. This has implications with your monitoring and maintenance tasks.
Continue reading
Unable to connect to AG when DB suspended from data movements
22 Jul
Background
Because one of the nodes in our AG was having Windows updates applied, it was necessary to suspend data movements for all databases involved in the AG, on that server. Upon my return (after the maintenance was completed) I was unable to connect to the server, with a message that didn’t really match the circumstances – or so I believed.
XML AUTO – Basic Examples
20 Jun
Introduction
Continuing my series of XML articles I’m going to move from XML RAW to XML AUTO with a handful of examples that share features between the two. Continue reading
Recent Comments