BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Thursday, November 20, 2008

SQL Server News & Information

tsql, performance tuning, industry trends, & bad jokes

exec spSubscribeMinimize
Print  
sp_help 'jmassie'Minimize

This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.

You can contact him at jason@statisticsio.com or 469.569.5965

Jason has the following certifications:
  • Microsoft Certified IT Professional Database Administrator (early adopter)
  • Microsoft Certified IT Professional Database Developer
  • MCDBA (7.0 and 2000)
  • MCSE
  • MCSD
Print  
tblTagCloudMinimize

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless

Print  

I am on a quest for a idera..err..idea of new feature. Could it be just beyond the red gate?

Posted by Jason on Thursday, April 03, 2008 to SQL Server 2008
277 Views | 1 Comments | Article Rating

The 3rd party software vendors for SQL Server are in deep shit going to have to step it up in the coming years. A lot of the new features in SQL Server 2008 were previously available commercially. Backup compression, historic reports\data collections, multiserver queries and intellisense  directly compete with 3rd party products. It can be argued that the 3rd party products are fuller featured but free(enterprise edition required for some) and simple to use goes along way. You can set backups to be compressed by default server wide so you don't even have to change your scripts. The "out of box" historic reports are nice but they are not as nice as the 3rd party offerings. This is true. Give it a little time though and I suspect that there will be plenty of reports posted up on CodePlex or in sp1.

However, the manageability enhancements are also equally as big if not bigger. Even if they do not directly compete with a 3rd party product, they have the potential to over shadow some. Click here for this tiny example. There are auditing packages that are nice but can they really complete with policy based management. All of theGUI enhancements will make 3rd party query editors and management tools almost undesirable at least for now.

So is this bad. Heck, no. This is capitalism which is how products(and then markets) get better. Now the vendors have to step it up, innovate, cut the fat or die. They will come out with cool new stuff. One is already claiming the "superhero" title. /on a market level, this will push into Oracle and visa versa. It is not like Microsoft is not innovating. I bet Oracle is working hard on filtered indexes as we speak. That's just how it works.

Imagine a world where features could be patented.

email it! |   |   |   |  | 
Permalink     1 Comments  

Rate this Post:
COMMENTS:

When Microsoft first announced the compressed backup feature, I thought exactly the same thing. But if you drill even just a little bit deeper, the more mature third party apps don't have anything to worry about. Take the backup reporting, for example - LiteSpeed's centralized backup reports work across all of your SQL Servers (2000/2005/2008), regardless of whether you're using the compression or not. I'm surprised MS still doesn't offer a central management console for things like this, but the fact is they don't, and the partners do.

Granted, a lot of shops just need the basic backup compression, and they'll be ecstatic, but for the rest of us who want to manage armies of servers in as little time as possible, the 3rd party utilities still have a big edge.

MS will take another rev or two at least to catch up, at which point they'll hopefully merge the functionality of policy-based management with some dashboard reports to show what happened in my backup world last night across all of my servers.

posted @ Thursday, April 03, 2008 6:01 AM by Brent O.


Name (required)

Email (required)

Website


Simple BBCode can be used like [URL]...[/URL] and [B]

Copyright 2006 by Statistics IO, My SQL Server Blog