CHECKDB bug that people are hitting – Msg 8967, Level 16, State 216
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
Before I start, I want to make it clear that you can only hit this bug if you ALREADY have corruption, that it’s quite rare,
My first magazine article is in print! I’ve taken over the bi-monthly SQL Q&A column for TechNet Magazine and I just received the June magazine
So Seattle weather went from 50 degrees to 85 degrees overnight Friday and we all went from shivering to sweating! It's too hot to be
Kimberly and I were presenting at our local (Redmond) .Net Developers Association on Monday and the following question came up while Kimberly was talking about
We’re sitting here in St. Pete Beach in Florida visiting some of Kimberly’s family and having some sun-kissed R&R before heading back up to Seattle
Today’s the final day of SQL Connections proper (tomorrow is post-conference workshops). We’ve really enjoyed the conference (as usual!) and it’s been a blast answering
Many times I've been asked to do a blog post about creating Agent alerts, and given that today I demo'd it as part of our
It’s been quite a while since I wrote a blog post on a flight but I happened to be playing with a CTP-6 VPC
Here's a quickie just before we head off to SQL Connections in Orlando. On one of the internal MS forums was the question – how
Over the weekend there was a question on one of the internal aliases at MS: how can I tell what percentage of a database has
Now we’re back from Iceland and I have a week to catch up with some content development before the MVP Summit next week and then
(And this isn’t an April Fool…) I’m very pleased to announce that I’ve been made a SQL Server MVP for 2008. For the eight
(Redmond, WA: For immediate release worldwide) Today, in a surprise development that has stunned industry analysts, SQLskills.com announced a new technology for DBAs that will
Fixed now – thanks so much! Folks – a couple of people have setup their systems to refresh *all* our category feeds every five minutes
Hot on the heels of a frenzied few weeks of teaching for Microsoft and we’re off again – this time to Iceland! I’ve been wanting
This is a really interesting question that came up in the Microsoft Certified Architect class I’m teaching at present – if a database has torn-page
One of the drawbacks of not being in the SQL team at Microsoft any longer is that I don’t know about all the undocumented features
Well this one is well overdue and I’m in the middle of writing a class where I want to reference this blog post –
It seems that today is going to be one of those days where I get lost in forums and blogging – I can live with
[Edit: From 2016 SP2 onward, you can use SELECT DATABASEPROPERTYEX (‘dbname’ , ‘LastGoodCheckDbTime’ ); instead] This came up several times during the week so I
Here’s an interesting question that came in to our questions line (questions@SQLskills.com – no guarantee of an answer – I check it every so often): I
While I was at Microsoft, I wrote some code in the Storage Engine to very easily return all the IAM chains/allocation units (see this post
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and
The second part of our radio interview with TechNet has been released (see here for part 1). In this installment we discuss troubleshooting and manageability
(Cross-posted on Paul and Kimberly’s blogs) With the Spring SQL Server Connections show coming up next month, its time to start planning for the Fall
During the various courses I've been teaching, people are interested in how FILESTREAM performance compares with storing BLOBs in the database itself. I have some
Just over a month ago I posted on how to enable FILESTREAM in CTP-5 and the pre-CTP-6 build I was working with. Now that’s all
Wow – almost 10 days without a blog post – that must be a record for me! :-) Never fear – I'll be posting more
SQL Connections is in less than two months now and our pre-con and post-con workshops are filling up fast – checkout my previous blog post
Here’s a question that came in – what changed in SQL Server 2005 that allows concurrent log and full backups? First a little background, in
A few short notes this morning regarding the blogs and other stuff. We had a big outage over the weekend, which rather embarrassingly manifested itself
Phew – last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs/IT-Pros to about 130 Microsoft SQL Server
Last year I posted on my old blog about the active SQL Server team blogs. I just happened to post on February 14th and so
Almost a year ago to the day I asked a question on my old blog – how long does *your* CHECKDB take to run? Well,
After many reminders (thanks Adam Machanic!) I’ve added Conor and Simon to the two aggregated feeds over all the SQLskills.com blogs. There are two feeds:
This post is based on one from my old MSDN blog but the topic has come up a few times in recent days so I
The second post in my series on FILESTREAM (see here) deals with how to enable FILESTREAM through T-SQL and using SSMS. You can’t just create
Here’s an issue that I thought was a one-off but it just popped up again over the weekend so I want to publicize it. DBA
Now we’re back at home and working very strange hours as we deal with jet-lag. The flight back from Beijing to Vancouver was a great
In a previous post (see here) I debunked a myth about how much transaction log a full backup would include. I had a question
Well, I bet that title grabbed a bunch of people’s attention :-) In the Beijing Advanced Research Centre offices of Microsoft where we’re teaching this
This is a post I’ve been meaning to do for a while – detailing some of the problems you can run into when using database
This has been causing some problems on the various groups and forums over the last few days so I thought I’d repost this from my
A bit more traffic on the thread (see previous post here) prompted me to give my thoughts on the many sweeping generalizations that plague the
There’s been a very interesting discussion going on over at SQLServerCentral.com about whether to create multiple files for a user database because the server has multiple
This kind of follows on from my previous post about making sure you have character column lengths that can handle data from different countries (e.g. city
Microsoft has announced that the RTM date of SQL Server 2008 has slipped out to Q3 of this year. See this official blog post here.
Start of the second week in China. We flew up from Shanghai to Beijing yesterday, and just in time it seems. As we flew out
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.