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 [...]
May
28
2009
28
2009
Goodbye Desk Phone, You Have Served Me Well
I have to admit that I try to avoid talking on the phone as much as possible, but I have a family, so I still need a phone. But now, thanks to our deployment of OCS 2007 R2, I have moved my Cisco 7960 IP Phone off of my desk for good. OCS is now [...]
Apr
16
2009
16
2009
Microsoft Exchange Server 2010 Storage
From the Microsoft Exchange Server 2010 Site
Storage
Exchange 2010 includes improvements in performance, reliability, and high availability that enable organizations to run Exchange on a wide range of storage options. Building on improvements to disk input/output (IO) that were introduced in Exchange 2007, the latest version of Exchange requires less storage performance and is more [...]
Apr
16
2009
16
2009
Microsoft Unveils Exchange 2010 With Public Beta: First in the next wave of Office-related products, Microsoft Exchange Server 2010 will help lower communications costs, improve user productivity and transform e-mail archiving.
REDMOND, Wash. — April 15, 2009 — Microsoft Corp. today released a public beta of Microsoft Exchange Server 2010, part of Microsoft’s unified communications family (http://www.microsoft.com/uc).
Exchange 2010 is part of the next wave of Microsoft Office-related products and is the first server in a new generation of Microsoft server technology built from the ground [...]
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 [...]