Allen White Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell.... 03 May 2013 15 min read
Joseph Moody Getting Better Mileage by Extending Active Directory Users and Computers Active Directory has more uses than it is usually credited with. The 'Active Directory Users and Computers' console can even... 15 February 2013 8 min read
Richard Morris Jeffrey Snover: Geek of the Week PowerShell has radically improved the ease of monitoring and adminstering Windows-based servers, and automating routine processes. The visionary leader of... 23 October 2012 10 min read
Laerte Junior The PoSh DBA: Solutions using PowerShell and SQL Server PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much... 18 September 2012 15 min read
Phil Factor Registered Servers and Central Management Server Stores SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered... 28 August 2012 14 min read
Dave Ballantyne Cleaning Up SQL Server Deployment Scripts Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema... 02 August 2012 22 min read
Phil Factor PowerShell SMO: Just Writing Things Once Sometimes, you can tire of writing the same PowerShell code once again. After this happened to Phil whilst keying in... 19 July 2012 26 min read
Richard Morris Kohsuke Kawaguchi: Geek of the Week Jenkins, formerly called Hudson, is an open-source server-based Continuous Integration tool that works with all the major Source Control Management... 17 July 2012 11 min read
Warwick Rudd Encrypting Your SQL Server 2012 AlwaysOn Availability Databases It is likely that you'll want to add a database with TDS Encryption to your AlwaysOn Availability Group. If you... 04 July 2012 8 min read
Laerte Junior The PoSh DBA – The Attributes of Advanced Functions Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions... 19 June 2012 18 min read
Laerte Junior The PoSh DBA: Grown-Up PowerShell Functions Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing... 10 May 2012 19 min read
Timothy Wiseman SQL Scripts Manager and IronPython As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows... 04 May 2012 10 min read
Matt Wrock Towards the Perfect Build An automated build and deployment system is no longer a dream. Now that PowerShell has matured as a product, and... 30 April 2012 28 min read
Michael Sorens Practical PowerShell: Pruning File Trees and Extending Cmdlets One of the most radical features of PowerShell is amongst the least known. It is possible to extend the buit-in... 23 April 2012 21 min read
Sean Duffy Building a Daily Systems Report Email With PowerShell A combination of PowerShell and HTML can provide the basis of an easily-scanned report on the basic state of a... 16 March 2012 20 min read
Krishna Kumar Creating and Configuring a Custom Offline Address book with Web-Based Distribution in Exchange 2010 Using PowerShell The offline address-book (OAB) of Exchange is available when the user is not connected, Since Exchange 2007, it is updated... 04 March 2012 9 min read
Phil Factor Automated Script-generation with Powershell and SMO In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases,... 03 February 2012 24 min read
Grant Fritchey Auditing DDL Changes in SQL Server databases Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the... 12 October 2011 17 min read
Jonathan Medd Adding a Graphical Front End to your PowerShell Scripts Even if you know PowerShell inside and out, there will be those times where you won't be the end user... 10 October 2011 20 min read
Michael Sorens Further Down the Rabbit Hole: PowerShell Modules and Encapsulation Modules allow you to use standard libraries that extend PowerShell's functionality. They are easier to use than to create, but... 24 August 2011 24 min read
