SQL Server Aggregator

Collaboration Nation Call to Action! Calling All SQL Server Bloggers and Twitterers

Tool Time — Sat, 13 Mar 2010 01:18:00 GMT

Help build a brand new shiny centralized reference with a full compendium to everyone's blog & twitter hyperlinks who are active in the SQL Server space Read More......(read more)

ClearTrace Supports Statement Level Events

Thoughts on SQL Server — Fri, 12 Mar 2010 13:26:42 GMT

One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta has this feature available. If you’re interested in this I’d like to get some feedback. I handle the SP:StmtCompleted and the SQL:StmtCompleted...(read more)

There once was in Dublin a query

Paul Nielsen — Thu, 11 Mar 2010 17:00:00 GMT

For 6 months I’ve have been planning a secret trip to London in May as a surprise for my wife (of Irish heritage and accent) (I love how she says, "Aye laddie, kiss me I'm Irish." but that's for another blog.) The plan was to spend a week in London and...(...(read more)

The ethics of aggregating other peoples' content

Aaron Bertrand — Wed, 10 Mar 2010 22:20:00 GMT

Content theft Most of the recent - what I'll call - "discussions" about content aggregators have revolved around content theft. I'm not going to flip-flop on that topic: when you use someone else's work, you ask first, and if given the okay, you cite...(...(read more)

Bad habits to kick : ignoring I/O

Aaron Bertrand — Tue, 09 Mar 2010 01:14:00 GMT

In my last post in this series , I talked about problems associated with creating (and using) what I call the "uber-view." This time, in line with tomorrow's T-SQL Tuesday hosted by Mike Walsh , I wanted to talk about some I/O issues that tend to get...(...(read more)

Queensland ICT Awards

WARDY IT Solutions Blog — Tue, 09 Mar 2010 01:11:38 GMT

For the second year running WARDY IT Solutions has been nominated as a finalist for the ACS Queensland ICT Awards Read More......(read more)

T-SQL Tuesday - Query Cost

Rob Farley — Tue, 09 Mar 2010 00:03:00 GMT

In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday , hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally...(read more)

Bad habits to kick : creating the uber-view

Aaron Bertrand — Sun, 07 Mar 2010 22:52:00 GMT

In my last post in this series , I talked about using ancient copies of Books Online, and why it can be important to keep your local documentation current. This time I wanted to touch on massive and wasteful views that are re-used a little too much. The...(...(read more)

SQL Saturday #33 : slide deck, recap and shout-outs

Aaron Bertrand — Sun, 07 Mar 2010 02:14:00 GMT

[Sorry I have been a little absent over the past couple of weeks. Returning from the Olympics just a little over a week ago meant some busy catch-up and a heavy lead-in to today's event.] Today I spoke at SQL Saturday #33 in Charlotte, NC. My presentation...(...(read more)

Twitter will migrate from MySQL to Cassandra DB

Paul Nielsen — Fri, 05 Mar 2010 22:48:00 GMT

Since most of us are active on Twitter, I figured this would be of interest: http://www.dataprix.com/en/blogs/carlos/twitter-will-migrate-mysql-cassandra-db Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...( read...(read more)

Enabling Partition Level Locking in SQL Server 2008

Microsoft SQL Server Development Customer Advisory Team — Wed, 03 Mar 2010 23:54:00 GMT

Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate...(read more)

SQL Server 2008 R2 UNICODE Compression – what happens in the background?

Microsoft SQL Server Development Customer Advisory Team — Wed, 03 Mar 2010 00:06:00 GMT

SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to compress Unicode strings. It is implemented as part of ROW compression, which was added in SQL 2008. That is; if ROW compression (on SQL 2008 R2) is enabled...(read more)

Extensive library of Excel functions for SQL Server

Paul Nielsen — Tue, 02 Mar 2010 23:27:00 GMT

When SQL Server 2000 introduced user-defined functions I predicted that a few companies would release sets of cool financial/mathematical/statistical functions. It didn’t happen. When SQL Server 2005 introduced the CLR, I again predicted that a few companies...(...(read more)

Performance tips of using XML data in SQL Server

Microsoft SQL Server Development Customer Advisory Team — Mon, 01 Mar 2010 23:52:00 GMT

Author: Kun Cheng Reviewers: Peter Carlin, Mike Ruthruff, Thomas Kejser, Nicholas Dritsas XML data type is usually used to store semi-structured data with great flexibility and query capabilities. It’s a good choice for developing platform agnostic applications...(read more)

SQL Saturday - March 6 in Charlotte

Rick Heiges — Mon, 01 Mar 2010 15:09:00 GMT

I've been working on my presentation for SQL Saturday in Charlotte - http://www.sqlsaturday.com/33/eventhome.aspx . I will be presenting a session on using the basics of Perfmon to monitor your environment. There is a great line-up of speakers. If you...(...(read more)