Pages

▼
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...
Monday, 15 February 2016

Transactional Replication and Change Data Capture: The Log Reader Agent Conflict

›
Behind close doors of SQL Server, the following issue may be raised when Transactional Replication and Change Data Capture (CDC) are deploye...
1 comment:
Saturday, 13 February 2016

Looking into some concepts about the well-known tempdb database

›
Today's post is going to look into some concepts about the well-known tempdb database. As DBAs, we have to keep an eye on it not only at...
Monday, 8 February 2016

Using KEEP_CDC option to keep CDC metadata

›
Having a database with Change Data Capture (CDC) enabled, we will need to take this recommendation into consideration during the restore pro...