There are a number of reasons why the SQL Server service may fail to start most of the time it has to do with the permissions of the […]
Data mining in SQL Server
While browsing the TechNet forums, I came across a discussion about the future of data mining support in SQL Server. For those who are currently using SQL Server […]
Understanding Indexes and Lookups in SQL Server: Execution Plans and Performance Tuning
This post provides a practical walkthrough on how index creation and modification affect execution plans, particularly in SQL Server 2008 R2 using FactResellerSales and DimProduct tables from the […]
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 […]
“ALTER DATABASE” failed error when configuring mirroring
Error Message TITLE: Microsoft SQL Server Management Studio —————————— Alter failed for Database ‘Mirror’. (Microsoft.SqlServer.Smo) The ALTER DATABASE command could not be sent to the remote server instance […]
Adding a parameter to the Report
We add parameters to reports to be able to dynamically fetch very selective data from the underlying database. Sometimes parameters are used for controlling the behaviour of a […]
Loading data from Excel AcquireConnection Error
[Excel Source [108]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303. There may be error […]
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 […]