Query [backupset] to see if something odd sticks out.

use msdb
SELECT backupset.database_name, recovery_model,
  MAX(CASE WHEN backupset.type = 'D' THEN backupset.backup_finish_date ELSE NULL END) AS LastFullBackup,
  MAX(CASE...

So, your bossy man doesn't want any gaps in this sequential ID column, even after rows are deleted? The next time you catch him in a relaxed mood, ask him...

Perhaps others have had different experiences, but from I've seen over the past 25 years, the IT industry actually tends to have more diverse teams than other industries, especially since...

When SQL Server 2005 was released, the new XML features were much hyped, and that hype has been reflected in subsequent certification exams. Now, 12 years later, the prevalence of...

What exactly will you be doing, building and administrating the data warehouse, essentially a one-man show?
Managing a team of data warehouse developers?

The following books cover requirements gathering,...

Four years down the road, and we now find ourselves in a society even more divided by identity and tribalism. However, I will say that those of us who work...

If you don't know the covered material and have no interest in learning, then why bother sitting for the exam? Perhaps the Administration or Azure related example would be more...

As far as I know, the only CLR based functions we're using across the enterprise is a 3rd party library called Voltage for encryption and decryption on personal identifier columns....

Issues with the server's cooling fan can cause the CPU to intermittently slow down or freeze, and the same for system processes like virus scanner or auto updates.

If you have a change control process and/or continuous integration process in place, then you can refer to that to see what recent deployments have occurred, not just on the...

I like INFORMATION_SCHEMA views because they are denormalized and easy to use. For example, the COLUMNS view returns information that would require joining a half dozen SYS tables. If I...

The crux of this equation is the Understanding part and how much risk all parties involved are willing to take. Branson's company is quite large today, and a lot of...