SQLGardner

Lisa Gardner - Senior Premier FIeld Engineer for SQL Server and APS
Blog - Title

Posts
  • SQLGardner

    Identifying Contention in TempDB

    • 0 Comments
    It has been a number of years since I have seen a TempDB contention issue in a system that I support. When I came across this one, luckily during a load test and not a production environment, it was a great refresher.  The offending application in...
  • SQLGardner

    SQL 2012 AlwaysOn and Backups – Part 2 - Configuring Backup Preferences and Automating Backups

    • 0 Comments
    In my last post I showed that you can perform backups from your replicas. A thought you may have had is “Well that is great, but how do I know if that instance is the replica and has not become primary? What if I want a particular replica to perform...
  • SQLGardner

    SQL 2012 AlwaysOn and Backups – Part 3 – Restore

    • 5 Comments
    Work and family stuff delayed this blog post a bit, but we all must strive to find a balance in life! Sometimes things have to slide a little.  Anyway, let’s talk a little about how all these wonderful backup options in SQL 2012 can affect the restore...
  • SQLGardner

    SQL 2012 AlwaysOn and Backups – Part 1 – Offloading the work to a replica

    • 1 Comments
    One of the greatest aspects of AlwaysOn is the ability to offload the work of backups and integrity checks to a replica.  This can really help preserve resources on your primary for your application workload. I am going to focus primarily on transaction...
  • SQLGardner

    Implementing Log Shipping for Many Databases

    • 1 Comments
    In my previous post, I discussed using log shipping as a method for migrating databases to reduce application downtime. Using Management Studio to configure log shipping for each database is fine… until you have a large number of databases to implement...
  • SQLGardner

    Primary Keys and the Default Clustered Index

    • 1 Comments
    When it comes to determining what your clustered index should be for a given table, you often think of the primary key.  Often times that is a good choice.  In fact, that is the default is to do that.  That is not always your best choice...
  • SQLGardner

    SharePoint, that was a poor choice, you need a time out.

    • 0 Comments
    As the mother of a 3 year old, I find myself saying talking about poor choices and sitting in time out quite a bit. Perhaps that is due to the fact that my little one has her mommy’s spirited nature, so I can’t always fully blame her. I...
  • SQLGardner

    Minimizing DB Migration Downtime Using Log Shipping

    • 0 Comments
    A common and often unpleasant task for DBA involves moving databases between physically separate SQL instances. This could be due to a data center move, hardware refresh, SQL Server version upgrade, server onsolidation, company merger, and more. Whether...
  • SQLGardner

    Reporting Services problem after installing MS11-100

    • 0 Comments
    I have not posted a new blog entry in the last couple months due to the holidays and doing a lot of work travel in January.  This will be a short one, but I have seen a lot of customers having issues with this. A recent security patch, which you...
  • SQLGardner

    MS12-027 may fail on servers with SQL 2005

    • 9 Comments
    The MS12-027 security bulletin was just released on 4/10 which contains a fix to Office 2003 web components. What does this have to do with SQL Server you ask? Well, SQL Server 2005 installs the Office 2003 web components as part of the install. I believe...
  • SQLGardner

    AlwaysOn Restore Revisited

    • 0 Comments
    In my last post I talked about restoring a database that is part of an Availability Group which may have backups taken from multiple instances. The problem is that MSDB is only aware of backups taken from that instance.  This means that the Database...
  • SQLGardner

    What do you mean you won’t let us install you?

    • 0 Comments
    I recently came across an puzzling SQL install issue.  Actually, it was more of a “SQL won’t let me install” issue with SQL 2008 R2. When running the SQL installer for a failover cluster, one of the prerequisite checks is that cluster validation...
  • SQLGardner

    I Used PowerShell Today…. Have You?

    • 0 Comments
    For being a Microsoft employee, I am almost ashamed to admit that I am a novice at PowerShell.  Also taking into account my scripting history with both Sybase and DB2 on UNIX systems, PowerShell should be a very comfortable place for me. That being...
  • SQLGardner

    PASS Summit 2011: My Recap and Advice on Takeaways

    • 2 Comments
    This was my first time attending the PASS Summit as a Microsoft employee, but I have been to the summit 6 times before.  I had typically gone to the summit simply for educational purposes and steered clear of a lot of networking and social events...
  • SQLGardner

    PASS Summit 2012 Recap

    • 0 Comments
    Ahh yes, yet another post PASS blog entry. I know that SQL blogs will be riddled with these types of posts for the next week, but I just gotta add in my 2 cents as well. I believe that this was my 8th time attending the PASS Summit. I still feel that...
  • SQLGardner

    I’m Speaking at PASS!

    • 0 Comments
    I believe this will be my 8th time at the summit. I first went in 2003, and I missed a year somewhere in there. This is my second time attending as a Microsoft employee, and I am excited to represent my employer as a first time speaker at PASS. I feel...
  • SQLGardner

    Lazy Log Truncation – SQLPFE Team Blog

    • 0 Comments
    I have been so busy working with customers that I have not had much time to blog as of late.  That being said, I have found a little time to contribute to the SQL PFE team blog where many of my fellow PFEs also contribute.  If you are into understanding...
  • SQLGardner

    SQL Saturday 117: Columbus, OH

    • 2 Comments
    I will be teaching a session at SQL Saturday in Columbus, OH this weekend! While I have done plenty of workshops and customer presentations, this will be my first time speaking at a user group event. I am looking forward it! My session is titled...
  • SQLGardner

    PASS Summit 2012 Session Slides

    • 0 Comments
    It has been a hectic week back at work after being in Seattle all last week. Here are the slides from my presentation SQL Server and SharePoint: Best Frienemies. Sorry for the delay! I hope that if you attended you had the time to fill out the evaluation...
  • SQLGardner

    Introduction

    • 0 Comments
    I am a SQL Server Premier Field Engineer who has been with Microsoft since March, 2011. Before joining Microsoft, I worked as a DBA for over 13 years. My primary technical expertise is with SQL Server (starting with version 6.0), but I have also managed...
  • SQLGardner

    Backup Compression Confusion

    • 0 Comments
    "When I use backup compression, I notice the backup file is very large but then once the backup is complete the file is much smaller. Is this how it is supposed to work?" In the past few weeks I have seen this question pop up a number of times, so...
  • SQLGardner

    Index Rebuild Enhancements with Newer SQL Versions

    • 0 Comments
      Wow! It has been a long time since I have blogged. Microsoft is firing on all cylinders lately and keeping us Premier Field Engineers very busy. I am going to try very hard to get back to some regular blogging about topics that I feel are good...
  • SQLGardner

    Presentation from DaySPUG

    • 0 Comments
    Thanks to the Dayton, OH SharePoint users group for having me come talk about SQL Server. Here is my presentation that I gave.
  • SQLGardner

    SQLSaturday 242

    • 1 Comments
    It has been a little while since I have done some public presentations, and today I had the opportunity to present at SQLSaturday in Indianapolis. I want to that the Indy crew for putting on a very smooth and well organized event. I also want to thank...
  • SQLGardner

    Columbus PASS on Valentine’s Day

    • 1 Comments
    I was surprised at how many SQL lovers out there showed up for our Columbus OH PASS chapter meeting on Valentines Day. I made sure to remind everyone to buy flowers on their way home! I did an overview of AlwaysOn which has to be my favorite new part...
Page 1 of 2 (26 items) 12