10 Most Popular Posts
SQLCAT tracks at 2007 SQL PASS
Abstract from MS SQL Server Development Customer Advisory Team (Indexed 2007-09-12):
As you may already know from Brian Moran's SQL Server Magazine article "SQLCAT to Offer Six Sessions at PASS", the SQLCAT team will be providing 6 SQLCAT tracks at the 2007 SQLPASS event in Denver this year. As of today's schedule, below are the SQLCAT tracks schedule: Wednesday, September 19th 9:45am-11:00am
DBA-410-M
Designing for Petabyte using Lession Learned from Customer Experiences
Lubor Kollar, Microsoft; Kevin Cox, Microsoft
Korbel 1C/1D Wednesday, September 19th 1:30pm-2:...(truncated)...
SQL Connections 2007 (Orlando, FL) -- Follow-up
Abstract from SQL Server Manageability Team Blog (Indexed 2007-03-29):
After one heck of a trip to Orlando, FL for SQL Connections, I'm back in Redmond. Here is a quick re-cap of my sessions and links to session content......(read more)[Image]
Source code for Embedding Webcast (Finally)
Abstract from SQL Server Express WebLog (Indexed 2006-08-21):
At long last, I've posted the code for the embedding web cast. I've made a few changes to the code from what I showed in the webcast, here are some details about implementation and alternatives you can consider when thinking about this.
Alternative Databases
When I first put this webcast together, SQL Express was the primary database for creating end-user, data bound application in Visual Studio 2005. Since then, SQL Server 2005 Everywhere Edition has become available in CTP. Fo...(truncated)...
European PASS Conference 2008
Abstract from PSS SQL Server Engineers (Indexed 2008-04-10):
I'm leaving this Saturday for the Europe PASS Conference in Neuss, Germany. I have the following two sessions to present while at the conference:
1) Performance Toolset Workshop
This is day long pre-conference seminar on SQL Server Engine Performance. This session is all about the tools used by CSS to work on customer problems related to SQL Engine performance. This includes tools like Performance Dashboard Report, SQLDiag, SQLNexus, RML Utilities, and some interesting new perf to...(truncated)...
New article on SSC
Abstract from SSIS Junkie (Indexed 2007-09-20):
Just a quick blog entry here to let you know that an article of mine has today been published on SQL Server Central entitled "Experiences from a Real World Project". Go here: http://www.sqlservercentral.com/columnists/jthomson/3219.asp if you want to read it.
If the content seems familiar its probably because you have a copy of the November 2006 edition of SQL Server Standard magazine which is where this article was first published.
-Jamie
[Image]Microsoft vs Teradata
Abstract from SSIS Junkie (Indexed 2007-05-07):
There's a very good objective article on el reg today that compares the Microsoft and Teradata schools of thinking for providing BI.
Read it here: http://www.regdeveloper.co.uk/2007/05/07/microsoft_vs_teradata/
The author doesn't really make any conclusions but its useful as a high-level comparison of the two approaches. It distils the BI problem into 5 easily understandable bullet points which I won't relay here - if you're interested, go and read it.
<...(truncated)...Microsoft purchases Stratature
Abstract from SSIS Junkie (Indexed 2007-06-07):
Microsoft have purchased Stratature, a provider of Master Data Management (MDM) solutions.
Here's some extra info for you:
- Stratature visited a Conchango community day approximately a year ago and it was clear then that their solution was heavily reliant on Microsoft technologies. Their core offering, +EDM, operates on a SQL Server back-end and is built using ASP.Net.
- Microsoft have been looking to enter the MDM arena for some time and former SQL Server stalwarts...(truncated)...
Working with unambiguous dates
Abstract from SSIS Junkie (Indexed 2007-06-15):
I read with interest Matt Masson's latest blog entry "Optional date parameter". Its a useful technique and thus well worth adding to your SSIS armoury.
It did raise a wider issue though. For demo purposes Matt was using a date of "12/30/1899". Now some people, typically those in North America, would interpret that as 30th December, 1899 whereas others (including myself) would interpret it as the 12th day of a non existent 30th month in the year 1899. See the problem?
A...(truncated)...
Averages, ratios, division by zero and NON_EMPTY_BEHAVIOR
Abstract from Microsoft OLAP by Mosha Pasumansky (Indexed 2007-03-08):
How to get averages and other ratio based MDX calculations demonstrate great performance ? I thought I covered this subject in great depth before, but I probably wasn't concise enough. Last week I was asked to help with performance to very big and important customer (who shall remain unnamed). When I arrived on site, I found the project staff to be very knowledgeable about Analysis Services and MDX. Themodel was designed following all the best practices, they have studied the Performance Guid...(truncated)...
Who said the SSIS team don't listen to feedback?
Abstract from SSIS Junkie (Indexed 2007-07-06):
Over the past few years I've been fairly vocal (though usually not on this site) in criticising the SSIS team for their overall lack of feedback to SSIS items submitted through Connect - that's not an easy thing to do either given that I've gotten to know some of the team in reality rather than virtually. Well, if I'm going to be negatively critical then its only fair to give them credit where credit is due as well.
A couple of weeks ago I posted a request for new functi...(truncated)...