EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below by adding extra columns to give the data more context and general advice when interpreting this type of data.
Just a quick post this time. Recently I needed to find out the read/write ratio for some of our customer databases as part of a bigger project of understanding the workload and performance of the databases. The project actually through up a few surprises, where databases that I … more
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained within a CDATA section. Sure it is all perfectly valid XML at the end of the day, but it makes working with it a bit harder as each section of text between each <BR/> tag is treated as a separate text node and has to be factored into any schema for that XML structure.
I’ve been working on an XML migration project recently that has a lot of this going on. Data … more
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to make me an MCSA, but I feel like I'm looking at a dead end. Don’t get me wrong, I’m fairly happy that I passed the exam which incidentally seem to have a much higher than normal number of questions on that level of exam, but I was only really chipping through these exams on my way to try to achieve the MCSM. But now that has been pulled, this pass seems largely immaterial.
I’m … more
Over the years with each release I’m often impressed by some of the features contained in SQL server but every so often, I start to use a feature that I haven’t used before and I’m blown away by just how good that particular feature is. Sometimes it is the sheer power/flexibility of the feature that impresses me or sometimes it is ease or simplicity of implementing that feature. Because of the strength of the product, we all come to expect a host of new features with … more
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the SQL server raising a sev 20 error with a script that I was attempting to run. The work that I was doing was that I was exporting some binary data (basic text files) that is stored in one table to the file system via a filetable within the same database. It came as bit of a surprise when I saw this error message:
Location: "xact.cpp":4175Expression: … more
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded it and it weighs in at about 3.5gb... I'm supposed to be revising for an upcoming exam, but that will have to go on hold now for a few days :)
Hekaton here I come!!
I’ve been using the backup to azure feature for a short while now and I really like it. Shows I think as this is my 4th blog post on the subject this year! This feature has reduced my stress levels with regard to secure offsite backups. However, so far I have two gripes with it.
Firstly, if there is an issue during the backup i.e. network connectivity for example, the lease on blob gets orphaned and there is no native way to release it. I recently blogged about it and how I have gone … more
I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well, but a couple of times I have had an issue where I wasn’t able to overwrite a previous backup file and received an error:
Msg 3202, Level 16, State 1, Line 1Write on https://somestorage.blob.core.windows.net/somecontainer/MyDb.bak failed: Backup to URL received an exception from the remote endpoint. Exception Message: The remote server returned an error: (412) There is … more
It has been a little while since I posted something and I’ve been meaning to finish off this blog for a few weeks now, but I have been a little busy with the arrival of my 2nd son (and have been distracted by my new Alienware laptop!)… Anyway I recently blogged about how cool I thought the new feature was in SQL 2012 SP1 CU2 which allows you to natively backup/restore databases with Windows Azure Storage. Recently I have been able to set this up with some of the on-premise production databases … more
It’s been a little while since I wrote a blog post on my favourite subject but this is from a thread on the SSC Xml forum that I was helping out on a couple of weeks ago. I’ve been a bit busy lately with a big project at work, revising/taking exam 70-461 and getting ready for the birth of my second child! But this thread seemed too good a subject for me to miss quickly get a post out showing how I might approach this particular problem.
Sometimes we are given a pretty poorly … more