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 Admini... » SQL Server 2008   (RSS)
Showing page 1 of 3 (25 total posts)
  • Set and Verify the Retention Value for Change Data Capture

    Last summer I set up Change Data Capture for a client to track changes to their application database to apply those changes to their data warehouse. The client had some issues a short while back and felt they needed to increase the retention period from the default 3 days to 5 days. I ran this query to make that change: sp_cdc_change_job ...
    Posted to Allen White (Weblog) by AllenMWhite on March 7, 2012
  • Endpoints Need Privileges Too

    Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment. Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my demo and test machines, replacing the Microsoft Virtual PC demos ...
    Posted to Allen White (Weblog) by AllenMWhite on May 26, 2011
  • 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
  • Parsing the sqlserver.sql_text Action in Extended Events by Offsets

    A couple of weeks back I received an email from a member of the community who was reading the XEvent a Day blog series and had a couple of interesting questions about Extended Events.  This person had created an Event Session that captured the sqlserver.sql_statement_completed and sqlserver.sql_statement_starting Events and wanted to know how ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on January 30, 2011
  • 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
  • Policy Based Management and the Unknown LoginMode

    The topic of this post comes from a question on the MSDN Forums, and had it not been for some advice from Buck Woody (blog|twitter), I never would have known the answer.  Lately I’ve been doing a lot of work with Policy Based Management, in particular, working with Lara Rubbelke’s (blog|twitter) Enterprise Policy Management Framework which is ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on September 15, 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
  • Should SQL Server advanced features be available a la carte?

    SQL Server users love the new features inside of the platform and each new release brings more exciting enhancements that motivate end users towards upgrading from previous editions.  However, one of the biggest gripes I see from the SQL Server Community is that the hot new features are primarily Enterprise Edition only.  Today I read a ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on June 21, 2010
  • TechEd 2010 Followup

    Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented: DAT01-INT Administrative Demo-Fest for SQL Server 2008 SQL Server 2008 provides a wealth of features aimed at the DBA. In this demofest of features we'll ...
    Posted to Allen White (Weblog) by AllenMWhite on June 13, 2010
  • Some thoughts on the Virtualization Feedback in the SSWUG Newsletters

    Last Thursday, March 25, 2010, the topic of Virtualization of SQL Server came up in the SSWUG Newsletter, with Steven Wynkoop asking if peoples perceptions and experiences have changed since the last time he covered virtualizing SQL Server.  I unfortunately missed the last coverage of this topic, but it appears from the newsletter that there ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on April 1, 2010
1 2 3 Next >
Privacy Statement