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.
Continue Reading »May 232013
May 212013
Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.
Continue Reading »May 172013
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.
Continue Reading »Apr 302013
SQL Sentry’s Aaron Bertrand (@AaronBertrand) goes into a little more detail about what happens to metadata when you use schema transfers behind the scenes.
Continue Reading »Apr 252013
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.
Continue Reading »