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
I took the beta test this morning. It was a good test. I'll know if I passed within 8 weeks but I feel good about it. I think someone who passes this will have a decent understanding of SQL Server. The 70 question test covered the broad topic of SQL Server Administration so they do not spend too much time on one topic. However, get up close and personal with security, backups and checkdb before taking the test. Questions specific to new features in SQL 2008 were sparse(pun intended). A good, experienced SQL 2005 DBA might be able to wing it with minimal preparation. I don't want to push the NDA too hard so I will leave it at that.
There were a few errors(or I am the dumby) and I commented on them. As a beta test, I was pleasantly surprised with only 70 questions. I took the SQL 2000 and SQL 2005 beta tests and they were monsters. Lots of questions and a duration of 2-3 hours. I am looking forward to the next one.
On a scale of 1-10 of difficulty, I give a 6.5-7. I am doomed to fail now. :) I say that because it seemed like the 7.0 and 2000 database design tests were so much harder. We'll see how the SQL 2008 "database design" equivalent test measures up. I will post again when I get my results.
posted @ Saturday, June 28, 2008 9:16 PM by DotNetKicks.com
posted @ Thursday, July 24, 2008 12:54 AM by Eralper
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail