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 thru the forums in Technet I came across a post today regarding the support for data mining in future versions of SQL. For those who are […]
Indexes and lookups
Recompiling a stored procedure and rebuilding indexes is something that many DBAs are familiar with but even then there are a lot of misunderstandings about how the process […]
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 message when setting up database mirroring
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 ‘TCP://XXXXXX:2022’. The […]
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: – Errors cannot drop distribution database
When removing replication from a server using the wizard you might get the below error message if you choose to drop the distribution database. The reason for the […]
SQL Server Replication Series Part 1
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 SQL Server 2008 […]