Iain Brighton has created a free PowerShell module called „PScribo“ that can be used to easily create documents and reports in text, html, or Word...
database-tools
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Announcing SQL Enterprise Job 2.2 General Availability
We are pleased to announce the general availability of SQL Enterprise Job Manager 2.2. Existing users may upgrade to this version through the IDERA...
Automatic Document & Report Generation (Part 1)
Iain Brighton has created a free PowerShell module called „PScribo“ that can be used to easily create documents and reports in text, html, or Word...
Demystify tempdb performance and manageability
Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is...
Exchanging Variable Values
Here’s a quick tip how to switch variable content in one line: $a = 1 $b = 2 # switch variable content $a, $b = $b, $a $a $b ReTweet this...
Simplify Routine Database Administration Tasks with SQL Admin Toolset
Database Administrators are responsible for an organization’s most important asset - the data. This responsibility comes with many...
Returning Rich Objects from Functions (Part 2)
Whenever a function returns objects with more than four properties, PowerShell formats the output as list, else as table. Before you learn a new...
Returning Rich Objects from Functions (Part 1)
If a PowerShell function needs to return more than one information kind, always make sure you wrap the pieces of information inside a rich object....
Using persisting variables inside functions
By default, when a PowerShell function exits, it “forgets” all internal variables. However, there is a workaround that creates...
Using Default Parameters
If you find yourself always using the same parameter values over again, try using PowerShell default parameters. Here is how: # hash table # Key = #...
Speed Difference: Reading Large Log Files
When it comes to reading large log files and, for example, extracting error messages, PowerShell can either use the low memory pipeline, or the high...
Database Performance History
Servers are moving from on-prem to the cloud. Applications are upgraded, so are operating systems, databases, and hardware. New users,...
Finding Executable for File
Most things can be handled by built-in PowerShell commands, but if that’s not enough, you can always resort to the internal Windows API. For...
Monitoring Master-Slave Replication in MySQL 8
MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient...
Understanding Script Block Logging (Part 7)
This is part 7 of our mini-series covering PowerShell script block logging. We now just need some cleanup tool that can clear the script block...
What’s new in SQL Compliance Manager 5.5
Earlier this month SQL Compliance Manager version 5.5 was released. We're super excited about some of the new features that are...
Understanding Script Block Logging (Part 6)
This is part 6 of our mini-series covering PowerShell script block logging, and it’s time to address a final thing: when you execute very...
Why Data Breach is a Significant Part of GDPR
Last week I spoke at DAMA Day in NYC. The day was focused on GDPR and all of the implications in the regulation. I decided to focus my talk on why...
Understanding Script Block Logging (Part 5)
This is part 5 of our mini-series covering PowerShell script block logging. We are almost done, and what’s missing is a better way to read...
Learn about index fragmentation to improve SQL Server performance
As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered...
Understanding Script Block Logging (Part 4)
This is part 4 of our mini-series covering PowerShell script block logging. By now, you know how to read logged PowerShell code, and how to turn on...
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within...
Understanding Script Block Logging (Part 3)
This is part 3 of our mini-series covering PowerShell script block logging. By default, PowerShell logs only code that is considered security...