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...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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...
Choosing Best File Format (Part 4)
In the previous parts, we reviewed different file types to persist data and cmdlets to read and write them. Today, let’s apply this to a real-world...
Choosing Best File Format (Part 3)
Publishing on – Thur June 22 PowerShell supports a wide variety of text file formats, so what’s the best way to save and read data? In the first two...
Choosing Best File Format (Part 2)
PowerShell supports a wide variety of text file formats, so what’s the best way to save and read data? This largely depends on the type of data, so...
Choosing Best File Format (Part 1)
PowerShell supports a wide variety of text file formats, so what’s the best way to save and read data? This largely depends on the type of data, so...
Deploy and manage complex Azure environments
The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control...
How to Maintain Security Compliance to Prevent a Costly Breach
As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...
Visually compare data in MySQL
As with any database, there are many ways to compare the data within a MySQL database. We can compare data for: Accuracy: If we entered the data...
Learn more about database migrations
Many information technology professionals may not recognize it, but the bulk of their work has been and continues to be nothing more than database...
Monitor top metrics in MySQL databases
How MySQL databases perform can affect your organization. For example, if your site takes too long to load or has too many server errors, it can...
Tips for data warehouses and other extensive databases
Whether on-premises or in the cloud, organizations often ask database administrators to create and manage optimal database designs for data...
DBTA 100 2023: The Companies That Matter Most in Data
The need to balance data safety with new data initiatives, deliver business value, and change company culture around data tops this year’s list of...
Become a SQL Server Management Studio Hero
The world is full of exciting challenges, and we are constantly running daily, chasing our dreams. Especially in the software ecosystem, it is not...
Synchronize MySQL data
Lost your work because you forgot to back it up? Having your database developers do a mountain of work in a short time frame is not the best way to...