Hi, I’m David Wiseman.
I’m a SQL Server DBA that enjoys performance tuning and spend most of my time writing and tuning T-SQL code. This is my personal blog site to share my experience, scripts and tools with the community.
- Get drive data for ALL drives in T-SQLThere are a few methods you can use to get drive information using T-SQL. The problem is all these methods have some limitations. They provide free space but not drive capacity or they only provide data for volumes that contain database files. Ideally Microsoft would provide an easy way to get both drive capacity and […]
- How to handle SQL Agent Jobs with Always On Availability Groups?Introduction When you configure your SQL servers for high availability you want the failover to be as seamless as possible. If you use availability groups, mirroring or log shipping as part of your high availability strategy you will need to take care of anything that lives outside the context of your databases. That might include […]