Joe Celko speak their mind on .NET in the database
Tag: SQL Server
As you can imagine, the debate has been lively, as to whether hosting CLR sprocs, triggers, etc. in a SQL Server 2005 should be a best practice for an organization. You all know my feeling on the …
Read more →SQL Server 2005 Questions from the Tour
From various student questions over the last few weeks. More to come ...
Q. I had heard that SQL 2005 was going to have an UPSERT (try UPDATE, if it fails, do an INSERT) capability. What's the status? …
Read more →Some good April Fools Jokes yesterday
In addition to the Google Gulp (a few posts down). There was also a good ThinkGeek joke as well as a SQL Server 2005 joke pulled on us poor technical folk yesterday.
Here's a list of the Top 100 April …
Read more →What is the Office Business Scorecards Accelerator?
This has come up at a couple of my SQL Server 2005 BI events, so let me summarize:
“The Microsoft Office Business Scorecards Accelerator is a Web-based solution that enables employees at all …
Read more →Where to download the Office Excel Add-in for SQL Server Analysis Services
For those of you attending my seminars, I've been showing a cool add-in for Excel, which allows you to access and analyze multidimensional data and create interactive structured and free-form reports …
Read more →"BroadCatching" - using RSS + BitTorrent to automatically download content
On the topic of RSS, one of my ISV attendees at the Houston SQL Server 2005 event pointed out this article to me, which explains how you can use RSS and BitTorrent to find and download content, using …
Read more →Check out the site created by the actual datamining team. It contains many resources, including the MoviePick example site, and even an area for SQL 2000 datamining.
Read more →Wanted to blog about a recent student of mine, Roy Ogborn, who showed up to my SQL Server 2005 ISV presentation wearing this shirt. I guess there's a story to it.
Read more →Links from Raleigh's SQL BI Presentation
Thanks to all of you of you who attended today's presentation in Raleigh.
Integrating Analysis Services with Reporting Services Using the Excel Add-in for SQL Server Analysis Services
Read more →
