• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Something for the Weekend – SQL Server Links 14/01/11

January 14, 2011 by John Sansom 1 Comment

It’s that time of the week again already! It’s Friday and so time for your weekly fix of SQL goodness. I hope you’ve had a great week.

Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

  • Three Questions You Should Never Ask Software Vendors – Not someone I would normally consider as reserved when it comes to speaking their mind (that’s a good thing in my book by the way), an interesting change of perspective then from Brent Ozar.
  • How to Obtain and Install SQL Server Service Packs and Cumulative Updates – Discussing how he likes to manage his environment, I give you Glenn Berry. Contains interesting discussions about what to apply and when.
  • Which User Made That Change? – Paranoid about what your developers have been up to in your environment? You should be :-) Here’s one method that you can use to keep an eye on things.
  • SqlBulkCopy to SQL Server in Parallel – I’m a bit of a performance freak, I just love squeezing as much performance as I can out of the application platforms I care for and that’s why I think posts such as this from Adrian Hills(@AdaTheDev) are like gold dust, enjoy!
  • SQL Server – New Drives Use 4K Sector Size – Some VERY interesting information here from the CSS SQL Server Engineers, I had no idea that this issue was on the horizon. Make sure you do not get caught out.
  • SQL Server Index Tuning for Mere Mortals – The second post from Glenn Berry this week that caught my attention, this time looking at some of the ways you can tune your indexes.
  • Discussion About SQL Server I/O – This post provides some exceptionally interesting insights of SQL Server I/O internals. You may want to get the coffee in first mind, it’s not an easy read.
  • Ridiculously Unnormalized Database Schemas – Part Zero – Welcoming Michael J Swart back into the blogging fray, following on from his New Year resolution to hit that scary post button weekly. Good stuff I say!
  • Effective Clustered Indexes – With her first and outstanding Simple-Talk article, it’s Michelle Ufford.
  • One Of These Things Is Not Like The Others – An interesting little Gotcha/nuance here from Tim Ford.
  • How To: Execute all SQL files in a Directory with Powershell – Keeping up with my goal of getting PowerShell firmly under my belt this year, here’s a very hand script indeed from Andy Lohn (or is it that chap from Glee).

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.

  • SOUTHAMPTON – Wed Jan 19 –  User group evening of Exploring SQL Server’s Architecture with Christian Bolton
  • SURREY – Wed 19 Jan – Gavin Payne and chums cover contemporary technology topics for those using SQL Server in 2011.
  • LEEDS – Wed 19 Jan – Chris Burns and the Resource Governor and Policy Based Management with Chris Testa-O’Neill
  • MANCHESTER – Thu 20 Jan – User Group meeting with Tony Rogerson
  • 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

  • Gamers raid medical server to host Call of Duty – Well it is a great game….
  • Jimmy Wales says Wikipedia too complicated for many – Why don’t you say what you really mean huh.
  • Winklevoss twins gamble $65m for Facebook fortune

That’s it for this week. What was your favourite post?

If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me on Twitter(@JohnSansom).

Filed Under: Link Posts, SQL Server Community

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy