SQL Server

Posted by | March 9, 2007
Using the ReportViewer control in .NET 2.0?

One of the coolest controls that Visual Studio 2005 includes is the report design and view functionality of the ReportViewer controls. What used to be a server-only function, .RDL (now .RDLC) files can be...

Continue Reading
Posted by | February 21, 2007
SQL Server 2005 Add-ins for Microsoft Office 2007

Over the weekend Microsoft released some cool add-ins for Excel 2007 and Visio 2007: Table Analysis Tools for Excel - this add-in provides you with easy-to-use tasks that leverage SQL Server...

Continue Reading
Posted by | February 21, 2007
Converting Crystal Reports (.rpt) to Reporting Services reports (.rdl)

There are way too many Crystal Reports out there in the world and I would love to see more of them converted to Reporting Services. Therein lies the problem. I...

Continue Reading
Posted by | January 30, 2007
SQL Server 2005 Analysis Services Performance Guide released!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site.

Continue Reading
Posted by | January 19, 2007
SQL Server 2005 Worst Practices

Thanks for attending my talk last night and letting me share my SQL Server 2005 Worst Practices. I hope I didn't embarass anyone too badly by highlighting your practice in my...

Continue Reading
Posted by | January 17, 2007
Boise .NET User Group this Week

If you are in the Boise area, be sure to attend Thursday's meeting of the Boise .NET User Group. I'll be delivering a talk on "SQL Server 2005 Worst Practices"....

Continue Reading
Posted by | December 26, 2006
Deploy RDL files to multiple SQL Server 2005 Reporting Services servers

Updated Jan 2016: Fixed the link to the Reporting Services Scripter utility below. Last week, while teaching a SQL Server 2005 Reporting Services class, I built this simple C# Windows forms...

Continue Reading
Posted by | December 11, 2006
Updated SQL Server 2005 Samples and Sample Databases

I just noticed that there is a December update to the SQL 2005 samples. The December 2006 update is identical to the July 2006 update, except that support for Windows...

Continue Reading
Posted by | December 11, 2006
Visual Studio 2005 / SQL Server 2005 and Vista

I'm getting more and more questions regarding running Visual Studio 2005 on Vista. Here's the summary from Microsoft: "Visual Studio 2005 is supported on Windows Vista. We recommend that developers...

Continue Reading
Posted by | December 7, 2006
Nice meeting new friends in Iowa

Thank you for the good time last night at the Iowa .NET User Group meeting. I enjoyed spending the evening with these easy-going, but tech-savvy folks. We had a good...

Continue Reading