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 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.  I really want feedback…. good and bad. …

0

PASS Summit 2012 Recap

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 this is the…

0

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 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 very honored to get…

0

AlwaysOn Restore Revisited

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 Recovery Advisor can’t really build the nice pretty timeline if you…

0

SQL 2012 AlwaysOn and Backups – Part 3 – Restore

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 process. First and foremost, you cannot restore a…

7

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

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 log backups in this post as the log backup piece is best…

5

I Used PowerShell Today…. Have You?

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 said, in the SQL Server space I do not always get…

0

SQL Saturday 117: Columbus, OH

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 SQL Server and SharePoint: Best Frienemies I decided to do…

2

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 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 this is part of the management tools only, but…

9