March 2011 - Posts

• Building SQL Server Service Names in PowerShell Strings

  In a number of the PowerShell scripts I'm writing I have to build strings that contain the service account names or Active Directory group names for security principals used by SQL Server. PowerShell variables all start with the $ character, and many Read More... Posted Wednesday, March 30, 2011 12:41 PM by AllenMWhite | 0 Comments Filed under: SMO, PowerShell

• Who's Got Access to your FileStream Directories?

  One of the great features of SQL Server 2008 is the FileStream data type. Paul Randal ( blog | twitter ) wrote a great white paper on it called FILESTREAM Storage in SQL Server 2008 . When you define a column to use the FileStream datatype SQL Server Read More... Posted Thursday, March 24, 2011 5:52 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, Database Administration

• Build Your Personal Network

  Recently a few people have approached me privately about their careers, and how they can make the changes to allow them to do the kind of work they'd like to do, be it consulting or in a full-time role. (In every case, I was flattered and surprised, as Read More... Posted Wednesday, March 9, 2011 2:06 PM by AllenMWhite | 11 Comments Filed under: User Group Meetings

• T-SQL Tuesday #016:Check Your Service Accounts with PowerShell

  T-SQL Tuesday #016:Check Your Service Accounts with PowerShell This T-SQL Tuesday is about Aggregate Functions. It may be a bit of a stretch, but a security best practice to use separate service accounts for all your SQL Server services, so I've written Read More... Posted Tuesday, March 8, 2011 3:25 PM by AllenMWhite | 5 Comments Filed under: PowerShell, Database Administration