Browse by Tags
All Tags »
SQL Server (
RSS)
Since Team Foundation Server (TFS) uses SQL Server Analysis Services (SSAS) as its repository for all kinds of info, people are interested to expose the data through Excel or SQL Server Reporting Services (SSRS). SSAS doesn't expose itself through...
A couple of weeks ago I posted a post about creating a couple of data generators for DataDude . In mine first data generator I used aggregation extensibility. Microsoft divided each form of extensibility in another section. Since I created one or more...
On June 11 and 12, I attended a 2-day Visual Studio Team Edition for Database Professionals workshop at Class-A . This event was hosted by Gert Drapers (also aka DataDude), see his blog post announcing the event. Gert discussed all the important features...
Microsoft is planning to release the next version of its SQL Server database, which is codenamed "Katmai," in 2008 . Everybody is waiting anxiously what this version will bring us. Like everybody I've a personal wish list for SSRS and it seems MS is working...
How often do you bump into problems with users and security when you move a SQL Server database to another server. The most annoying problem is when you try to create a user under Security, and the user exists within the moved database. When you try to...
On a recent assignment they requested me to implement two Integration Services instances on the same machine. Their serverpark isn't that big, but they want to simulate a separated test en development environment. With DTS this wasn't a real problem,...
If you want to shrink the size of the transaction log, which you think has become much larger than you would like, there are a two options. Detach and Attach First I will explain a trick for quickly remove the log file by detaching and automatically recreate...
Since the release of Reporting Services 2000 back in January of 2004, I've build lots of apps using this technology. On my newest assignment they requested me to implement two Reporting Services instances on the same machine. Their serverpark isn't that...
This is the first blog of a series about discussing the improvements of installing SQL Server SP2 . If you've applied Service Pack 2 CTP2 to your SQL Server 2005 Reporting Services installation, you might have noticed the appearance again of "Select All...
Update: I updated this article, because MS is shipping the December 2006 preview now. Microsoft released the SQL Server 2005 Service Pack 2 Community Technology Preview December 2006 . CTP December 2006 will be a public release and the goal of this outreach...
The Microsoft Data Dude Team is proud to announce that CTP7 (2.0.50727.222) is already here. I was only able to use CTP6 for two weeks since Microsoft released it and they already updated their product again. CTP7 of Visual Studio Team Edition for Database...
Every two weeks we have a knowledge session at Class-A about one or more technical subjects. Last Monday I had to give a presentation about Reporting Services and talked about calculations, parameters, embedded code and custom assemblies in Reports. We...
Yesterday I was rewriting my two-day Reporting Services 2005 course to a three-day course. The previous times I gave this course I ran out of time and couldn’t explain every module in depth. So I decided to extend the course and add an extra module about...