SQL Server News & Information tsql, performance tuning, industry trends, & bad jokes
tsql, performance tuning, industry trends, & bad jokes
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
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
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.
posted @ Thursday, April 03, 2008 6:01 AM by Brent O.
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail