The need to print doesn't seem to go away. Using RDL format report file you can print local reports in .net to PDF without having to connect to a Reporting Service Server.

SQL Server Monitoring for all Availability Groups

by Additional Articles

MSSQLTips.com

SQL Server

In this article we present a PowerShell script that can help you monitor all of your SQL Server Availability Groups in your environment.

Who is my customer?

by Kathi Kellenberger

SQLServerCentral

Database Weekly

My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]

ASCII Text Dump

by saga

SQLServerCentral

T-SQL

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]

Improving Availability Groups

by Steve Jones

SQLServerCentral

High Availability (HA)

Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.

Azure Blob Storage Data Upload with SSIS

by Additional Articles

MSSQLTips.com

In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.

Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.