I hope you’ve had a great week! Grab yourself a drink, pull up a chair, kick back and relax. It’s time for more SQL Server Blogtasticness (yes that’s a real word, you heard it here first).
Also, registration for SQLBits 8 is now open so get in there quick and reserve your place now to avoid disappointment.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- SQL University – Powershell Redux – From that institution of knowledge that we all know and love, the SQL University, it’s Thomas Larock.
- DBA 101: Why is my log file full? – Getting back to basics it’s Grant Fritchey. This question has been cropping up a lot lately on the forums.
- Adventures in query tuning: non-seekable WHERE clause expressions – An excellent tale of performance tuning from the field here, courtesy of Paul Randal.
- The overlooked OUTPUT clause – Another excellent T-SQL tip here and I have to admit I think I have only ever used this twice myself. How about you? It’s weird because I can see a lot of application for this technique, shared courtesy of Steve Hindmarsh.
- Ridiculously Unnormalized Database Schemas – Part One – Continuing his series on Normalization, it’s the second instalment from Michael J Swart, yeah I know it’s says Part One, go read the post fool.
- A Technical Plan for 2011 – Something a little different here from Jeremiah Peschka and a must read for the well rounded Data Professional. I’m always fascinated by the thoughts of where others believe our industry is heading.
- Distincting an IN subquery – Another excellent T-SQL walkthrough from Gail Shaw. This lady really knows her performance tuning stuff!
- Removing Time From A Datetime Value – Flexing his T-SQL muscles, Joe Web looks at conversion efficiencies extrapolating time.
- Windows Azure and SQL Azure Use Cases – Stick you head in the Cloud this week and discover how you can put this technology to work by taking a look at these Use Cases.
- Configuring IP Addresses and Dependencies for Multi-Subnet Clusters – Part II – More Clustering deep dive stuff here, brilliant.
- PBM and PowerShell – Continuing to quench my thirst for everything PowerShell, here’s a great post from Chad Miller.
UK SQL Server Upcoming Events
There are a lot of new User Groups firing up (Southampton/Surrey) this year so be sure to keep your eyes peeled for events near you.
- SQLBits 8 – 7th – 9th April – Europe’s biggest SQL Server event will be at he seaside this time around.
Provisional Dates for your Diary:
- MANCHESTER – Wed 2 Mar
- LEEDS – Thu 3 Mar
- LEEDS – Wed 11 May
- MANCHESTER – Thu 12 May
- MANCHESTER – Wed 15 Jun
- LEEDS – Thu 16 Jun
- LEEDS – Wed 20 Jul
- MANCHESTER – Thu 21 Jul
Misc Technology Posts in the News
- Amazon buys remaining stake in Lovefilm DVD service
- Facebook ‘should mimic Apple app security restrictions’
- Google gins search formula to favor its own services
That’s it for this week. What was your favourite post?