This month’s Redmond Mag glows about some new features in SQL 2008, and yes, it does have a lot of cool tricks up its sleeve. But before you go upgrading your servers to get those new features, there’s one thing you need to know.
New versions of SQL Server are not always faster for every query.
This [...]
Posts Tagged ‘sql2008’
Before you upgrade to SQL Server 2008…
SQL Server 2008 Management Studio: Group Execute
I’m going to show how to use a new feature in SQL Server Management Studio: the ability to query groups of servers simultaneously.
In Registered Servers, right-click on a group of servers and click New Query. What comes up will look like a normal query window, but pay close attention to the very bottom of [...]
Upcoming presentation on SQL 2008 with Kevin Kline
On October 22-23rd, you can attend Quest Connect, a free series of technology webcasts given by the subject matter experts at Quest. Kevin Kline and I will be talking about our top ten favorite features of SQL Server 2008 - things like compression, policy-based management and the resource governor. We’ll be discussing these from a [...]
SQL Server 2008 upgrade poll results & thoughts
Last week I posted a poll asking DBAs when they would use SQL Server 2008 in production. Here’s the results after one week:
In the next 3-6 months. (40%, 8 Votes)
Not planning it yet. (30%, 6 Votes)
In the next month or two. (20%, 4 Votes)
Already done. (10%, 2 Votes)
This week, I had the pleasure of going [...]
Spend a Day with the Experts - Oct 14 - Redmond, WA
So you’ve been dying to meet me, but your job at Microsoft won’t allow you to leave the Redmond area? Or maybe you’re tired of hearing all those bright people at Microsoft speak, and you want to hear a rank amateur fill your head with gobbledygook? Or maybe you just want free breakfast and lunch?
Well, [...]
SQL Server 2008’s new Central Management Server
Got more than one DBA? Want to make your life easier? You might want to configure a Central Management Server.
This is useful for fast-changing shops where there’s a lot of servers added and removed. At my last company, we had a hard enough time telling everybody when we’d finished adding a new server, or what [...]
SQL Server 2008 Sucks
SQL Server 2008 is coming fast, and there’s going to be a bunch of web posts and magazine articles telling you how great it is. I’m going to play devil’s advocate for a minute and tell you why SQL 2008 sucks.
The good stuff isn’t backwards compatible.
We can’t immediately upgrade every server in the shop. Not [...]
SQL Server Consolidation: Plan for SQL Server 2008
When you’re building a consolidation plan, stop to think about when each database will be migrated to a newer version of SQL Server.
With SQL Server 2008 coming fast, some content owners will want to move their databases to 2008 as soon as it comes out in order to take advantage of things like the resource [...]
