Browse by Tags

• logshipping
• patching
• security
• SQL Saturday
• ssis
• versions

• SQL Saturday 108 Redmond PowerShell Session Material

  I am honored to be presenting my first SQL Saturday session in Redmond on the 25th of this month. The session will be a PowerShell basics class, emphasis on helping people who might be starting out with PowerShell, or feel intimidated by PowerShell’s Read More... Posted Friday, February 10, 2012 2:43 PM by merrillaldrich | 0 Comments Filed under: powershell, SQL Saturday

• Case Study: Secure Log Shipping via SSL FTP

  Today I’m putting up sort of an oddball solution I build a couple of months ago. We had the need to provide a reporting copy of some production databases for analysts to do ad-hoc reporting. The trick was that we needed to move the databases from a less Read More... Posted Thursday, May 19, 2011 6:12 PM by merrillaldrich | 0 Comments Filed under: security, powershell, logshipping

• Tidy PowerShell Scripts using Here-strings

  If you use PowerShell in combination with SQL Server, you no doubt have had to compose a string full of T-SQL. If you compose a query string with a lot of quotation marks and concatenation operators, it can be hard to read and even harder to edit. Here's Read More... Posted Tuesday, October 19, 2010 3:30 PM by merrillaldrich | 1 Comments Filed under: powershell

• Version Checks

  Patch time is upon us! Patch time is a great time to take stock of your whole environment, find those new SQL instances that you didn't know you had, or the retired ones you don't need to worry about any more. Here are some housekeeping tips: Simple SQL Read More... Posted Wednesday, October 14, 2009 3:41 PM by merrillaldrich | 0 Comments Filed under: powershell, versions, patching

• PowerShell to Validate SAN File Migration

  This post is a bit off topic for SQL Server proper, but I thought someone out 'oogling teh inter-tubes might find it useful. Our group recently had to perform a large SAN migration both to new equipment and to a new geographic location. We started with Read More... Posted Monday, August 31, 2009 1:03 PM by merrillaldrich | 5 Comments Filed under: ssis, powershell