SOURCE CODE ATTRIBUTION: Before I proceed, I want to give credit to the original procedure by sfrejofsky based on which I created this procedure (mostly improvements). The source of this procedure is https://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query I had a need to do dynamic PIVOTing for one of my projects and instead of reinventing the wheel, I used the … Continue reading SQL Server – Dynamically PIVOT ANY Column On ANY Table in ANY Database For ANY Aggregation With ANY Condition
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
Permissions are complex! Permissions management is not easy. You have a lot to deal with Direct user privileges via grants Privileges to AD Group login of which user is part of User could be part of multiple AD groups which have a login on the instance Privileges granted to the role that user is in … Continue reading SQL Server – Find Effective Permissions of An User At Database, Server or Object Level – The Right Way!
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?
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