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
What can I say? Another great day at TechED. My highlight was Adam Machanic's error handling session. I learned something new! I liked Andrew Kelly's trace session too but I do everything he does when analyzing traces already. Nice to know that I was on track. I have a trace session coming up in Swynk's vconference that is pretty similar + SQL 2008 updates. I worked the storage engine station for a while and helped customers. That was cool. I did sneak in to Peter DeBetta's and Michael Wang's session for a few minutes to snap a few picks.
As cool as TechED is, I must say that the SQL content is better at PASS and SQL Connections. I have done all three from both sides of the podium. I can honestly say that from a purely technical view of things, I would rank it like this: PASS, SQL Connections, TechED.
Anyway, here are today's the pics.
Â
ÂÂ
P.S. I can't wait to get home to the wife and kid's. Hi, honey!
Get it here. Once I get back home on FIOS, I will upload the whole virtual hard drive used in the presentation.
I am going to be in Orlando for SQL Connections starting tomorrow. I am planning on posting updates here, on twitter, along with pics and video footage on flickr. The easier way follow is FriendFeed. It will aggregate all of these sources. I will also be at the PreConn workshops given by BobB and Itzak Ben Gaan. Hopefully, they will make my head hurt in a good way.
Ping me if you are going to be attending.
There are a couple new features that I would like to quickly point out. These are basically just tools that I use daily so I integrated them into the site. I hope you find them useful.
ALT HEAD: HOWTO: Inserting dummy data
I am speaking SQL Connections in Orlando this April. The session is entitled "Augmenting the DBA toolbox with SSRS" It will be similar to my pass session except it is all about Reporting Services and it will be 100% SQL 2008. However, most reports will be 2005 compatible with minor changes. It will totally be about working smarter not harder. I will have a ton of tools that you can integrate into your environment and I will show you how to put your existing tools to work.
I am really excited about this. I missed this year but I went in 2006 and 2005. For more infomation, check out http://sqlconnections.com You can also read the co-chair blogs here and here.