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
PASS has brought a lot of new SQL folks to twitter and people who were causal users previously have really embraced it. I hope they stick around long enough to “get it”. There are few things you have to do to make the experience good. Ok, one more list.
1. You have to follow enough people with similar interests. “Enough” is relative. 200 is a good number. I need 1000+ but I like to drink from the fire hose.
2. A good start is to follow everyone here, here and here.
3. Search for people with similar interests at http://search.twitter.com
4. Get a real client. I like outtwit. Others like digsby, tweekdeck, twhirl, witty.
5. Use it to update your facebook status.
Related posts:
Social Computing for the DBA
This Update Came from SQL Server
A SQLCLR Twitter Client
SQLBlog on twitter(see video)
Cool SQL People that I Follow on Twitter
Twitter 101
Not sold yet, see all of the SQL and PASS comments. On top of that, you get to know the smart SQL people much greater detail than you would on the forums or newgroups. I will be presenting on Social computing for the DBA December 3rd. Stop by.
A lot of stuff was announced and covered extensively. I shared a good chunk of the posts here. If I missed your PASS review\post\etc, feel free to add it in the comments. There were several things that I didn’t see much coverage on so I will add to the discussion.
1. You can sign up for the Kilimanjaro private CTP and a free SQL 2008 hyper-v instance here. I heard about this from http://edge.microsoft.com
2. The MSDN\Technet forums went live on Velocity CTP2 via @cslemp.
3. The cloud ORM SQL data services in now in public CTP.
4. Keep an eye on http://www.codeplex.com/SSISTwitterSuite from @AndyLeonard and @JessicaMMoss
4. SQLBatman announced Sarah Palin as his running mate. He is passing out deep fried Twinkies wrapped in moose bacon for swag as we speak.
I have found a lot of new SQL blogs lately. Here are the top 5 top 10 in no particular order. I am going to try to make this a monthly post.
While they may be new to me, they may not be new. I am going to try to stick with ones that A) have good content and B) may not be getting enough attention. It is hard for me to judge B. It mostly just based on my perception which could be wrong. :)
So if you are not on the list don’t take offense. Nothing personal but your blog sucks. Just kidding!
1.
SQL Fool (WWW, RSS)
Author: Michelle F. Ufford
Recent Highlight: Performance Comparison of Singleton, XML, and TVP Inserts
2.
Facility 9 (WWW, RSS)
Author: Jeremiah Peschka
Recent Highlight: Mirroring table changes through DDL triggers
3.
TJay Belt (WWW, RSS)
Author: TJ Belt
Recent Highlight: #PASS Board of directors candidates
4.
The Rambling DBA (WWW, RSS)
Author: JONATHAN KEHAYIAS
Recent Highlight: What am I reading? : SQL Server 2005 Practical Troubleshooting: The Database Engine (Ken Henderson)
5.
Home of the Scary DBA(WWW, RSS)
Author: Grant Fritchey
Recent Highlight: PASS Board Elections
6.
SQLBatman (WWW, RSS)
Author: Bruce Wayne aka Thomas LaRock
Recent Highlights: PASS Elections
7.
Kendal Van Dyke (WWW, RSS)
Author: Kendal Van Dyke
Recent Highlight: Delegation: What It Is And How To Set It Up
8.
SQLAGENTMAN (WWW,RSS)
Author: Tim Ford
Recent highlight: SQLSERVERPEDIA WIKI
9.
Arcane Code(WWW,RSS)
Author: Robert C. Cain
Recent Highlight: SQL Saturday Orlando Full Text Searching Session
10.
SQL Dumbass (WWW, RSS)
Author – ?
Recent Highlights: Backups and Boat Drinks
I have been to SQL Connections and TechED this year so earlier this year I pointed out to my director that they could get a really good group and early bird discount if we send five people. I graciously offered to hold down the fort while they were out. Dumb me :) The session list looks awesome! All I am hearing on twitter is PASS this, PASS that. Yall have fun, asshats! All shenanigans need to end up on YouTube.
If you want to live vicariously like me, follow along here on twitter(RSS)
I also believe Brent Ozar(RSS) and Joe Webb(RSS) will be live blogging the keynotes.
I am not an expert but I have been paying close attention to this area. This is just a primer. To me we should it break up into two areas: Real cloud computing and utility computing. However, they get lumped together because “The Cloud” is the such a buzz work right now. I think it is important to ma