SQL Server: A More Flexible xp_ReadErrorLog That Reads All Error Logs Including Archives

I am sure that all of you are already familiar with the extended stored procedure xp_ReadErrorLog and its less flexible and published equivalent sp_ReadErrorLog (which takes less parameters) for reading the SQL Server Error Log. xp_ReadErrorLog - To read current error log: The extended stored procedure xp_ReadErrorLog is very useful. It helps with reading the … Continue reading SQL Server: A More Flexible xp_ReadErrorLog That Reads All Error Logs Including Archives

Advertisements

PowerShell: Find & Replace SQL Server Stored Procedure Code En Masse Based On Custom Criteria

Today, a need came-up where a bunch of stored procedures had to be altered based on certain criteria. Easy way: Obviously, the easiest way would be to script out the stored procedures to a file/editor and do Find/Replace with the UI dialog. However, this does not work if there are lots of stored procedures and … Continue reading PowerShell: Find & Replace SQL Server Stored Procedure Code En Masse Based On Custom Criteria

PowerShell: Export-QueryToSQLTable – Export All Of Glenn Berry’s DMV’s, sp_WhoIsActive, sp_Blitz & Any Of Your Own Queries To SQL Server Tables

There are native PowerShell cmdlets to export to CSV  or text but I have not seen one that can easily export any SQL query output to a SQL Server table in bulk (Write-DbaDataTable function of dbatools does it for one table which I use in my solution below). I probably did not look too hard … Continue reading PowerShell: Export-QueryToSQLTable – Export All Of Glenn Berry’s DMV’s, sp_WhoIsActive, sp_Blitz & Any Of Your Own Queries To SQL Server Tables

PowerShell – Get Files Modified In A Certain Date Range And Copy/Delete/Zip…whatever

Today a good friend of mine, Damu asked for a function that could copy files from a source to destination based on modified date criteria. Although it could be easily accomplished in the command-line itself, I took upon myself as an exercise to create a wrapper function to do the same in case he wants to … Continue reading PowerShell – Get Files Modified In A Certain Date Range And Copy/Delete/Zip…whatever