Laerte Junior The PoSh DBA – Towards the Re-usable PowerShell Script When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for... 21 January 2016 17 min read
Richard Morris Chet Ramey: Geek of the Week The BASH shell is the most popular UNIX command-line scriptable shell. It became the inspiration for PowerShell. As with so... 14 December 2015 10 min read
Laerte Junior The PoSh DBA – Using the Basic PowerShell Paradigms PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to... 04 December 2015 10 min read
Nicolas Prigent PowerShell Day-to-Day SysAdmin Tasks: Securing Scripts Although PowerShell is popular, for malicious intruders it represents a very attractive attack vector into your system. The obvious way... 01 December 2015 16 min read
Michael Sorens Documenting Your PowerShell Binary Cmdlets Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide... 17 November 2015 31 min read
Omid Afzalalghom Doing a SQL Server Healthcheck via PowerShell PowerShell is an ideal tool for doing health checks of a collection of SQL Server instances, and there are several... 16 November 2015 13 min read
Phil Factor Routine SQL DML Testing for the Unenthusiastic Tester There are more exciting things in life than unit testing SQL Statements, checking the results, timings, and execution plans. Phil... 03 November 2015 16 min read
Michael Sorens Ins and Outs of the PowerShell Pipeline For many developers, understanding pipelining in PowerShell is like understanding reductive physicalism: you think you've just about got it, and... 22 October 2015 10 min read
Laerte Junior Automating Your SQL Server Best Practice Reports: The Document If you're making a report from table-based data, an MS Word document is often a good option. In the second... 21 October 2015 10 min read
Laerte Junior Automating Your SQL Server Best Practice Reports:The Checks A DBA in charge of a whole lot of databases and servers has to check regularly that there are no... 06 October 2015 13 min read
Michael Sorens The Complete Guide to PowerShell Punctuation It is the punctuation, the strange dollar signs, brackets and parentheses that bewilder anyone learning PowerShell. Add to that the... 30 September 2015 10 min read
Michael Sorens Build Your Own Resource Monitor in a Jiffy It's great to be able to monitor a counter or any other changing metric while engaged in development work. You'd... 14 September 2015 18 min read
Jason Crease Writing Build vNext tasks for Visual Studio Online Hosted TFS, now called Visual Studio Online (VSO), has a new way of writing build processes called Build vNext. Agent... 09 September 2015 9 min read
Michael Sorens When to Quote in PowerShell The one question about PowerShell that trips up almost everyone is about when and how to quote strings. Because PowerShell... 12 August 2015 16 min read
Nicolas Prigent PowerShell Day-to-Day Admin Tasks: Monitoring Performance By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information.... 01 July 2015 13 min read
Michael Sorens The Poster of the Plethora of PowerShell Pitfalls One of the downsides of learning a new computer language is that transfer of training doesn't always work to your... 25 June 2015 28 min read
Nicolas Prigent PowerShell Day-to-Day Admin Tasks: WMI, CIM and PSWA WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL... 28 May 2015 12 min read
Michael Sorens A Plethora of PowerShell Pitfalls: Part 2 There are some pitfalls in PowerShell for the unwary. Many people who are learning PowerShell come across quirks that can... 12 May 2015 16 min read
Nicolas Prigent Automating Day-to-Day PowerShell Admin Tasks – Jobs and Workflow If you are aiming to optimise the use of your time by doing as much as possible via scripting, you... 13 April 2015 13 min read
Michael Sorens A Plethora of PowerShell Pitfalls PowerShell has some very valuable features, but it is a mistake to believe that all those skills that you've derived... 02 April 2015 19 min read
