Another thing to consider is that there is zero ROI in upgrading existing systems. During economic downturns, these type of upgrades are the first things to go when 'doing more...

Is all of the server maintenance relatively up to date? At a previous job, we were very much behind, and Microsoft blamed many of our problems on that.

We use Availability Groups in some of our production systems and replication in others, and yes, Microsoft does not make life easy for what you are trying to do. Best...

Try this: http://www.sqlservercentral.com/articles/execute+process+task/129996/

Here is an old standby. Start SQL Server from the command prompt with the '-m' option. Connect with sqlcmd (SSMS may try to create more than one connection) and create...

A couple of things learned from personal experience.

Sign up at ilostmyjob.com. There are weekly free webinars on many job search topics, including LinkedIn. As mentioned above, LinkedIn is probably the...

This sounds like a Big Data project, to find things that spam postings have in common, but not legitimate posts.

Even the term 'database' can mean many different things, depending on whether you are running on SQL Server, Oracle, DB2 mainframe or AIX, Access, or just the textbook definition.

Based on my experience, staging could be the +1 version of production, but it could also be the place where they work on bugs that only show up with specific...

Especially in the IT world, work experience and a portfolio can compliment each other. Someone who is a SQL Server DBA for a paycheck, might be doing some Big Data...

Try monitoring sys.dm_db_index_usage_stats for a while. Should tell you if the indexes are used often enough to keep them around..

Perhaps you could set something up where they update a flag in a table indicating that they want their database to be backed up. Then you set up a job...

While it seems logical to say that all downtime counts, the real issue is what the user is paying for. A multi-tier, public facing system is going to cost a...

Simply not allowing access would put the person using the duress password at risk of serious injury or death. The duress code would have to lock down the building, but...

In the Charlie Hebdo attack, the terrorists forced an employee at gunpoint to swipe her card to get into the building. So a duress password on top of the physical...