More on how much transaction log a full backup includes
In a previous post (see here) I debunked a myth about how much transaction log a full backup would include. I had a question
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
It seems like all I’ve been talking about on the forums the last couple of days is the correct order of operations in a maintenance
Well it’s the end of our first week in China – tomorrow we fly to Beijing for another week of teaching. Hopefully we’ll get to
Nothing technical in this blog post for a change, just some info about the first trip of the year for us. We’re in China for
One of the cool features of SQL Server 2008 for developers is spatial data support. There have been some great posts recently about using spatial
Despite the fact that I was in the Storage Engine, and there’s always been humorous rivalry between the Storage Engine team and the Relational Engine
Back in October 2007 I blogged about partition-level lock escalation in SQL Server 2008 (see here) and I promised to do a follow-up once
Just got an email notification of a new whitepaper from the SQL Customer Advisory Team on Database Mirroring and Log Shipping Working Together. It covers:
There’s a new whitepaper on TechNet that I’ve just come across (even though it was published 6 months ago!) called Predeployment I/O Best Practices. It’s
Quickie today as I’m preparing to speak at the Pacific Northwest SQL Server User Group meeting tonight on the MS Campus here in Redmond (my
Back in September last year I blogged about the native Backup Compression that is in SQL Server 2008 (see here) and promised to blog more
Hit another issue last night while playing with the latest CTP – VS2005 can’t cope with some of the changes in SS2008. The problem arose
I came across an interesting bug in Management Studio in the latest Katmai CTP today – when a connection disconnects from a database, SSMS doesn’t
No sooner has Fall conference season finished then it’s New Year and we start everything all over again! SQLskills (Me, Kimberly, Bob, and Stacia) is
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.