Dogfood Conference 2015 Session Materials

I would like to thank everyone who attended the Dogfood conference this week in Columbus, OH. Being born and raised in central Ohio, I feel a strong connection with the local community. I love getting the chance to participate in local IT events.   The team did a great job organizing a wonderful conference! I hope to present next…

0

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 reconfiguration of packages. The project deployment model, SSIS Catalog, and parameters make it a lot easier to manage SSIS . It also helps decouple environmental configurations from the SSIS code. This way DBAs don’t need to…

2

Index Rebuild Enhancements with Newer SQL Versions

  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 points for customers. The other day I…

0

Dogfood Conference

Last week I had the opportunity to give 2 sessions at a local IT conference in my hometown of Columbus, Ohio.  I gave a talk on using SQL Server Data Tools and another on SQL Server File Management.  I always enjoy getting to speak at community events, and especially local ones that are free for…

0

SQLSaturday 242

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 the sponsors as without them, SQLSaturday would not…

1

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.  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 more about SQL internals, especially…

0

Presentation from DaySPUG

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

0

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 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, though, depending on how your data is being accessed. …

1

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 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 of SQL Server.  It really addresses…

0

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 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 also notice that with my customers that…

0