In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Saving Text Files without BOM
read more
database-tools
The Top Five Features of SQL Diagnostic Manager for MySQL DBAs
The server performance monitoring tool SQL Diagnostic Manager for MySQL features a host of capabilities to empower database administrators (DBAs)....
Trusting Self-Signed HTTPS Certificates
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
SQL Diagnostic Manager 11.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 11.0. Existing users may upgrade to this version through the Idera...
Converting Word Documents
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
How Infrastructure Monitoring Can Improve Security and Performance
The security and performance of a computing environment can be improved by implementing infrastructure monitoring. Insights produced by a robust...
Why It’s Important to Optimize SQL Queries
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Using Encoding Standards
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Columnstore Index for SQL Server
Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with...
Fixing VSCode PowerShell Issues (Part 2)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
How to Effectively Reduce SQL Server Database Index Fragmentation
SQL Server database index fragmentation is a problem faced by many database administrators (DBAs). It is an issue that can seriously impact database...
The Benefits of Using an IDE for Database Developers
Diversified database platforms are the norm in modern computing environments. The demands of productively using enterprise data resources have made...
Fixing VSCode PowerShell Issues (Part 1)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
The Top Five Features of SQL Diagnostic Manager for SQL Server
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Finding PowerShell Commands
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Filtered Indexes and Performance
Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the...
Being a Proactive DBA Makes You More Productive
A career as a database administrator (DBA) should appeal to individuals interested in a job that involves a diverse range of duties and technical...
Repairing Install-Module (PowerShellGet)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Cross-Platform Out-GridView
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
The Most Surprising SQL Antipattern We Use
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...
Why Should You Care About Crypto Mining on Your SQL Servers?
Many different types of malware are floating around out there. Some of the variants are purely destructive and are designed to simply delete data....
Identifying SQL Server Performance Problems Part 3
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Troubleshooting Over-Indexing for Performance
Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the...
Discovering Package Managers on Windows (Part 2)
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...