I suggest you use the most recent training material you can find.

There is very little that was in SQL 2012 that is not in SQL 2016, the main...

What kevaburg says works on all versions of SQL Server above SQL 2005 (it probably works on SQL2005 but I have not tested it there).

You can also use this technique...

When I left school in the early 1970s, almost 40% of kids my age struggled to get good grades at the age 16 exams. The UK Government statistics show...

I know you are trying to replace full values with abbreviations and probably have good reasons to do this. However, if this was my system I would be looking...

Going back to Krasavita's original question: how long will it take to back up 600GB?

As seen in the replies, the answer depends on many things. To a large extent,...

The SQL 2005 backward compatibility pack can be installed with any version of SQL Server above SQL 2005. It is not needed with anyt version, unless you want to...

Definitely you need to know which attributes relate to Facts and which relate to Dimensions.

As a starting point, if the attribute is numeric and the aggregated value of...

SSAS will probably be useful for a few years to come, but R Services will become the main analysis tool of the future. I would not be surprised if...

Please do not uninstall any version of .Net on any box you hope to continue to use. There are a vast number of inter-dependencies that may get broken. ...

When I was Architect at Totaljobs Group we implemented P2P replication.

One of our design criteria was to reduce operational risk. We already had our applications written to...

Most people who read this will have charities nearby that could really use some part-time technical support. It is worth finding one that works in a field you like...

When you uninstalled your ins1, ins2, did you clean out the redundant virtual names from AD?

If AD still has an entry that relates to the original ins1 Agent...

I think both the original code and all the alternatives suggested would prevent the use of an index to resolve the clause using pdenddate. This is due to the...

Agreed!! If you are concerned about storing a virus, then most A/V products have an API that allows a .Net application...

Are you able to post the consultant's reasons for wanting to make this change. It would be interesting to see what reasons are given, and what the risk/benefit analysis...