No.
Well, that was easy – I should write more articles that succinctly. Although the real answer, is of course – it depends.
Continue reading
Background
I have a series of articles lined up, which require showing details of the log file. Using fn_dblog can be a series of articles in itself, so I’m covering a few basic scenarios here first.
Continue reading
Background
SQL Server Management Studio (SSMS) is now a separate installation, so it can be updated without any impact on the SQL Server engine. Updating the newer versions is as easy as you would expect but removing an older SSMS that was included as part of SQL Server requires a little bit of concentration.
Continue reading
Introduction
Using a synonym is a way to create a different ‘pointer’ to a database object. This can be used to provide an alternative name for an object, or even an alternative location, such as a different database.
Continue reading
Introduction
Binary Large Objects (BLOB) data can be a graphical image, a pdf document, a music file or any of a wide range of data types, which can generally be saved into a SQL Server database.
As part of a series of investigations I’m currently performing within SQL Server, I have looked at how BLOB data can be saved and retrieved.
Saving the data is reasonably simple. Retrieving it, less so….
Continue reading
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.
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.
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
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
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
Notes on SQL 