Blog

Restoring a Database With CDC Enabled

When you need to restore a database to a different SQL Server instance, or perhaps to the same instance with a different database name, it’s a pretty standard affair. Just backup the database, then restore it in the location you want. Easy as that, you’ve got the same database restored with all the data it…

What Firewall Port does the DAC require

Now that you know how to enable the DAC and how to use it, you might want to know what firewall port the DAC listens on and how to set it. With your SQL Server instances, you can easily set which firewall port you want it to listen on in SQL Server Configuration Manager. Unfortunately…

Enable the Dedicated Admin Connection (DAC) and How to Use it

If you ever find your SQL Server instance runs into some serious performance issues, you might find it’s so bad, that you can’t even connect to the instance. If only you could connect to run your usual troubleshooting queries to find out what’s going wrong and hopefully fix it! This is where the Dedicated Admin…

How to Rename a Table Name or a Column Name

So, you want rename a table, or a column name? It’s a simple command, but it’s one of those commands I don’t use often and therefore forget how to write it every time I need to use it. Maybe you’re like me and can’t remember how it should be written too. Keep reading… To do…

Partial Database Backups and Restores with Read-Only Filegroups

Supporting and maintaining a very large database can come with it’s challenges. One of them being the backup and restore strategy. The backup sizes are huge and the duration of the full backup is very long, often too long. A common approach to improving that is to split the database into multiple files and filegroups…

Recovering a Database in Restoring State Leaves Broker Disabled

Earlier this week I came across an interesting situation where a tail log backup of some databases were taken before a migration – meaning a final transaction log backup was taken and the database was set into RESTORING state. The interesting part came where we recovered the same database on the same server (not restored…

How to Silently Install SQL Server Management Studio

If you find that you’re installing SQL Server Management Studio (SSMS) often or on many servers, you might find that installing it silently, a.k.a. unattended, is more suitable than installing it through the usual method using the install wizard. First, you can download the latest SSMS installer from Microsoft’s SSMS download page, or from this…

Performance Testing a New SQL Server

When you build and configure a new SQL Server, one of the many things you should be doing is testing how it performs before it goes live. If you don’t do that, then you probably should have a hard think about doing so. It’s important the performance of the new server is tested to ensure…

Configure Database Mail and Test it – All using T-SQL

When configuring a new SQL Server instance, you probably want to configure Database Mail. As with all your post install configuration changes, it’s better to do it using a script to save yourself a whole heap of time while ensuring all your SQL Server instances are standardised and consistent. Unfortunately it’s not as easy to…

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.