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 PHP Driver for SQL Server 2005 RTM'ed today. A few months ago, I posted about the WIMP(Windows 2008, IIS7, MSSQL, PHP) stack that Microsoft was working on to take on the LAMP(Linux, Apache, MySQL, PHP) stack. Supposedly, Microsoft has made some tremendous strides in PHP performance with IIS7. I was like "meh" until today when they released the PHP driver for SQL Server 2005.
Test drive time?
Hmm, maybe it is time to setup a wordpress mirror. While looking looking for some IIS\PHP benchmark, I found this post that details the setup. I am pretty sure I could hack the MySQL code to work on MSSQL. *Looks at plate. Reconsiders.*
This post is useless without numbers
What does concerns me a little is the lack of benchmarks. It seems like it would be really easy to take the same open source php apps and the same hardware then run some linux vs. windows 2008 performance tests. I just did some quick searches so they may exists. The windows performance team did release their php tuning guidelines. Come on with the numbers Microsoft!
Time to over deliver
Really, it has to be better than LAMP or the community will chew it up and spit it out. I hope WIMP is actually hefty, hefty, hefty. I think MSSQL(and Oracle\DB2) have had slower growth due to open source RDMS bleed. A stout windows PHP platform, this driver and SQL Server 2008 Web Edition will better position MS in that segment.
posted @ Tuesday, July 29, 2008 11:04 AM by Stephen
posted @ Tuesday, July 29, 2008 11:29 AM by JasonMassie
posted @ Thursday, July 31, 2008 1:50 PM by Adam Machanic
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail