Aaron Bertrand, Author at SQLPerformance.com

Attending PASS Summit in Charlotte?

Wanted to give a heads-up about some of the sessions we're presenting at PASS Summit, some great pre-conference seminars, and a contest you'll really want to consider entering in June and July.

Aaron Bertrand ◆ May 23, 2013

0

Another argument for stored procedures

Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.

Aaron Bertrand ◆ May 17, 2013

15

Schema Switch-A-Roo : Part 2

Aaron Bertrand (@AaronBertrand) goes into a little more detail about what happens to metadata when you use schema transfers behind the scenes.

Aaron Bertrand ◆ April 30, 2013

5

Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes

Aaron Bertrand (@AaronBertrand) discusses some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped him isolate and solve the issues.

Aaron Bertrand ◆ April 25, 2013

6

How filtered indexes could be a more powerful feature

Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items!

Aaron Bertrand ◆ April 24, 2013

4

Microsoft Announces SQL Server 2012 R2 and SQL Server 2012 R3!

Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…

Aaron Bertrand ◆ April 1, 2013

8

Performance-related fixes for SQL Server 2012

In an effort to encourage you to keep your SQL Server 2012 instances up to date, I wanted to highlight a slew of performance-related fixes that are mostly available only through Service Pack 1 or various Cumulative Update packages.

Aaron Bertrand ◆ March 19, 2013

1

Break large delete operations into chunks

Aaron Bertrand (@AaronBertrand) discusses ways to optimize large delete operations, both to make them faster, and to minimize impact on the transaction log.

Aaron Bertrand ◆ March 13, 2013

48

Anonymize your plan details natively in Plan Explorer

I wanted to talk about two new features in SQL Sentry Plan Explorer: Plan obfuscation, where you can hide sensitive information in your plans before sharing them, and custom layouts, a way to take complete control over the visual representation of your graphical plans.

Aaron Bertrand ◆ March 11, 2013

6

Obfuscate sensitive data in your execution plans

Getting help with execution plans outside of your company can be a challenge, since you may not be willing to share information such as server names, database names, object names, schema, column names, index structure, and so on. Read on to see how you can protect your execution plans with a free PowerShell script from Jonathan Kehayias of SQLskills.

Aaron Bertrand ◆ March 1, 2013

2

2013 MVP Summit : A quick review and a peek forward

I had a great time at the MVP Summit last week. Caught up with a lot of friends, tried some new foods (including Tempura Fried Kurobuta Bacon), and took in some great technical sessions.

Aaron Bertrand ◆ February 25, 2013

0