Is User Acceptance Testing Covered Under Developer Edition?
Category:
database-administration
Holy mackerel, it is!
Category: database-administration
How to Level Up Your DBA Career (Dear SQL DBA)
Category:
database-administration
, career
You’re a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?
Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)
Category:
database-administration
You’re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?
Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)
Category:
database-administration
Dear SQL DBA, What do you say to a SAN admin when you think that the billion dollar SAN *may* be the bottleneck and you just want to look into it. What are the technical things I need to say to make them believe there might be something to my questions?
Next Door to Derpton - When Your Fellow DBA is a Danger to Databases (Dear SQL DBA)
Category:
database-administration
What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?
Merging Boundary Points: Does a Changing Partition_Number Indicate Data Movement?
Category:
database-administration
I received a question from a reader who was testing out a partitioning architecture:
We are testing table partitioning using one filegroup per partition. When we merge a boundary point, we see that partition_number changes in sys.partitions. Does this mean that data movement is occurring?
Testing an Insert for Race Conditions with Ostress.exe
Category:
database-administration
Whenever we have multiple sessions modifying data, things get tricky. When we have a pattern of “check if the data exists and then do a thing,” multiple sessions get even more complicated.