There are a lot of DBAs who still don't even know T-SQL programming, execution plan analysis, or SSIS. If you havn't already, then learn that before straying into the deep...

... I bring this up because I’ve recently heard several people tell me something along the lines of “Well, if my company wants me to learn new technology, they’ll...

Maybe use this default trace query to get a feel for when log file growth events are occurring, the frequency, and what process is triggering it.

select
  te.name...

... As I've looked back, I realize it was a dysfunctional company, but I think I could have made a difference, stepped up as CTO (it was offered to...

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...