In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results, and started...
database-tools
Simple Worthwhile Database Security Practices – Part I
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Using AD Filters with Cmdlets (Part 2)
In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results. You learned...
How to Start SQL Server Performance Tuning
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Using AD Filters with Cmdlets (Part 1)
The free RSAT tools come with the ActiveDirectory PowerShell module. You can use the cmdlets from this module to retrieve AD information such as...
Creating Temp File Names
Whenever you write information to disk, it makes sense to use unique temporary file names. If you use static file names and run your code more than...
Indexes: Friend or Foe?
No matter what database you’re working with, at some point performance becomes an issue which may require further investigation into possible...
File System Stress Test
If you’d like to generate super large files for stress test purposes, you don’t have to waste time pumping data into a file to make it...
Passing Commands via Parameter
Here is a rather unusual use case for function parameters: a user can pass an output command: function Get-ProcessList { param ( [string]...
Five reasons your SQL Server is slow
Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many...
Is Data Governance important to you? Then Data Modeling should be too!
Data governance is a hot topic lately. Companies are trying to devise and implement governance programs in order to provide some structure around...
Dealing with File Encoding and BOM
When you write text content to a file, PowerShell cmdlets let you specify the encoding. Encoding determines how characters are stored, and when...
Finding Nested Active Directory Memberships (Part 3)
In the previous tip we illustrated how you can find out the direct and indirect group memberships for a user. If you’d like to know the...
Using the SQLDM PowerShell Snap-in to Register Several Instances
When deploying SQL Diagnostic Manager for the first time, it may be necessary to register several SQL Server instances that are to be monitored by...
Finding Nested Active Directory Memberships (Part 2)
In the previous tip we illustrated how you can use the cmdlets in the ActiveDirectory module to find all direct and indirect memberships for an...
Finding Nested Active Directory Memberships (Part 1)
The ActiveDirectory module (part of the free RSAT tools) provides a number of AD cmdlets. One of these can dump all direct group memberships, for...
GDPR and the SQL Security Suite
On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect. This regulation affects anyone who collects PII (Personally...
Announcing ER/Studio 17.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number...
August #SQLChat – SQL Server Coding Standards
Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA...
Progress Bar Timer
Here is a simple example using the PowerShell progress bar. The code displays a progress bar counting down a break. Simply adjust the number of...
Top 5 SQL Server cluster setup mistakes
Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of...
Automatic Document & Report Generation (Part 5)
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...
Automatic Document & Report Generation (Part 4)
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...
Automatic Document & Report Generation (Part 3)
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...