SQLGardner

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

SSIS The version number in the package is not valid

In a previous blog post, I showed you how you can set a target server version for an SSIS project in...

Author: SQLGardner Date: 09/30/2016

Learn SQL 2016 Polybase with HDP – Part 2 – Learning Polybase along with Hadoop Tutorials

In part 1, I showed you how you can create a Hortonworks sandbox and a SQL 2016 instance with...

Author: SQLGardner Date: 09/02/2016

Learn SQL 2016 Polybase with HDP - Part 1 - Build the Environment

I have been working with Polybase in Parallel Data Warehouse for a few years now, so I was quite...

Author: SQLGardner Date: 08/31/2016

What Does Installing Polybase Add to My SQL Server?

In this post, I want to show you some of the components that are added to your SQL Server when you...

Author: SQLGardner Date: 08/29/2016

SSDT VS2015 Gotcha - Target Server Version - new feature

If you are upgrading your SSIS packages to SSDT on Visual Studio 2015, you may not notice the...

Author: SQLGardner Date: 08/17/2016

Dogfood Conference 2015 Session Materials

I would like to thank everyone who attended the Dogfood conference this week in Columbus, OH. Being...

Author: SQLGardner Date: 10/08/2015

SSIS Tip: Using a File Path Parameter for Multiple Flat Files

SSIS with SQL 2012 and SQL 2014 brought a lot of great enhancements to SSIS that ease deployment and...

Author: SQLGardner Date: 06/18/2015

Index Rebuild Enhancements with Newer SQL Versions

  Wow! It has been a long time since I have blogged. Microsoft is firing on all cylinders...

Author: SQLGardner Date: 02/02/2015

Dogfood Conference

Last week I had the opportunity to give 2 sessions at a local IT conference in my hometown of...

Author: SQLGardner Date: 11/25/2013

SQLSaturday 242

It has been a little while since I have done some public presentations, and today I had the...

Author: SQLGardner Date: 08/10/2013

Lazy Log Truncation – SQLPFE Team Blog

I have been so busy working with customers that I have not had much time to blog as of late. ...

Author: SQLGardner Date: 06/27/2013

Presentation from DaySPUG

Thanks to the Dayton, OH SharePoint users group for having me come talk about SQL Server. Here is my...

Author: SQLGardner Date: 06/12/2013

Primary Keys and the Default Clustered Index

When it comes to determining what your clustered index should be for a given table, you often think...

Author: SQLGardner Date: 03/28/2013

Columbus PASS on Valentine’s Day

I was surprised at how many SQL lovers out there showed up for our Columbus OH PASS chapter meeting...

Author: SQLGardner Date: 02/15/2013

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

As the mother of a 3 year old, I find myself saying talking about poor choices and sitting in time...

Author: SQLGardner Date: 02/06/2013

PASS Summit 2012 Session Slides

It has been a hectic week back at work after being in Seattle all last week. Here are the slides...

Author: SQLGardner Date: 11/14/2012

PASS Summit 2012 Recap

Ahh yes, yet another post PASS blog entry. I know that SQL blogs will be riddled with these types of...

Author: SQLGardner Date: 11/11/2012

I’m Speaking at PASS!

I believe this will be my 8th time at the summit. I first went in 2003, and I missed a year...

Author: SQLGardner Date: 11/01/2012

AlwaysOn Restore Revisited

In my last post I talked about restoring a database that is part of an Availability Group which may...

Author: SQLGardner Date: 10/19/2012

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

In my last post I showed that you can perform backups from your replicas. A thought you may have had...

Author: SQLGardner Date: 07/21/2012

I Used PowerShell Today…. Have You?

For being a Microsoft employee, I am almost ashamed to admit that I am a novice at PowerShell. ...

Author: SQLGardner Date: 06/05/2012

SQL Saturday 117: Columbus, OH

I will be teaching a session at SQL Saturday in Columbus, OH this weekend! While I have done plenty...

Author: SQLGardner Date: 05/31/2012

MS12-027 may fail on servers with SQL 2005

The MS12-027 security bulletin was just released on 4/10 which contains a fix to Office 2003 web...

Author: SQLGardner Date: 04/12/2012

Reporting Services problem after installing MS11-100

I have not posted a new blog entry in the last couple months due to the holidays and doing a lot of...

Author: SQLGardner Date: 02/10/2012

Identifying Contention in TempDB

It has been a number of years since I have seen a TempDB contention issue in a system that I...

Author: SQLGardner Date: 12/05/2011

PASS Summit 2011: My Recap and Advice on Takeaways

This was my first time attending the PASS Summit as a Microsoft employee, but I have been to the...

Author: SQLGardner Date: 10/19/2011

Implementing Log Shipping for Many Databases

In my previous post, I discussed using log shipping as a method for migrating databases to reduce...

Author: SQLGardner Date: 09/27/2011

Minimizing DB Migration Downtime Using Log Shipping

A common and often unpleasant task for DBA involves moving databases between physically separate SQL...

Author: SQLGardner Date: 09/16/2011

Backup Compression Confusion

"When I use backup compression, I notice the backup file is very large but then once the backup is...

Author: SQLGardner Date: 09/13/2011

Introduction

I am a SQL Server Premier Field Engineer who has been with Microsoft since March, 2011. Before...

Author: SQLGardner Date: 09/13/2011