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 Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers