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.
2021-01-15
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2020-12-31
2,941 reads
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
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
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
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,108 reads
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
2020-11-02
In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.
2020-10-27
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
By Arun Sirpal
If you are building database solutions in Azure , using Azure SQL Database then...
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
I am using SQL Server 2008 R2. While using XML data type and XQuery...
Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...
I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...
Ask SSC