Browse by Tags

• April Fools
• community
• logshipping
• partitioning
• pass
• patching
• security
• SQL Saturday
• ssis
• T-SQL
• versions

• Speaking in Chicago Saturday

  I’m excited to be offering a beginning PowerShell session at SQL Saturday #211 in Chicago on Saturday, April 13. This time we’re making it a family weekend, bringing our two boys. I haven’t been to Chicago for many years, and it’s, of course, an Architecture Read More... Posted Thursday, April 11, 2013 10:03 AM by merrillaldrich | 0 Comments Filed under: community, pass, powershell

• Updated Warehouse Re-Index Script

  As I talked about in my last post , I just went through a re-indexing project that took the partitioned fact rows from our warehouse and relocated them into new files. There are a lot of tables and indexes involved, so I have a PowerShell “helper” script Read More... Posted Monday, January 14, 2013 5:30 PM by merrillaldrich | 1 Comments Filed under: partitioning, powershell

• Microsoft Delivers Full Suite of SQL Server PowerShell Cmdlets

  We’ve all been waiting several years for this, and finally it’s here! Coinciding (approximately) with the release of SQL Server 2012, a new Feature Pack has appeared on the Microsoft web site that adds a full suite of PowerShell cmdlets for DDL and other Read More... Posted Sunday, April 01, 2012 10:20 AM by merrillaldrich | 6 Comments Filed under: April Fools, powershell, T-SQL

• 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 | 1 Comments Filed under: logshipping, powershell, security

• 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 | 0 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: patching, powershell, versions

• 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 | 4 Comments Filed under: powershell, ssis