• 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 for the week 14/01/10

January 17, 2010 by John Sansom 2 Comments

I hope you’ve had a great week. Have you got what it takes to be a SQL Server DBA or are you looking for that new SQL Server role? Be sure not to miss my Top 10 Junior DBA Interview Tips. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! […]

Filed Under: Link Posts, SQL Server Community Tagged With: Events

Something for the weekend: SQL Server Links 08/01/10

January 8, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links ‘Cannot Generate SSPI Context’ and Service Account Passwords – An interesting case walk-through here from the CSS SQL Server Engineers, albeit quite specialised. Should PASS hold the conference on the East […]

Filed Under: Link Posts, SQL Server Community

Something for the weekend: SQL Server Links 01/01/10

January 2, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks, smaller than usual due to the Holidays, roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links sp_db_space_usage – A very nice stored procedure from Tibor Karaszi for reporting database size details. Getting the ISO Week and Year – Handy little […]

Filed Under: Link Posts, SQL Server Community

Something for the weekend: SQL Server Links (Xmas Edition)

December 25, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Delimited String Tennis Anyone? – An interesting look at the performance implications of using XML to process delimited string data resulting from a derived column cast. Brad Schulz discusses. Those Four […]

Filed Under: Link Posts, SQL Server Community

Something for the weekend – SQL Server Links 11/12/09

December 12, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links How Quest is Bringing DBAs Online – Discover how Quest are harnessing the expert knowledge of DBA’s globally in this post by Brent Ozar. Finding your Missing Keys – Well defined […]

Filed Under: Link Posts, SQL Server Community

Something for the weekend: SQL Server Links 04/12/09

December 6, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Comparison: Switching Tables vs. sp_rename – An interesting walk-through that evaluates the differences between using the sp_rename system stored procedure and the partitioning support SWITCH statement, courtesy of the The Database […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend: SQL Server Links 30/10/09

October 31, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. You may have noticed that I have not been around quite so much these last few weeks. Well I can promise you won’t hear any excuses for posting less content from me, that’s just not my style (Apology Accepted). Aside from having enjoyed a well deserved (yes I […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend: SQL Server Links 02/10/09

October 2, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links How do CHECKPOINTS work and what gets logged? – A  detailed and intricate explanation by Paul Randal of what goes on under the hood of the SQL Server database engine when […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend: SQL Server Links 18/09/09

September 18, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week. The SQL Server Guru Challenge league table has been updated to reflect the latest results. Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links The Importance of a good DR Plan – The results are in! Be sure to take […]

Filed Under: Link Posts, SQL Server Community Tagged With: Events

Article Published on SQL Server Central

September 14, 2009 by John Sansom Leave a Comment

I have just had my latest article published on SQL Server Central and so thought I would give it a shameless plug here. It is the first article in the SQL Server Essentials Series and discusses the principle skills, knowledge and ideals that I believe provide the core foundation of a SQL Server professional. I […]

Filed Under: SQL Server Community Tagged With: Published Articles

SQLBits Registration is now open

August 25, 2009 by John Sansom Leave a Comment

Registration for arguably the UK’s largest SQL Server event is now open. To guarantee you do not miss out be sure to reserve your interest by registering here.

Filed Under: SQL Server Community Tagged With: SQLBits

Something for the Weekend: SQL Server Links this week 21/08/09

August 21, 2009 by John Sansom 1 Comment

I hope you’ve had a great week! New to SQL Server or just getting started on the road to becoming a DBA? Then you will want to check out the SQL Server Essentials Series. With the Holiday Season coming to an end it’s time to get the SQL Server Guru Challenge under way. If you […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend: SQL Server Links this week 14/08/09

August 15, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week! This weeks hot topic has been the release of SQL Server 2008 R2. The SQL Server guru’s fortunate enough to get their mitts on a copy, let along have the time to play with it, have been sharing their findings on the Blog-sphere. Here’s this weeks roundup of […]

Filed Under: Link Posts, SQL Server Community

SQL Server 2008 R2 CTP – Now available to download

August 10, 2009 by John Sansom Leave a Comment

That’s right, the Microsoft SQL Server 2008 R2 Community Technology Preview (CTP) is now available for download. SQL Server 2008 R2 CTP Go ahead and take a look at the preview. It’s a great chance to get a first look and experiment with some of the new features. Be sure to let me know how […]

Filed Under: SQL Server Community

Something for the weekend: SQL Server Links 07/08/09

August 7, 2009 by John Sansom Leave a Comment

I hope you’ve had a great week! Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy! SQL Server Links Stolen Pages, Ad-hoc queries and the sins of dynamic SQL in the application – Excellent well written example on how dynamic ad-hoc queries can, if left to get out of hand, […]

Filed Under: Link Posts, SQL Server Community

What do you think the future holds for database technology?

August 7, 2009 by John Sansom Leave a Comment

The good old Relational Database Management System (RDBMS) has been around for quite some time now and is still, certainly in my opinion, the mainstay of the majority of production platforms/software applications. Recently there seems to be a great deal of hype in the community regarding relatively young database technologies such as Cloud Services (SQL […]

Filed Under: SQL Server Community

Something for the weekend 31/07/09

July 31, 2009 by John Sansom 1 Comment

Have you had a good week? This past week has been both horrendously busy and challenging for me, although strangely I actually enjoyed it and  dare I say, I quite like it that way. There is just something about getting stuck into tough projects that brings out the best in us DBA’s and challenges us […]

Filed Under: Link Posts, SQL Server Community

Something for the weekend 24/07/09

July 24, 2009 by John Sansom Leave a Comment

There’s been a lot of banter and hype in the SQL Server community this week about the upcoming PASS Summit. Bloggers and Tweeters alike have been sharing their thoughts on which pre-conferences to attend, organising post conference social events and exchanging tips on networking. If you’re not one of the lucky attendees this year then […]

Filed Under: Link Posts, SQL Server Community

Win an all expenses paid trip to PASS 2009!

July 23, 2009 by John Sansom Leave a Comment

If you are like me and absolutely gutted that you cannot attend the PASS 2009 summit, then this could be just the ticket that you have been waiting for. Understandably if you live/work on the other side of the globe it is not exactly the most practical of away fixtures to attend and getting sign […]

Filed Under: SQL Server Community Tagged With: SQLPass

Something for the Weekend 17/07/09

July 17, 2009 by John Sansom Leave a Comment

Another week has zoomed by again and so it’s time for you to kick back, relax and enjoy some the best SQL Server content on offer this past week. SQL Server Links VLDBs and Instant File Initialization – In this podcast, Brent Ozar talks about a simple problem: managing file growth when your files are […]

Filed Under: Link Posts, SQL Server Community

  • « Previous Page
  • 1
  • …
  • 12
  • 13
  • 14
  • 15
  • Next Page »

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