John Martin Talks to the Nelson SQL Server user group on securing your data.Read More →
Category: SQL Server
SQL Saturday Sydney is on 27th February and includes….ME! And some good speakers. If you are going to be in the Sydney area I strongly recommend that you come along for a great day of free SQL content from some fantastic International speakers. http://www.sqlsaturday.com/468/eventhome.aspx I’ll be doing a presentation on High Availability and disaster recovery, […]Read More →
The CXPacket Wait is one of the most misunderstood and misexplained wait types I’ve come across. It’s not so much that people don’t know what it is, but that people don’t know when they need to do something about it.Read More →
We’ve been migrating a client to new AX servers and we hit an error that I’ve seen a few times now where AX attempts to create a table in the tempdb database and is denied permissions.
Object Server 01: The database reported (session 14 (user)): [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE TABLE permission denied in database ‘tempdb’.
This error is due to AX’s method of using persistent ‘temp’ tables in the tempdb database(The same design decision that makes high availability for AX such a chore), and is not difficult to resolve.Read More →
An interesting issue occurred in a client environment today. The configuration was an Always On Availability Group which had a primary replica(Also a SQL cluster), a reporting replica(non-voting) and a DR replica in a different data center. There was a cluster issue the previous night which saw the report server removed from the cluster. The cluster and the availability group both recovered within 60 seconds. However one of the databases in the AOAG could not be queried from. The Availability group confirmed the database was healthy and data was transferring to it fine, but any select query just ran forever.Read More →
Luckily, in this day and age we don’t see so much database corruption, but it still sends a chill down the spine every time it pops up. Having doubt with a number of cases in a number of different places now it’s not the corruption that bothers me so much as the pure amount of time it takes to fix. Here’s some tips to get the application online as quickly as possible.Read More →
This is a piece of code I use to determine the last known good DBCC CHECKDB being run against a database. I’m surprised this information is so tricky to find. I’d expect it to be sitting on the database properties tab right under last known full backup. but it’s not. Instead it is listed as a database Info property, and we need to jump through some hoops to find it.Read More →