Articles tagged

10 June 2011
10 June 2011

Fast and Free; SQL Scripts Manager’s Script Generator

When William produced his second article on the free tool 'SQL Scripts Manager', revealing that it worked just as well with PowerShell and Python scripts as it does with TSQL, he thought that would be the end of the series. Oh no; in response to feedback, comes a small add-in called 'Script Generator' that makes a big difference to the speed of developing and producing new scripts. … Read more
30 March 2011
30 March 2011

How to Import Data from HTML pages

It turns out that there are plenty of ways to get data into SQL Server from websites, whether the data is in tables, lists or DIVs Phil finds to his surprise that it is easier to use Powershell and the HTML Agility Pack, than some of the more traditional approaches. Web-scraping suddenly becomes more resilient.… Read more
11 March 2011
11 March 2011

An Introduction to PowerShell Modules

For PowerShell to provide specialised scripting, especially for administering server technologies, it can have the range of Cmdlets available to it extended by means of Snapins. With version 2 there is an easier and better method of extending PowerShell: the Module. These can be distributed with the application to be administered, and a wide range of Cmdlets are now available to the PowerShell user. PowerShell has grown up.… Read more
17 February 2011
17 February 2011

SQL Scripts Manager with PowerShell

SQL Scripts Manager was released as a Christmas present to Simple-Talk subscribers. William Brewer then wrote an appreciation of the tool. Now, he reveals a secret:: It also runs PowerShell scripts, and hence, SMO. He has the scripts to prove it, though hopefully, you'll soon be running your own PowerShell from SQL Scripts Manager.… Read more
21 October 2010
21 October 2010

Importing PSTs with PowerShell in Exchange 2010 SP1

Unless you use Red Gate's PST Importer, the import and export of PST files with Exchange 2010 is a complex and error-prone business. Microsoft have acknowledged this in the release of Exchange 2010 SP1, since they have now re-engineered the way that PSTs are handled to try and ease the pain of importing and exporting them, but it is still a matter of using Powershell with cmdlets, rather than a GUI. Jaap Wesselius takes a look at the new process. … Read more
26 August 2010
26 August 2010

Identifying Exchange ActiveSync Users with PowerShell

Just recently, a problem involving the iPhone/iPod's synchronisation process with Exchange 2007, made it necessary for Exchange Administrators to alert various mail users to upgrade to the latest version of Apple's iOS 4. Ben shows how easily he was able to do this for his organisation, using Exchange's Management Shell with PowerShell and some Exchange cmdlets.… Read more
12 March 2010
12 March 2010

Implementing Cluster Continuous Replication, Part 3

Cluster continuous replication (CCR) uses log shipping and failover to provide a more resilient email system with faster recovery. Once it is installed, a clustered server requires different management routines. These are done either with a GUI tool, The Failover Cluster Management Console, or the Exchange Management Shell. You can use Powershell as well for some tasks. Confused? Not for long, since Brien Posey is once more here to help. … Read more
11 February 2010
11 February 2010

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.… Read more