In this series of tips we will introduce PowerShell scripts with T-SQL code that can be used to monitor your SQL Server environment. This first set of scripts creates the core objects needed for this solution.
2020-07-07
I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb and […]
2020-07-02 (first published: 2020-06-21)
2,662 reads
A common question that I've seen online is how do I return multiple sql datasets from a single query using INVOKE-SQLCMD. Most of the answers out there say it is not possible, but it is in fact possible by using the OutputAs dataset parameter. This parameter outputs a dataset that has all of the information […]
2020-04-24 (first published: 2020-04-16)
7,328 reads
By Brian Kelley
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...
By Steve Jones
Redgate has been known for many useful tools that are easy to use. We’ve...
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Hi everyone I am using BULK INSERT to load a CSV. I have noticed...
One of our systems contains data for multiple organizations. OrgA should not be able...
We have the following requirement:- Event_Time ...
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers