The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro Camps I’m helping put together the Orlando IT Pro Camp. Register to attend this free event on Saturday, January 21st. Orlando will be even bigger than Tampa or South Florida with 30 sessions on topics covering Hyper-v, Private Cloud, SharePoint, System Center Products, SQL Server, PowerShell, Active Directory, Windows 2008 R2, and Windows 7 . I’ll be presenting a PowerShell session on Storing Powershell Output. A few sessions I’ve seen previously and highly recommend:
If you can’t make Orlando, the Sarasota IT Pro Camp will be held on Saturday, February 18th. 2012. See the IT Pro Camp site for more information.
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off another guest blogger week (Nov 28th 2011) with my guest blog post, Four Easy Ways to Import CSV Files to SQL Server with PowerShell. The post demonstrates the following approaches to importing CSVs into a SQL Server table: T-SQL BULK INSERT command LogParser command-line LogParser COM-based scripting…
Continue Reading »
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using either T-SQL, a Centeral Management Server and Powershell. Task #1 Remove a SQL Server Login from the Sysadmin Role Let’s say you’re given the task to remove a login from the sysadmin role on 50…
Continue Reading »
Providing delegated administration to groups that need to perform various security functions has always been a difficult task, but thanks to Powershell V3 (currently in CTP 1 as of this blog post) and PowerGUI we have new tools to provide a solution. The Problem You have groups outside of database administration that need to have…
Continue Reading »
I’ve seen this come a few times at work and I’m sure most you have experienced something similar. Someone or an application installs SQL Server, doesn’t grant access to the DBA group and asks for DBA support. In SQL Server 2008 and higher the built-in local administrators group is no longer automatically part of the…
Continue Reading »
Presentation and scripts from my Storing Powershell Output session at SQL Saturday #85 Orlando 2011:
Continue Reading »
Although you can use SQL Server Management Studio or T-SQL to manage AlwaysOn, SQL Server Denali CTP 3 includes 25 cmdlet which together provide complete coverage for creating, confiiguring and administering the AlwaysOn database feature. In this post we’ll look at using Powershell to perform various management tasks for AlwayOn. Note: This blog post describes…
Continue Reading »
If you ever need to flatten out groups which may include nested local and AD groups there’s a really easy way to do this in the System.DirectoryServices.AccountManagement.GroupPrincipal GetMembers method. Here’s some PowerShell code which works against both local and AD groups. The code can easily be adapted into a function and in fact I’m using…
Continue Reading »
I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script out all objects of a certain type or a select list of objects. As we will see a moment this was a bit a of challenge and it wasn’t until I had given up ,…
Continue Reading »
Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:
Continue Reading »
