In part two of his series on Codeplex extensions to Powershell for SQL Server, Chad Miller talks more about the functions in the project and how you can integrate with Reporting Services.
2008-10-08
7,649 reads
Powershell is the new management interface for scripting and working with SQL Server that is integrated into Windows 2008 and SQL Server 2008. The author of a Codeplex project introduces some extensions that try to make it easier to use Powershell with SQL Server.
2008-10-06
17,363 reads
This fifth installment of the “Check your SQL Server using Windows PowerShell” series illustrates how to access SQL Server instance properties and SQL Server configuration details using Windows PowerShell.
2008-09-25
2,762 reads
Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.
2008-08-27
4,303 reads
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
2008-08-18
2,906 reads
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
2008-06-26
4,215 reads
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
993 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-05-08 (first published: 2008-02-15)
2,523 reads
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
2007-11-29
2,575 reads
This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.
2007-10-31
2,702 reads
Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...
By kleegeek
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...
By Steve Jones
For some reason, I can never remember how to do markdown links. I know...
Has anyone faced this error Agent message code 20037. The process could not bulk...
Hi - has anyone created a PowerShell runbook which connects to a database hosted...
Comments posted to this topic are about the item The Compression Type
Ask SSC