Archive | SQL RSS feed for this section

ASPState – Where Does the AppID Hide in SessionID?

6 Mar

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.

Continue reading

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.

Continue reading

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

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

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

XML RAW, ELEMENTS and ROOT – Basic Examples

29 Apr

Introduction

Most systems that I have worked with make use of the XML data type. I don’t find it to be the most intuitive data type to work with but most aspects of it can be built upon from a few basic examples. This will be part of a developing series that will cover XML and JSON. Continue reading