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.
2021-07-23
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.
2021-07-21
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.
2021-07-21
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.
2021-07-19
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.
2021-07-19
Compare the schemas of two SQL Server databases using SQL Compare command line then quickly produce a diff report showing you immediately which tables, views and functions have changed.
2021-07-16
This article will demonstrate how to migrate via JSON, key-value pairs from a Python dictionary object to a SQL Server table.
2021-07-16
The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In this article, Mahendran Purushothaman explains autoscaling in Microsoft Azure.
2021-07-14
The insurance sector has seen a marked rise in mergers and acquisitions over the past 12 months, and although these can be an excellent way to leap beyond organic growth, M&As can result in challenges with technology. In this blog, COEO's James Boother provides some tips on how, with good planning, technologies can be a real advantage in your next acquisition.
2021-07-14
The Best of Summit 2020 series is now live! This curated series features a selection of the most-viewed content from PASS Virtual Summit 2020 to help you find relevant data platform training related to this year’s conference tracks. Best of Summit 2020 includes sessions from some of the top speakers in the data industry including Erin Stellato, Andy Yun, Melissa Coates, Pinal Dave, Hamish Watson, and many others.
2021-07-12
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...
I do have a question. At work, some groups of people have an inordinate...
Comments posted to this topic are about the item What Did Healthy Look Like?
How many types of DML triggers are there?
See possible answers