• Skip to main content
  • Skip to primary sidebar

DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

Career Development

Get a SQL Server 2012 ebook for free!

March 25, 2012 by Andy Hayes 1 Comment

Introducing Microsoft SQL Server 2012

I've just downloaded a free ebook on SQL Server 2012. Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner) It's 229 pages long and so provides a good amount of content with 10 chapters. If you have read my previous post on SQL Server 2012 certification and you are going for the certification or if you simply want to learn … [Read more...] about Get a SQL Server 2012 ebook for free!

SQL Server 2012 certification

March 18, 2012 by Andy Hayes 4 Comments

sql server 2012 certification

So SQL Server 2012 has gone RTM and I am considering studying for a SQL Server 2012 certification. At the time of writing this post, the exams are not yet available but are due in June 2012 with the beta exams happening in March 2012. For this release, in order to attain a SQL Server 2012 certification you must pass five exams but if you are already SQL Server 2008 MCITP … [Read more...] about SQL Server 2012 certification

Keeping fit could improve your performance as a DBA

March 17, 2012 by Andy Hayes 6 Comments

superman dba

It is not uncommon for a DBA to work long hours. In addition to the 9-5 standard, there will requirements to stay later after work to meet deadlines or because there is a problem with a production server that requires your attention. 50-60 hour weeks can become the norm and there may also be an on-call system in place which you may be part of. There is a lot of pressure … [Read more...] about Keeping fit could improve your performance as a DBA

« Previous Page

Primary Sidebar

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to shrink tempdb
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright ©