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.
Open Source SQL Server Monitoring tool. Just released!
- Should I Store Files in the Database?SQL Server can store binary large objects such as files inside the database. Why might you want to store files inside the database? What problems might it cause and what alternative options should you be considering? Background I have experience managing several large SQL databases consisting of up to 160TB of blob data – using […]
- DBA Dash OverheadIntroduction All monitoring tools have some overhead associated with them but generally, the overhead is low compared to the value they deliver. How much load does DBA Dash add to a server? To find out I setup an extended event to capture the queries ran by the DBA Dash agent. I left the trace running […]