Pages

▼
Thursday, 30 June 2016

Error 20598: The row was not found at the Subscriber when applying the replicated command

›
Having transactional replication environments with read-only subscribers (which means that changes are not propagated back to the publisher)...
Friday, 3 June 2016

How to move the files of database which has Replication, Mirroring, Log Shipping or AlwaysOn Settings

›
One of the challenging tasks in the life of a DBA is definitely moving all or some of the files of a database from one physical location to ...
Wednesday, 1 June 2016

How to test Read-Only Intent Connection from SQL Management Studio

›
As part of some SQL Server AlwaysOn Availability implementations, we may need to test Read-Only Intent Connection in someway to make sure th...
Tuesday, 24 May 2016

How to change collation of all columns

›
Just thinking about some interesting tools that could be useful for doing some DBA tasks, I would like to share my code to change the collat...
Sunday, 1 May 2016

AlwaysOn AG Listener: The attempt to create the network name and IP address for the listener failed

›
While working on a heap of High Availability and Disaster Recovery solutions, I was challenged to deal with some complex errors that I had t...
Saturday, 30 April 2016

Reusing SQL Job creating script to create new similar ones with different Schedule ID

›
As we now it is very important to look for new ways of being more productive every day. For instance, one of our tasks as DBA is to implemen...
Wednesday, 9 March 2016

SQL Server Analysis Services Error: The following system error occurred: (Microsoft.AnalysisServices)

›
Clearly, while adding some users as Windows Administrators, not only do we do that, but also we add them as Administrator of Analysis Servic...
Friday, 4 March 2016

How to split the tempdb database into more files

›
Naturally, as DBAs we do know is mandatory to modify data and log properties of the tempdb database . Unless we do a customized configuratio...