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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 11/25/2013
SQLSaturday 242
It has been a little while since I have done some public presentations, and today I had the...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 09/13/2011
Introduction
I am a SQL Server Premier Field Engineer who has been with Microsoft since March, 2011. Before...
Date: 09/13/2011