• Skip to main content
  • Skip to primary sidebar

DBA Diaries

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

Career Development

Have You Set Yourself Any Goals for the New Year?

January 12, 2013 by Andy Hayes 2 Comments

"New year, new start" - I've heard that saying several times and it could mean the start of many different things. A new diet, a new fitness regime, a new job or complete career change. Giving up a vice, a new qualification, a new life - there will be others I'm sure. I don't usually do new years resolutions but this year I have set myself some new targets and they are … [Read more...] about Have You Set Yourself Any Goals for the New Year?

SQL books that I frequently use

June 25, 2012 by Andy Hayes 3 Comments

sql server books mysql books

In my current role, we have a mixture of SQL Server and MySQL installations and over the courses of time, I have built up a fair size collection of books on these two database platforms. I keep some of them at home. As we have grown as a family, available space in the house has subsequently reduced and I sometimes receive polite complaints from my better half because of the … [Read more...] about SQL books that I frequently use

SQL Server Certification – 2 for 1 exam offer

April 29, 2012 by Andy Hayes Leave a Comment

I came across this today and wanted to share it with you. If you are interested in SQL Server certification then for a limited time, Microsoft are offering "2 for 1" on SQL Server exams. Between April 11 2012 and June 30 2012, you can purchase a SQL Server exam at full price and then once you have taken it you will be emailed a voucher for the second exam at no additional … [Read more...] about SQL Server Certification – 2 for 1 exam offer

SQL Server Virtual Labs saves you time and resource

April 22, 2012 by Andy Hayes Leave a Comment

SQL Server Virtual Labs

If you have wanted to try SQL Server 2012 and learn about its new features but have not had the time or capacity to set yourself up a test environment then go over to SQL Server Virtual Labs where you can fire up SQL Server 2012 in an instant. At the time of writing this post, there is no cost involved in running these labs. They don't just cover SQL Server 2012, there are … [Read more...] about SQL Server Virtual Labs saves you time and resource

SQL Server 2012 certification – part 2

April 14, 2012 by Andy Hayes 8 Comments

sql server 2012 certification

I previously wrote about SQL Server 2012 certification in March and at the time of writing the post, the information on the Microsoft website about the SQL Server certification paths that you could take spoke of "Professional Level Certifications". I also wrote that there did not appear to be a comparative MCTS to MCITP achievement path and that in order to be qualified, you … [Read more...] about SQL Server 2012 certification – part 2

Next 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 ©