SQL Server 2012: Working with the PowerShell Environment

The initially PowerShell integrated with SQL Server 2008 as mini-shell with limited options. Now the Microsoft launched fully functional PowerShell with SQL Server 2012. The PowerShell is a powerful scripting shell for administrators and developers to automate different tasks of the SQL Server. PowerShell is becoming more central to the Windows management model and can […]

September 15, 2016 SQL Server

September 14, 2016

MySQL: Function to Split String Value Using Different Delimiters and Position

September 13, 2016

PostgreSQL: CREATE PIVOT TABLE to arrange Rows into Columns form

September 12, 2016

PostgreSQL: File System Level Backup to just Copy DATA Directory

September 11, 2016

PostgreSQL: Create or Change default Tablespace of Table to Migrate on SSD

September 10, 2016

PostgreSQL: Script to find TOP 10 Long Running Queries using pg_stat_statements (Day 2/2)

September 9, 2016

PostgreSQL: Track ALL SQL Query Execution Statistics using pg_stat_statements Extension (Day 1/2)

September 8, 2016

PostgreSQL: Using EXPLAIN ANALYZE, Know your Query Execution Plan

September 7, 2016

PostgreSQL 9.1 is going to Shutdown, no more Support and Release Update

September 6, 2016

PostgreSQL: Script to find information about the Locks held by Open Transactions (pg_locks)

Older posts Newer posts

About Me!