People have been complaining that I’ve stopped blogging so much – vacation folks, vacation! Today I’ve got a few class and conference posts to get
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
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
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
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
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
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
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:
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
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.
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
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
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
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
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL
One of the cool features added in SQL Server 2005 for scaling-out a workload was peer-to-peer replication. The major drawback was that to change an
On the last day of SQL Connections a couple of weeks back we did a 20 minute TV interview with Steve Wynkoop of SSWUG. Apart from
There’s a well known problem that every time a backup operation succeeds a message is written into the error log and Windows event log. If
All the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed. So that's the topic
As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There’s a
Lots of people have been asking for us to create some aggregate feeds of the various blogs on the SQLskills site – well, now I’ve
With the November 5-9th SQL Connections conference in Las Vegas around the corner, Shirley Brothers, the Connections Conference Manager, would like to start planning the
Are you coming to SQL Connections in November? If you are, and you’re coming to either of our interactive sessions, we invite you to send
In SQL Server 2005, queries over partitioned tables use a single-thread per partition. This can cause performance problems under certain circumstances: On systems with many
November’s going to be a busy month for Kimberly and I! Hot on the heels of SQL Connections in Las Vegas is
SQL Server supports lock escalation – when the server decides to move from a large number of row or page locks on an object to a
Part of the improvements to database mirroring in SQL Server 2008 are the addition of 10 new performance counters under the Database Mirroring Performance Object.
One of the hottest features in SQL Server 2005 is database mirroring, and it’s helped many companies implement successful and relatively inexpensive high-availability strategies. In
Over the next few months I’ll be blogging a lot about new features that are coming in SQL Server 2008 for DBAs and ITPros. First
The Fall conference season is on us again! Building on the great reaction to our co-presented Database Maintenance workshop at SQL Connections in Orlando,
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.