|
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
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...
|
-
For the second year running WARDY IT Solutions has been nominated as a finalist for the ACS Queensland ICT Awards Read More...
|
-
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...
|
-
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...
|
-
[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...
|
-
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...
|
-
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 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...
|
-
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...
|
-
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...
|
-
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...
|
|
|
|