Also, the session settings XACT_ABORT or ARITHABORT can influence behavior of stored procedure to an error.

A T-SQL step within a job will by default run under the security context of the SQLAgent service account or alternately under context of a proxy account that you have...

As a start, run a report on historical page life expectancy.

Look into implementing TDE (transparent database encryption). It will automagicly keep your data pages encrypted, so database files and backups are not readable should they fall into enemy hands. Once...

An operating system is to a database server what a buyer/seller agent, attorney, and county clerk are to a real-estate purchase. It's entirely reasonable to ask what the middle men...

But, backups were (sort of) easy, teach the customer to make sure everyone had closed out of the application and set them up with a DOS batch file to...

Back in early 90's, I too worked with a dBase clone called FoxPro.
OMG! If we opened the .dbf file in the FoxPro IDE to run and ad-hoc query,...

It is also possible to have perfectly good backups, but then loose the keys. For example, iIf TDE is enabled on a database, then backups are encrypted by default, so...

When participating in an interview, I'll often ask the candidate open ended questions similar to this. It's a lot more telling than a simple question about "What is a clustered...

The data management view [sys.dm_db_index_usage_stats] aggregates statistics like total reads / writes, last read / write datetime, etc. However, the counters do get reset whenever the server is restarted. The...