Tag: Microsoft SQL Server

How to Connect to an Azure SQL Database

Learn to connect to Azure SQL Database and be comfortable using it either with or instead of a traditional SQL Server installation.

Chris Blackden Avatar Chris Blackden

6 min. read

How to Connect to SQL Server from Linux

Learn how to connect to SQL Server from Linux!

Adam Bertram Avatar Adam Bertram

3 min. read

Monitoring SQL Server Performance Counters with PowerShell

Learn how to monitor SQL servers through Powershell SQL server performance counters and how to query them properly.

Adam Bertram Avatar Adam Bertram

4 min. read

Stories from the PowerShell Trenches: Day 4

For our fourth and final day for the Stories from the PowerShell Trenches series we're going to hear from Nigel Thomas. This one is a good one on automating SQL Server and Excel!

Adam Bertram Avatar Adam Bertram

6 min. read

Rebuild/Defragment Your WSUS Database Indexes

I've realized it's important to keep your SQL indexes properly maintained. I'm no SQL DBA but from what I hear, consistently ensure your indexes are defragmented is a good thing.

Adam Bertram Avatar Adam Bertram

2 min. read

Building PowerShell Scripts to Tie Disparate Products Together

The PowerShell scripting language has been called "automation glue" more times than I can count. It's a fitting description if you've worked with it a lot. You may get the automation part of the title right away if you've merely heard of PowerShell and what it can do but the "glue" part may leave you wondering why.

Adam Bertram Avatar Adam Bertram

3 min. read

Subscribe to Adam the Automator

Get the latest posts delivered right to your inbox