Using clickable actions in PowerPoint presentations can be super useful to launch Visual Studio Code or PowerShell ISE, and seamlessly open and demo...
Enabling Clickable PowerPoint Actions
read more
database-tools
Why is database backup compression better than file deduplication?
Database administrators often argue with their storage administrators about not compressing database backups. Storage Administrators state that they...
Manage Automatic Disk Checks
Whenever Windows detects irregularities with storage drives, it enables an automatic integrity check. For system partitions, on next boot, Windows...
Managing Databases in the Face of the Global Pandemic
The COVID-19 virus that is currently plaguing the world has impacted virtually every aspect of our lives. Things we previously took for granted like...
Getting Available Video Resolutions
WMI can return a list of available video resolutions for your video adapter: PS> Get-CimInstance -ClassName CIM_VideoControllerResolution |...
COVID-19 and Tools to Support Database Professionals
Are you working in crisis mode and need some help? Organizations are reacting to rapidly changing demands because of the current escalating crisis....
Why Capacity Planning is Important for Your Business
Many related factors need to come together to create successful IT solutions that effectively address business needs. The first requirement is that...
Monitoring the Critical Applications That Benefit Society
As the world faces the onslaught of the COVID-19 virus and its effects on society, the availability of certain websites and applications takes on a...
Be Careful with Some Commands
Here are three commands often found in PowerShell scripts that you should be careful about because they can have severe side effects: exit“exit” is...
Dealing with Out-GridView Bug
Out-GridView can serve as a universal selection dialog when you add the -PassThru parameter. The one-liner below stops all services you select in...
Keep Your SQL Servers Secure with These Best Practices
Keeping an organization’s SQL Servers secure is the supporting DBAs’ most critical responsibility. The performance and availability of...
SQLEJM Job Chaining
I created a job chain in SQLEJM with a root job one server and a second job on a different server with the job chain scheduled hourly. The root job...
The Rise of Cross-Platform Database Administration
Time and money are two things that are always in short supply. Let’s face facts. It’s a rare individual who turns down some extra cash...
Exploring WMI with PowerShell
The Win32_LogicalDevice WMI class represents all logic devices available in a computer, and by querying this “superclass”, you get back all the...
How to create custom counters with SQL Diagnostic Manager for SQL Server
Every environment is different. SQL Diagnostic Manager has pre-configured metrics that it monitors and collects...
DevOps Impact on Database Administration
The current trend for software development teams is to adopt a continuous delivery approach based on DevOps and agile development techniques. DevOps...
Adding New PowerShell Commands with Carbon
Carbon is one of the most popular free PowerShell modules available from the PowerShell Gallery. Similar to a swiss army knife, it comes with a...
A Comprehensive Tool for Developing High-Performance SQL Code
Writing SQL code is something that database professionals are called upon to do regularly. The practice comes into play when developing new...
Managing Updates with PSWindowsUpdate
There are many useful PowerShell modules available from the PowerShell Gallery. One helps you managing updates. To download and install it, run:...
Best Practices to Protect and Backup Your SQL Servers
One of the most important jobs a DBA has is keeping their databases safe and protected. While performance is a critical factor in database...
SQL Inventory Manager 2.6 Now Available
SQL Inventory Manager 2.6 Now Available We are pleased to announce the general availability of SQL Inventory Manager 2.6. Existing users may upgrade...
How to Optimize MySQL For High-Traffic Websites
Most websites that have any real utility are at least partially constructed with applications backed by databases. When you make a purchase on the...
Dynamic Argument Completion (Part 5)
In our previous tip we looked at sophisticated completion code that completed application paths. Collecting the completion values could take some...
How to run prescriptive analysis with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager distinguishes itself from typical monitoring tools because it is more than just a symptom-based monitoring tool, since it can...