I hope you’ve had a great week!
Be sure to register for 24 Hours of PASS 2010.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- A DMV a Day – Day 7 – Day 7 of this excellent article series from Glenn Berry that looks at a variety of SQL Server DMV’s. This particular installment focuses on the SQL Server index related DMV’s.
- SQL Server MCM is too Easy – Simon Sabin discusses his thoughts on the SQL Server MCM following on from Brent Ozar’s awesome blog series of his MCM experience.
- A SQL Server DBA myth a day: (6/30) three null bitmap myths – Paul Randal dispels another SQL Server myth.
- Oracle DBA Year One – Awesome article here from Jason Massie that contrasts SQL Server and Oracle. It’s always a good idea to keep an eye on the competition. I mean Oracle not Jason ;-)
- A SQL Server DBA myth a day: (5/30) AWE must be enabled on 64-bit servers – I know I have seen this one quite a few times before.
- A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations – Can Online index operations cause blocking? They sure can!
- Learn How Vendors Price Their Software – Although not directly pertinent to SQL Server, an interesting read nonetheless.
- Moving the Transaction log file of the Mirror Database – An excellent administrative themed post here from the SQL Server Developer Customer Advisory Team.
- Transaction Phenomena – Part 4: Serializable vs. Snapshot – Fantastic blog post series from Michael J Swart, looking at SQL Server Isolation levels.
- Encrypted Stored Procedures and Their Effect on my Rug – We are all entitled to a rant every now and then…
- How Selective Do we need to be for an index to be used? – A nice walk-through here as Tibor Karaszi reveals all.
SQL Server Upcoming Events
- SQL Connections – 12 -14 April 2010 – Las Vegas
- SQL Bits – 16th April 2010 – London, UK
- PASS European Conference – 21-23rd April 2010 – Germany
- 24 Hours of PASS 2010 – 19th May, Global.
- Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! Send me an email or contact me on Twitter.