If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
database-tools
Get French Holidays
I saw this blog post and I decided to publish this one for France. Here is a PowerShell function that gets all French holidays…
Compliance and Backup Strategy: A Closer Look at the Connection
The Intersection of Compliance and Digital Data Organizations of all sizes and shapes must comply with government and industry regulations. Some...
Macros – Using macros to create Data Vault objects
Some years ago, Sultan shared a post regarding Data Vault modeling with ER/Studio. I strongly recommend to read it before this one. The different Data…
Announcing the General Availability of IDERA SQL Compliance Manager 6.1
Introducing IDERA SQL Compliance Manager 6.1: The Latest Release of Our Leading SQL Server Auditing Solution SQL Compliance Manager is the leading...
Temperature Control for Windows Systems
Windows laptops (and servers, too) can get hot, especially during summer. Surprisingly, there is no simple built-in way in Windows to monitor...
Get German Holidays
Here is a PowerShell function that gets all German holidays, either nationwide or just for your state: function Get-GermanHoliday { param (...
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 2
In Part 1, we discussed the properties of big data and how it affects the data gathered in the healthcare industry. Here we go over methods for...
Finding Start Time Degradation
With Administrator privileges, a Windows system provides access to the diagnostic data gathered during startup. Windows logs the start time and...
Announcing the General Availability of IDERA SQL Secure 4.3
We are excited to announce the general availability of IDERA SQL Secure 4.3. IDERA SQL Secure empowers users to identify vulnerabilities in SQL...
Microsoft Graph PowerShell Community Sample Page
Microsoft Graph is a new unified programming model to manage cloud services such as Microsoft 365 and Azure. Many PowerShell modules and cmdlets...
Identifying AD Accounts without Proper Encryption Type
You may have accounts (inc. trust accounts) in AD that have a null value for msds-SupportedEncryptionTypes. They may have been working "by accident"...
Managing File Shares
Creating a new file share for your network requires Administrator privilege and this PowerShell code: $Parameters = @{ Name = "Packages" Path =...
Macros – Sample macros to import Logical and Physical Data Models from Microsoft Visio to ER/Studio Data Architect
Visio can draw charts, plans and diagrams. Some people have used Visio to create their Logical and/or Physical Data Models and they would like to…
Masked Input
To safely enter input, scripts need to display a masked input. The easiest way to do this is to use Read-Host -AsSecureString: # Read-Host $entered...
Mastering the Complexities of Analytics for Big Data in Healthcare, Part 1
Analytics for big data has rapidly become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
Automating Control Panels
Windows Control Panel is the GUI center for any system configuration. You can launch control panel via console command, too: control [ENTER]....
Easily Transition to Get-WinEvent
Avoid Get-EventLog
Get-EventLog is a highly popular cmdlet in Windows PowerShell. With just a few simple parameters, it reads event logs from the primary Windows event...
Zodiac Calculator (aka “Sternzeichen”)
Ever wanted to automatically convert dates to zodiacs? Here is a fascinatingly simple script that can do it for you, both in English and German:...
Composing Dates from a DateTime
Here is a simple and generic way to turn DateTime information into just the ISO string data components you require. For example, if you just need...
Announcing the General Availability of IDERA SQL SAFE Backup 9.2
Introducing IDERA SQL SAFE Backup 9.2: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
Migrating SQL Server to Azure SQL Database
Migrating SQL Server to Azure SQL Database provides essential benefits. Such advantages include the following: lower cost by shifting expenses from...
PowerShell Script Won’t Run Without Confirmation
When you right-click any PowerShell Script in Windows, the context menu sports the command “Run with PowerShell”. However, when you do, you may see...