Notes on SQL

Random articles from a puzzled DBA

Introduction I needed a process that could copy the contents of a specific list of tables, from one database to another. PowerShell seemed to be the best fit, for my purposes. As with any tool that you don’t use regularly, more than half of the battle is finding the correct commands and methodology. Background A …

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.

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 …

Continue reading

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 …

Continue reading