Great article. I have tried to solve several of these problems before with no success.
In every business there are several different groups of report users, from chief executives, to business analysts, to operational staff, who all need access to reliable and current data in order to track overall business performance, investigate the effectiveness of [...]
Oct
22
2009
22
2009
Ten Common SQL Server Reporting Services Challenges and Solutions
Sep
29
2009
29
2009
How to Use Computed Column in SQL Server Databases with Computed-Column Samples
Very detailed description of computed columns in SQL Server, with plenty of examples.
How to Use Computed Column SQL Server Databases
What is Computed Column ?
If you have columns in your sql database tables such that their values depend on other columns, you may use computed columns. Using computed columns or calculated [...]
Sep
14
2009
14
2009
Katmai (Sql 2008) – MERGE – More than UPSERT (more advanced uses) – Chad Boyd
So, more than likely almost everyone has already heard that Sql 2008 will introduce a MERGE syntax, making it much easier to deal with scenarios where you need to perform ‘upsert’ type logic (i.e., you have a source data set and you want to put records from that source set into a target set (table, [...]
Sep
9
2009
9
2009
SMS/ConfigMgr – SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time – Number2 Blog – myITforum
This is a great post. I had looked at trying to find a way to convert Integer-8 values to datetime format using SQL functions before, but could never figure it out. Here it is, the entire post in case it ever disappears from its original site.
It’s possible you’re pulling a value from Active Directory [...]
Apr
14
2009
14
2009
Todd McDermid’s Blog: An Alternative to SSIS’s SCD Wizard
An Alternative to SSIS’s SCD Wizard
This will be the last time I plug this for a while – I promise! I just wanted to make sure this page would come up in Google for those who are struggling with the Slowly Changing Dimension Wizard in SSIS. If you want an SCD [...]
Mar
13
2009
13
2009
New White Paper on Hyper-V and SQL Server Consolidation at Microsoft
Very timely. We were just having this discussion the other day.
New White Paper on Hyper-V and SQL Server Consolidation at Microsoft
A new white paper on how Microsoft IT is combining Hyper-V and SQL Server has just been published. This comes from a team that provides thousands of SQL Server instances for internal applications. [...]
Aug
10
2008
10
2008
Beginning SQL Server 2005 Reporting Services Part 2
A good primer I ran across about SQL Server 2005 Reporting Services.
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more [...]
Oct
19
2007
19
2007
Accessing SharePoint List Items with SQL Server 2005 Reporting Services – Colin Bowern – RockstarGuys.com
 Found this post on Printing Sharepoint List items with SQL 2005 Reporting services:
Recently I had to connect to a SharePoint List to access some data. While there
is a data extension
available from Enesys (including a free Community edition) to do this I though
I would first make an attempt using the out-of-the-box options.
The first step was getting [...]
Sep
28
2007
28
2007
SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier — MSDN Magazine, February 2007
This article discusses:
Efficient SQL querying using regular expressions
Support in SQL Server 2005 for regular expressions
Using .NET Regex classes from SQL Server
Effective uses for regular expressions in a database
SQL
Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier
– MSDN Magazine, February 2007
Jun
25
2007
25
2007
Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007
There are numerous benefits and advantages to integrating Reporting Services with
Office SharePoint Server 2007. Prior to SP2, Reporting Services reports were published
to a report server and were executed solely in that environment. The integration point
between Reporting Services and SharePoint was two separate Web Parts: Report Explorer
and Report Viewer.
Using
Reporting Services 2005 in SharePoint Integration Mode enables [...]