Finding lost or forgotten SQL Servers
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
2013-07-25 (first published: 2011-04-19)
15,682 reads
PowerShell
PowerShell Basics
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
2013-02-22 (first published: 2011-01-24)
25,074 reads
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
2010-10-15
852 reads
PowerShell Version 2: What is new and why is it important?
It was a year ago that Microsoft shipped PowerShell 2. Jonathan Medd lists the top ten reasons why PowerShell 2 should be an important tool for your work
2010-10-01
4,489 reads
Moving Indexes with Powershell and SMO
Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.
2010-09-30
4,638 reads
Gathering Perfmon Data with Powershell
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
2010-07-21
3,220 reads
I’m a SQL Server DBA, and I’m in Love with PowerShell
To learn PowerShell, Laerte Junior suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice, "the lion is dead".
2010-06-24
5,883 reads
Sharing Your Scripts - Made Easy
Windows PowerShell v2 introduces self-contained “modules,” making it easier to share scripts with reusable functions, custom format views or type extensions.
2010-05-28
2,789 reads
Retrieve Default SQL Server Backup Folder using PowerShell
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
2010-04-23
2,763 reads
Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation
In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.
2010-02-26
2,552 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers