“Instrument your code – Basic TSQL Logging” presentation

Thanks to everyone who attended my "Instrument your code - Basic TSQL Logging" presentation. The material accompanying the presentation is available for download here: https://onedrive.live.com/?id=74472AED60B210DA%211183&cid=74472AED60B210DA The source  code is open-source and the community is encouraged to enhance and update. The Github home for it is https://github.com/SQLJana/TSQL_Logger Feel free to experiment with the code and post feedback/comments and file … Continue reading “Instrument your code – Basic TSQL Logging” presentation

Advertisements

Oracle or SQL Server – How to Find the Instance Startup Time?

SQL Server A DBA or developer might have a simple question – “Since when has my SQL Server instance been continuously running?”. There are many places to look but the easiest is to look at the creation date of the system “tempdb” database. Now, to the question of why? TempDB is special in a lot … Continue reading Oracle or SQL Server – How to Find the Instance Startup Time?

SQL Server – PIVOT Data With TSQL

Note: Although I wrote this in year 2012, it is still valid. If you are looking to convert rows to a CSV string and vice versa in Oracle, please read my related post on that here. If you are a serious PIVOT'er, I know that you would use Excel or Power Pivot or Power BI. … Continue reading SQL Server – PIVOT Data With TSQL