I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used nowdays for administering and managing Windows servers and workstations. Exchange Server 2007 and Windows Server 2008 are just two of the Microsoft server products that have included this as part of their administrative tools. I want to know how Windows PowerShell can help me as a SQL Server DBA.
2009-02-20
5,543 reads
In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.
2009-01-02
23,328 reads
Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.
2011-05-13 (first published: 2008-12-16)
33,583 reads
Part 8 of our discussion on how to check SQL Server using Windows PowerShell examines how to get the SQL Server connection information.
2008-11-12
2,668 reads
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
2008-11-04
2,834 reads
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,842 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
18,371 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
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?