Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
PowerShell
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
Manage Power BI Dataset with PowerShell
Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.
2020-11-30
Monitoring SQL Server Instance Version and Builds with PowerShell
In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.
2020-11-26
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,370 reads
Managing Power BI Workspaces with PowerShell
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
2020-11-02
Execute SSIS Package from PowerShell - Part 1
In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.
2020-10-27
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,548 reads
SQL Server High CPU Query Use Monitoring with PowerShell
In this part of the PowerShell monitoring tips we look at how to capture the top queries that are consuming the most CPU from all monitored instances.
2020-10-06
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
5,713 reads
Blogs
Creating TAIL on Windows for Text Files
By Steve Jones
I wrote recently about making a HEAD utility to find the top few lines...
Daily Coping 17 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The book that made me love goal-setting
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
Forums
Select * (Sql query)
Hi, I have a problem like below one. Give, for each train station, the...
SQL Query
Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...
Combine or join 3 tables, 1 for each databases
Hello guys, I hope you're all great and healthy I would love to learn...
Ask SSC