• 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 16/04/2010

April 17, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week! I want to say a big thank you to everyone involved with SQLBits this week. The calibre of speakers and the quality of the presentations delivered was excellent. The highlight for me personally was the opportunity to meet with so many great SQL people and already I cannot […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend – SQL Server links for the week 09/04/10

April 9, 2010 by John Sansom 1 Comment

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 […]

Filed Under: Link Posts, SQL Server Community

Something for the Weekend: SQL Server Links 12/03/10

March 13, 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 Tuning SQL Server Transactions – and Meetings – Using a similar problem solving approach for hosting meetings and tuning transactions. The root of all Evil – I know this pain all […]

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

Something for the Weekend: SQL Server Links for the week

February 21, 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 Benchmarking: 1-TB table population (part 3: separating data and log files) – Here’s the next instalment in this excellent series from Paul Randal. How to Make SQL Server Backups and Restores Faster – […]

Filed Under: Link Posts, SQL Server Community

Soemthing for the Weekend – SQL Server Links 12/02/10

February 13, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week. One point that deserves a special mention this week is that there will be a Service Pack 4 for SQL Server 2005 following on from much debate and pressure from the SQL Server Community. For full details of the service pack release schedule see the Microsoft SQLReleaseServices Blog. Here’s this weeks […]

Filed Under: Link Posts

Something for the Weekend: SQL Server Links for the week 05/02/10

February 7, 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 Looking at Page Contents – A little code template here from Michael J Swart. Why You Might Want to Buy SQL Server 2008 Now – Brent Ozar explains why you may […]

Filed Under: Link Posts, SQL Server Community

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

January 30, 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 XML Validation in SQL Server Intergration Services – A nice walkthrough here from Simon Sabin. SQL Azure Frequently Asked Questions – So what’s this SQL Azure all about then? Brent Ozar […]

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

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

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

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

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

  • « Previous Page
  • 1
  • …
  • 10
  • 11
  • 12
  • 13
  • 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