Speaking from experience here, look for lists of interview questions on this site and on others. The idea is not to do a brain dump, but look for the topics...

You can also use:

DBCC TRACEON (3604)

GO

DBCC DBINFO (dbname-here)

It also has last dbcc checkdb date, and plenty of other stuff.

Full disclosure, someone stumped me on an interview...

If many/most of your meetings are conference calls, you'll love this:

https://www.youtube.com/watch?v=zbJAJEtNUX0

My manager's manager told us it was shown at off-site for higher ups as an example of what...

Just type 'script foreign keys' in the search box on this page, and you'll see a number of script in the search results.

You can script out the foreign keys, drop them, and re-add after copying over the data. The script library here has several such scripts. Use the import data wizard to...

Sometimes, getting all three can be possible. For example, if code is available for reuse, and there are good processes and standards in place, the wheel won't constantly have to...

Here are a couple of things to consider:

1) Backup. As much fun as it will be to have that many databases, there will be an equal multiplier of database and...

Years ago, I'd say I 'Information technology'. People older than me would then say: 'so you're in computers', to which I'd reply: 'I don't sit in the computer'. That worked...

Try looking for a statistical analysis job that lists 'some familiarity with SQL Server' as a nice-to-have. Over the years, I worked with quite a few people who started in...

You should consider whether you want your SQL Server instance failing over without warning, possibly during normal business hours. It might be a better idea to have your monitoring tool...

Here is the link to an article on SportsIllustrated.com on the pressures faced by women and minority sports writers and reporters.

http://sportsillustrated.cnn.com/more/news/20140330/race-sports-media-panel-racism-sexism/?eref=sihp

The very first question is regarding comments...

What you need to do is to figure out what is normal, and adjust the alert threshold accordingly. For example, it is normal to alert drive utilization at 80%, 90%,...

It's after the fact by now, but in situations like this, there is likely to be something else using those spindles that is causing the slowdown on the SQL Server...

In shops that I have worked in that used clustering, DR involved some form of DNS rename. So you have ClusterA, SQLServerA in production, and create ClusterB, SQLServerB, etc. with...

The traffic graphic is my favorite, as anything in the New York City area that is called an expressway is more likely to look like a parking lot most of...