• 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

Blog your way to becoming a better DBA

October 15, 2009 by John Sansom 11 Comments

One of the most rewarding aspects of Blogging is that the content you share and publish has the potential to help others in your community but have you also considered that Blogging can actually make you a better DBA? You see the act of blogging itself provides a number of subtle benefits for your professional […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: blogging

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

Why I beleive the Microsoft BI Stack seems unfinished

September 4, 2009 by John Sansom 1 Comment

Simon Sabin shared a great post with the SQL Server Community recently where he asked Where is the intelligence in Business Intelligence? This really got me thinking and I wanted to share some further thoughts with you on the subject. To me it seems as if the Business Intelligence solution stack is only three quarters […]

Filed Under: Reporting Services Tagged With: Microsoft BI

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

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model

July 27, 2009 by John Sansom 19 Comments

keep your data safe

In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility. Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of […]

Filed Under: Disaster Recovery, SQLServerCentral Syndication, SQLServerPedia Syndication

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

The Database Administrator’s Primary Responsibility

July 20, 2009 by John Sansom 45 Comments

You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which […]

Filed Under: Administration, Disaster Recovery, Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Data Loss

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

Something for the weekend 10/07/09

July 10, 2009 by John Sansom Leave a Comment

What with so much awesome SQL Server and technology content being published each week, you can have a real tough time keeping up with it all. So if you’re like me and you have a bit of extra surfing time at the weekend, then you might like to use that time to catch up on […]

Filed Under: Link Posts, SQL Server Community

SQL Server Reporting Services Tip: email subscription tweak

July 9, 2009 by John Sansom 2 Comments

What’s the problem? How to configure SQL Server Reporting Services 2005 to permit users to assign the delivery email address for their own subscriptions. Why does SQL Server work this way? When you subscribe to a report, the e-mail delivery settings you work with vary depending on whether your Role includes the “Manage individual subscriptions” […]

Filed Under: Administration, Reporting Services, SQL Server Tips

Top 5 SQL Forums

July 1, 2009 by John Sansom 34 Comments

Top SQL Server Forums

As you no doubt already know, there is a ridiculously large amount of SQL Server Information available out there on the internet. Whether you’re browsing forums, web sites or blogs, knowing what the best sources of SQL Server information are and more importantly which one’s you can trust, can be tricky. So to help you […]

Filed Under: SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Forums

  • « Previous Page
  • 1
  • …
  • 17
  • 18
  • 19
  • 20
  • 21
  • 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
  • Script SQL Server Agent Jobs Using PowerShell
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • 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 © 2022 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy