|
|
August 2006 - Posts
-
Found this the other day when just browsing around : Welcome to the Microsoft® ASP.NET 2.0 Webcast Series, sponsored by Microsoft, Dr. Dobb's, and O'Reilly. Choose from 45 webcasts organized by track—JSP, PHP, and ColdFusion. Each track has been designed Read More...
|
-
Since SQL Server 2005 came out I've been limited in my developmental space, since my home PC blows which leaves my laptop for development time and a boat anchor gathering dust on my desk. I've tried to run SQL2K5 on it but the Management Studio itself Read More...
|
-
I never bothered to try adding custom functions in SSRS before last week... and I can't believe how easy Microsoft made this. As an example, one of the most common calculations I write in reports tends to be division and with division you always need Read More...
|
-
So there's this story: Some time ago, Wal-Mart decided to combine the data from its loyalty card system with that from its point of sale systems. The former provided Wal-Mart with demographic data about its customers, the latter told it where, when and Read More...
|
-
Feeling all Firefox competent with the last posting on SSRS formatting with Firefox ... I went on to test some more reports in Firefox. And things were all fine and dandy except for that one report... you know, the one where you end up ditching a table Read More...
|
-
Interesting project by Jon Axon, Chris Webb , Mosha Pasumansky , Greg Galloway, Darren Gosbell, and Christine Wade . To provide the following is AS: To provide a set of useful extensions to Analysis Services 2005. To provide a variety of example source Read More...
|
-
One of the issues I've had time and again with Firefox and SQL Server Reporting Services is the disconnect between the table control in SSRS and width settings in Firefox. If you've run into this before you'll know that Firefox pretty much ignore the Read More...
|
-
I setup SQL Server Notification Services (SSNS) at a client a few months back and there were the typical hangups that occur when implementing new technology and wondering... "does this really work?" Eight hours of reading and some manipulation of one Read More...
|
-
Microsoft has opted to limit support on Microsoft Vista and Microsoft Windows Server "Longhorn" to SQL Server 2005 SP1 and later. Nice line in the sand on support and while I kind of a agree in principle... this will be a fun one to explain to people Read More...
|
-
A good article by Pam Abdulla , key points she brought up were: Agree on a coding style for your workplace, document it, publish it and use it. Note dependencies, what the code effects and the expected results. Use white space. Establish naming conventions. Read More...
|
-
I was installing SQL Server Service Pack 1 today and ran into a error message during the install. The error message I saw was: ————————— Pending Reboot Files Found ————————— A previous program installation caused unrelated pending file operations. The Read More...
|
-
The SQL team at Microsoft updated SQL Server 2005 BOL in July, so if you haven't heard or gotten around to it... make sure you download it . While I was there downloading this though I came across a link to download the SQL Server 2005 Systems View map Read More...
|
-
SQL Server Central had an article on migrating data warehouse systems to SQL Server 2005 the other day. Its a pretty decent read and covers a lot of the basics and some of the little things that can come up when migrating. A worthwhile read before migrating Read More...
|
-
Exporting from SSRS to EXCEL is not as seamless as one would hope. I've run into a few issues that have been spicing up my life. The EXCEL renderer has a footer limitation of 255 characters. So any nifty footer on the report with instructions and such Read More...
|
-
For the longest time I've been looking at the filtering options within Reporting Services with disgust. The general rule is you only bring back the data that is needed for a report to the report, so there should never be any reason to apply filtering Read More...
|
-
A very good article by Jeff Smith over at SQL Team on Using Parameters when using dynamic SQL from .NET applications. While I am in the always use stored procedures camp, not sure if I am a resident preacher there but I am at least in the choir, the article Read More...
|
-
I've been using SQL Prompt 2 for a while now and really like having intellisense added into Management Studio. I'll definately be taking advantage of this offer from Red-Gate... Red Gate Software will be offering an introductory price of $99 per license Read More...
|
-
Long time no post... I've been busy exploring the wonderful world of SQL Server 2005 Reporting Services and all of the "undocumented features" of the ReportViewer control. Or in a less kind approach, I've been dealing with the how ReprotViewer is thoroughly Read More...
|
|
|
|