I walked into the office this morning and got asked a strange question: “Does a database you detach and re-attach have the same database id before and after the detach?”. While it may appear that it does in a simple test, it actually doesn’t – it just takes the next available id. If you detach […]
Read More →SQL Saturday Auckland
SQL Saturday Auckland is on October 15th and is being hosted in the Microsoft Office in the Auckland Viaduct. I’m fortunate enough to have been selected as a speaker which will mean dusting off my HA and DR talk which I last presented back at the start of the year in SQL Saturday Sydney.
Read More →SQL Sentry Plan Explorer
I’m all for spreading good news as far and wide as possible. So I wanted to make sure everyone knows that the good folks at SQL Sentry have made the pro edition of SQL Sentry plan Explorer FREE!
Read More →Alan Featherston(TradeMe) On Online OLTP
Alan Featherston is presenting to the Nelson SQL Server User Group – Wednesday 10th August 2016.
Read More →Schedulers Unexpectedly Offline in Enterprise Edition of SQL 2012
If you are running the Enterprise Edition of 2012 and if you have more than 20 cores, we recommend you take a peak at sys.dm_os_schedulers to make sure you are getting all of what you are paying for.
Read More →SQL Saturday South Island
Sign up for SQL Saturday South Island and listen to a great range of speakers(and me) giving free training on SQL Server.
Read More →Productivity Video from Pluralsight
I hate the feeling that I am spending my whole day reacting to other peoples requests and problems, but this has become more and more of an issue since I moved into a new role last October. There’s not many free blocks of 30 minutes in my day. But spending 30 minutes to learn how to get more blocks of 30 minutes to do stuff in seemed to make sense.
Read More →