SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2010

Upcoming SQL Lunch Webinars

If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL Server MVP, will be presenting an Introduction to Graphical Execution Plans. Brad has over 15 years of SQL Server Experience and over 6 years of training.

Add To Outlook: Add…

Read more

0 comments, 999 reads

Posted in SQLDownSouth on 24 February 2010

SQL Server 2008 - Adding Row Totals

During a recent client engagement I was asked if there was a quick way to add a row containing totals for each corresponding column in the details row from a Tablix item. The tablix contained about 18 columns, and the person was entering an expression that would sum the value…

Read more

0 comments, 713 reads

Posted in SQLDownSouth on 22 February 2010

Free SQL Server Webinar Series

Are you new to SQL Server?  Do you want to learn about its many features and capabilities? If so, please join me and many other SQL professionals for a series of SQL Server 101 webinars next week.  In my session, Beginning T-SQL (Monday, February 22, 2010 1:00 PM – 2:00… Read more

0 comments, 764 reads

Posted in SQLDownSouth on 20 February 2010

Reporting Services Switch Function

Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression would use the selected parameter value to dynamically set the Go to report value of an Action under the properties of a textbox. In other words, if a user chose… Read more

3 comments, 4,103 reads

Posted in SQLDownSouth on 19 February 2010

Reporting Services - Disable Loop Back Check

I have been installing and configuring SSRS since the initial release.  I have always encountered several different caveats when upgrading to a newer version or adding a new server to a scale-out deployment.  In some cases there have been consistencies, but in many these differences vary.  These variances may have… Read more

0 comments, 710 reads

Posted in SQLDownSouth on 17 February 2010

Technet and MSDN coming to Baton Rouge

On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.  These free live learning sessions will explore the latest technologies that you can apply immediately.  Join your local event team and get the inside track on new technologies for IT professionals and take a tour… Read more

0 comments, 710 reads

Posted in SQLDownSouth on 15 February 2010

Set your Warehouse Database to Read Only

In most environments new data is added to the data warehouse daily, weekly or even monthly.  Even further, these changes typically occur during the ETL process.  This means that most of the activity is read only.  As a result, you may be able to set your warehouse database to READ_ONLY. Read more

1 comments, 711 reads

Posted in SQLDownSouth on 15 February 2010