As with any installation of SQL server we start with the licensing of SQL Server 2014. Most DBAs are unaware of the implications of licensing costs on the […]
SQL 2014 Series
Starting today we are launching a new series on topics related to SQL Server 2014. Free videos and tutorials on key new features as well as some interesting […]
SQL Server Replication Series: – Server is not configured as a distributor.
When setting up a distribution database using the wizard, if you select the second radio button from the below screen you need to already have configured the distribution […]
SQL Server Replication Series: – Configuring the distributor
In this blog we will look at how to configure the distribution database for SQL Server replication. The distribution database is a very important database in replication as […]
SQL Server Replication Series: – Removing Replication
Most times we do not remove replication from a server once it’s been setup but there are occasional scenarios where it may be required. E.g. when decommissioning a […]
Key columns and the clustered index
I was recently asked if there was any importance of the primary key clustered index in terms of performance. While the answer is obvious I wanted to explore […]
Generate Create and insert scripts for database objects from within SSMS
In this post we explore the option within SSMS which allows the DBA and developer to generate scripts for all data and database objects within SQL Server Database. […]
Always use source control
One important thing I learned early on in my career is that source control is important. It is a shame when weeks or month worth of effort gets […]
SQL Server Replication Series – Fixing “Cannot Drop Distribution Database” Error
When removing replication using the wizard, you may encounter the following error message: Msg 21122, Level 16, State 1, Procedure sp_dropdistributiondb …Cannot drop the distribution database ‘distribution’ because […]
SQL Server Replication Series Part 1
Introduction and Concepts This blog is the first in a series on the topic of SQL Server replication. The topics are the same for the most part for […]