Muhanned, sorry if we have given you a hard time. It looks like you are very much aware of the issues being raised and are trying to make the...

Fill Factor is an important optimisation option but one that is often not fully understood and could be implemented better within SQL Server.

An important part of DB performance is to...

Merging the databases is a tiny part of what needs to be done.

IMHO the focus should be on the business problem, not on a piece of the technical...

An Audit failure should be treated just the same as any other bug. It needs to be assessed and prioritised. Some bugs may get fixed almost immediately, while...

A little rant... I worked on mainframe systems, and they are documented to the same standards as systems written for Windows...

Remember that the only reason to take a backup is so that you can do a restore.

Your organisation will have a Recovery Time Objective (RTO) which defines how...

My advice: Set compatibility mode to 120 for all DBs until you find a CE problem. You should be doing a lot of testing as part of your move...

If you have the correct SQL install media, the most likely problem is that you are missing some pre-requisite software.

You should check the documentation for the required pre-reqs. The...

Look at Microsoft License Advisor http://mla.microsoft.com/ this will give you basic costs.

Then talk to your normal Microsoft license reseller. Depending on the deal you have, getting additional SQL licences...

One minute to evaluate a CV... luxury! In my last job I worked for a large UK job board, and we frequently asked recruiters for feedback on how they...

When are you planning to go live? If it is June or later then I would recommend using SQL2016 SSRS. You have to look very closely to see...

C-O: column-orientated. The main purpose of my post above was to highlight the internal structure of column-orientated storage is different to row-orientated storage, and that you need to work...

A few years back I was asked to take on a project to find and install a booking system for a hostel run by a charity in India. ...

When loading data into any column-orientated database it is important to know how the underlying architecture works.

Both SQL Server and Redshift have much the same architecture for column-oriented tables. ...

Database Mirroring is available on SQL 2005 SP1 onwards. It is built in to the RTM versions of all more recent versions of SQL Server.

There will be...