Browse by Tags
All Tags »
SQL Server 2005 (RSS)
(Sample code included at the end of the post) The initiator for this post was Dan Atkins who wanted to create a feed from relational data to consume it directly from a created gadget. Where can I find that in the toolbox ? First of all, you won’t
Read More...
Someone pinged me according the article I wrote about SSIS as a data source in Reporting Services. In general this is easy to implement and configure. One problem though occurs if you already had SQL Server 2005 on the machine first and updated
Read More...
The first version (0.3.0.0) of a small project I did was published to Codeplex ( http://rsparamlogcache.codeplex.com/ ). It enables you to log and cache user parameter values for further usage and statistics. Here is short extract from the project
Read More...
My colleague Marvelous Jimmy ( JimmyMay ) and myself did a small project to parse and interpret the results of the testing tool SQLIO. It produces ready-to-interpret reports and reusable results in Excel and will save you (as of Jimmy) much time
Read More...
Ever had an error in your application and you couldn't find the source of all evil and where the error is thrown at the end ? Well, SQL Server profiler does a great job about that, but you really need to understand which events to filter for and how to
Read More...
At the beginning everyone is trying to tune the database by creating additional database files, spreading the data across file groups, adding additional log files for the database… But wait a minute, is there a performance benefit from having more than
Read More...
Ward Pond , one of the marvelous SQL geeks within Microsoft published a nice thing wich we had a discussion internally on concerning the capabilities of the IN operator: http://blogs.technet.com/wardpond/archive/2009/09/04/database-programming-did-you-know-in-can-do-this.aspx
Read More...
Simple and easy, no coding or direct access needed to the report server database, simply put the following script in a script file and exectue it via rs.exe e.g. rs.exe –S http://localhost/ReportServer –i TheScriptFileHere.rss Put the following lines
Read More...
A week ago a colleague asked for different options to do audit stored procedure calls. With his allowance I will post the question here. “The applications used at the customer site all access these databases using stored procedures ( only , as far as
Read More...
As a follow-up to my former post “ Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate ” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL
Read More...
(Sample project attached to the blog entry !) Having stated the need for getting data from SSIS packages in Reporting Service in my last post (Part 1) , we now want to concentrate how to achieve the implementation. SQL Server Integration Services
Read More...
Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you
Read More...
Coming as a simple sample with PBM (creating a policy with a condition that procedure names shouldn't´t start with SP_) and getting an interesting question in one of my classes, I wanted to revisit the question about the yet in some places existing naming
Read More...
Yesterday at the PASS conference I met an former colleague and he asked me about a particular challenge applying changes to the production database from Visual Studio Team System Database Edition. As he didn’t know about the new features of the deployment
Read More...
There are several scenarios where you want to extract data from different data sources and combine them within a report. Unfortunately if you have structure like a Table or Tablix, you can only bind the objects data source to only one dataset.
Read More...
