THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Administration   (RSS)
Showing page 4 of 8 (76 total posts)
  • Change SQL Servers Authentication Mode with PowerShell

    Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One of the settings that I normally set and forget at install time is the Authentication Mode setting. Best practices suggest that you set this to Windows Authentication, but my experience has been that it's always better to ...
    Posted to Allen White (Weblog) by AllenMWhite on May 19, 2011
  • 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 actually writes the contents of the column to the filesystem of your server, in individual files ...
    Posted to Allen White (Weblog) by AllenMWhite on March 24, 2011
  • 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 some PowerShell code to check to see if any account is used more than once on a given ...
    Posted to Allen White (Weblog) by AllenMWhite on March 8, 2011
  • T-SQL Tuesday #015:Remaining on Alert

    This T-SQL Tuesday is about Automation in SQL Server, and I'll bet you think I'm going to talk about PowerShell. Well, you're partially right. What I'd like to talk about today, though, is setting up alerts to automate some responses to naturally occuring phenomena on your SQL Servers. (Note: I first introduced this technique in an article on ...
    Posted to Allen White (Weblog) by AllenMWhite on February 8, 2011
  • SQL Rally Voting Open

    The voting for sessions for SQL Rally has been going on for a couple of weeks now. This week the Enterprise Database Administration & Deployment sessions are up for voting. I didn't go into politics because I don't feel comfortable telling people that they should vote for me but this is how the sessions are being decided for this ...
    Posted to Allen White (Weblog) by AllenMWhite on January 26, 2011
  • SQL Connections Presentations

    This week I presented two sessions at the Fall 2010 SQL Connections conference, in Las Vegas, Automating Policy-Based Management Using PowerShell and Managing SQL Server System and Performance Data with PowerShell. I thorougly enjoyed doing both presentations and for the most part got some great questions. I'm attaching the decks and demo scripts ...
    Posted to Allen White (Weblog) by AllenMWhite on November 5, 2010
  • Discover Facets and Properties in PowerShell

    When you're trying to set up scripts to deploy policies to your servers (because you ALWAYS automate with PowerShell, right?), it can be sometimes difficult to determine exactly what facets are there, and when you do know the facet name, what properties are available to you. First, in a native PowerShell window you'll need to load the assemblies ...
    Posted to Allen White (Weblog) by AllenMWhite on September 27, 2010
  • Speaking about Source Control for DBAs

    Brian Davis and I will be presenting a session on managing database change via source control tomorrow evening. Developers use source control consistently and with great success, but database change has been resistant to it, largely because the change involves much more than just the scripts. We'll discuss this, and show you how to use both ...
    Posted to Allen White (Weblog) by AllenMWhite on September 8, 2010
  • PASS PowerShell/SQL Server PreCon

    PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline: Use PowerShell to Get the Most out of SQL Server Module 1: ...
    Posted to Allen White (Weblog) by AllenMWhite on August 19, 2010
  • The Power of sed in PowerShell

    SSIS is a great tool for managing ETL, but in a complex process it's easy to have a lot of packages all referencing the same data source. In testing I found I needed to change all the connection managers in all the packages to a different database. When you have dozens of packages that can be rather tedious. Note: there may (and probably are) ...
    Posted to Allen White (Weblog) by AllenMWhite on July 9, 2010
« First ... < Previous 2 3 4 5 6 Next > ... Last »
Privacy Statement