Browse the archive
When I started travelling to speak at SQL Server events, I committed that I would make the most of it. To me, that means a lot more than just attending the event where I’m speaking. Sure, I want to learn and network at the event, but it means more than that, …
Continue readingAs a DBA, there seems to be a constant trickle of automation where I need to parse a file name out of a full path. So let's parse this stuff in T-SQL, even though other languages might be better for this.
Continue readingFind active SQL Server transactions and avoid leaving uncommitted work that can block other users.
Continue readingA practical approach to monitoring SQL Server blocking and alerting when it becomes disruptive.
Continue readingLearn how to identify the head blocker in SQL Server and trace a blocking chain to its source.
Continue readingQuestion I'm noticing this wait stat on my Azure SQL database, and I've never seen it before. I've tried Googling this wait stat but haven't been able to come up with any good information on what this is, although I saw a couple mentions of it possibly being …
Continue readingQuestion I have a SQL database that is hosted on Azure. The problem is that the size is getting out of control, I can see up to 99% fragmentation in the Primary Key clustered indexes. I'm able to rebuild all other indexes with online=on option and it won't …
Continue readingIn this post, I walk through identifying and fixing a serious performance issue with a multi-statement TVF in Dynamics CRM.
Continue readingQuestion My problem: I have a set of views from which I want to query dynamically. I want to load the view names by SELECT * from sys.all_views into a cursor (let's call it view_cursor) and then do something like this in a procedure:
Continue readingQuestion This is in relation to a rollback scenario from a 2012 -> 2016 upgrade. The scenario is that the SQL Server 2012 database is restored onto 2016 and log files applied until it is up to date. Then production systems are cut over to 2016. Database is …
Continue reading
