THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Database Administration   (RSS)
Showing page 1 of 15 (147 total posts)
  • [Speaking] SQL Saturday #295 - Las Vegas

    On Saturday I'll be presenting one of my favorite sessions, Manage SQLServer Efficiently w/PowerShell Remoting, at the Las Vegas SQL Saturday.  Here's the abstract:You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell ...
    Posted to Allen White (Weblog) by AllenMWhite on April 2, 2014
  • Are We Losing a Standard (Edition) Data Recovery Technology?

    One of the coolest technologies Microsoft released with SQL Server 2005 was Database Mirroring, which provided the ability to have a failover copy of a database on another SQL Server instance, and have the ability to automatically failover to that copy should a problem occur with the primary database. What was even cooler was that this new ...
    Posted to Allen White (Weblog) by AllenMWhite on June 10, 2013
  • Tech Ed Demos for "Manage SQL Server System and Performance Data with PowerShell"

    This morning I presented my session Manage SQL Server System and Performance Data with PowerShell at Tech Ed NA in New Orleans. We had a good sized audience who were very responsive and had many great questions. I had a great time presenting and the feedback I've gotten so far tells me the audience enjoyed it as well. I really appreciate ...
    Posted to Allen White (Weblog) by AllenMWhite on June 4, 2013
  • New Article on the SQL Server 2012 Backup and Restore PowerShell Cmdlets

    While I was on vacation last week in Scotland Simple Talk published a new article I wrote called Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets. Hope you have as much fun with it as I did writing it. Allen  
    Posted to Allen White (Weblog) by AllenMWhite on May 13, 2013
  • T-SQL Tuesday #39: Managing your SQL Server Services with PowerShell

    This T-SQL Tuesday is about using PowerShell to do something with SQL Server. Now, if you've read any of my blog posts you probably know I've been using PowerShell to do things with SQL Server for a while now, but I'm glad Wayne decided on this topic for his T-SQL Tuesday topic, because everyone has different ways to use PowerShell, and you can ...
    Posted to Allen White (Weblog) by AllenMWhite on February 12, 2013
  • How Does the Cloud Change a Database Administrator’s Job?

    I recently posted a blog entry on how cloud computing would change the Systems Architect’s role in an organization. In a way, the Systems Architect has the easiest transition to a new way of using computing technologies. In fact, that’s actually part of the job description. I mentioned that a Systems Architect has three primary ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 29, 2013
  • Speaking - SQL Saturday 173, Washington DC

    After a great time at the PASS Summit in Seattle I'll be once again presenting on PowerShell for SQL Server at SQL Saturday #173 in Chevy Chase, Maryland.  On Friday, December 7 I'll be presenting my full day session Automate and Manage SQL Server with PowerShell. Here's the abstract: This soup-to-nuts all day session will first introduce ...
    Posted to Allen White (Weblog) by AllenMWhite on November 28, 2012
  • PASS Summit 2012 PreCon - DBA-298-P Automate and Manage SQL Server with PowerShell

    On Tuesday I presented an all-day pre-conference session on using PowerShell to automate and manage SQL Server.  It was a very full day and we had a lot of great questions.  One discussion in Module 6 was around scripting all the objects in a database, and I'd mentioned the script I wrote for the book The Red Gate Guide to SQL Server ...
    Posted to Allen White (Weblog) by AllenMWhite on November 8, 2012
  • [Speaking] PowerShell at the PASS Summit

    Next week is the annual PASS Summit, the event of the year for those of us in the SQL Server community. We get to see our old friends, make new friends, and learn an amazing amount about SQL Server, and it'll be in Seattle, so it's close to the mother ship. I love having Microsoft close, because it's easier to get to know the people who actually ...
    Posted to Allen White (Weblog) by AllenMWhite on October 29, 2012
  • Search For a Query in RDL Files with PowerShell

    In tracking down poorly performing queries for clients I often encounter the query text in a trace file I've captured, but don't know the source of the query. I've found that many of the poorest performing queries are those written into the reports the business users need to make their decisions. If I can't figure out where they came from, ...
    Posted to Allen White (Weblog) by AllenMWhite on October 16, 2012
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement