How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error.
Learn how you can add parameters to your PowerShell scripts to make them more flexible and useful.
First we had the Solarwinds hack, and now we have a Kaseya ransomware epidemic. It seems the criminals are moving up the stack. We used to see physical attacks on tapes and keyboards, then we saw OS level attacks. Now we seem to be getting to the management layer for software that is used to […]
When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations.
Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some of the SQL Server performance monitor data and how to collect it.
Autonomous cars provide a great environment for large scale, real-time data processing.
In this article we look at a PowerShell script that can quickly retrieve information about all databases from all servers that are configured to use database mirroring.
How Redgate Deploy will help you ensure that databases and applications can grow and develop in step, and to implement a workflow for delivery of database changes that is resilient, repeatable, fast and visible.
Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we do […]
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers