Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.  Oh well, on to the post.  Back in November of 2009 I published a blog titled,…

Read more

0 comments, 5,770 reads

Posted in SQLDownSouth on 27 June 2012

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.  Oh well, on to the post.  Back in November of 2009 I published a blog titled,… Read more

0 comments, 924 reads

Posted in SQLDownSouth on 27 June 2012

SQL Lunch - SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for some SQL Lunch.  Here are the details:

#64-Taking the Scary out of Monster Reports

Speaker: Pam Shaw

Add To Outlook: Add To Calendar

Date and Time: 3/22/2012 11:30:00 AM…

Read more

0 comments, 1,446 reads

Posted in SQLDownSouth on 21 March 2012

SQL Lunch–SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for some SQL Lunch.  Here are the details:

#64-Taking the Scary out of Monster Reports

Speaker: Pam Shaw

Add To Outlook: Add To Calendar

Date and Time: 3/22/2012 11:30:00 AM… Read more

0 comments, 653 reads

Posted in SQLDownSouth on 21 March 2012

SQL Lunch Rescheduled

Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled.  The event will be on March 22, 2012 at the same time.  I apologize for any inconvenience that this may have caused anyone.  Here are the details of the lunch:

#64-Taking the Scary out of…

Read more

0 comments, 505 reads

Posted in SQLDownSouth on 14 March 2012

SQL Lunch Rescheduled

Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled.  The event will be on March 22, 2012 at the same time.  I apologize for any inconvenience that this may have caused anyone.  Here are the details of the lunch:

#64-Taking the Scary out of…

Read more

0 comments, 337 reads

Posted in SQLDownSouth on 14 March 2012

Speaking at the SQL Lunch UK

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

0 comments, 556 reads

Posted in SQLDownSouth on 24 February 2012

Speaking at the SQL Lunch UK

Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change.  Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK, which is hosted by Dave Bally (@davebally), will be held at a physical location.  Well except for the… Read more

0 comments, 221 reads

Posted in SQLDownSouth on 24 February 2012

SQL Rally: Don't Vote for my Sessions

So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which is very exciting.  I had the honor of not only presenting a pre-con and one regular session at the first SQL Rally in Orlando, but since there was a… Read more

0 comments, 619 reads

Posted in SQLDownSouth on 20 February 2012

SQL Rally: Don’t Vote for My Sessions

So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which is very exciting.  I had the honor of not only presenting a pre-con and one regular session at the first SQL Rally in Orlando, but since there was a… Read more

0 comments, 266 reads

Posted in SQLDownSouth on 20 February 2012

AlwaysOn: Configuring Secondary Read-Only Access

Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary replicas.  The first step is to set the connection access for the primary and secondary role, if you haven’t already done so.  You have three choices:

  1. No:  No user…

Read more

0 comments, 3,407 reads

Posted in SQLDownSouth on 8 February 2012

AlwaysOn: Configuring Secondary Read-Only Access

Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary replicas.  The first step is to set the connection access for the primary and secondary role, if you haven’t already done so.  You have three choices:

  1. No:  No user…

Read more

0 comments, 451 reads

Posted in SQLDownSouth on 8 February 2012

Speaking for Baton Rouge UGs and SQL Lunch Next Week

I have been quiet over the past year trying to get acclimated to my new job and my new found work life balance.  Now that I have figured it all out I am slowly beginning to present on a regular basis.  Next Wednesday (2/8/2012) I have the opportunity to give a short… Read more

0 comments, 787 reads

Posted in SQLDownSouth on 2 February 2012

Speaking for Baton Rouge UGs and SQL Lunch Next Week

I have been quiet over the past year trying to get acclimated to my new job and my new found work life balance.  Now that I have figured it all out I am slowly beginning to present on a regular basis.  Next Wednesday (2/8/2012) I have the opportunity to give… Read more

0 comments, 193 reads

Posted in SQLDownSouth on 2 February 2012

PowerView: Coordinating Chart Colors

During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line Graph for a particular value would be the same color for the same value on a Bar Chart.  I thought, GOOD QUESTION.  I launched PowerView and started creating a report. …

Read more

0 comments, 1,041 reads

Posted in SQLDownSouth on 10 January 2012

Speaking at Knoxville SQL Server User Group

I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group.  While I have been giving several internal presentations at Microsoft, I have not been speaking in the community on a regular basis.  I look to change that this year.  There… Read more

0 comments, 741 reads

Posted in SQLDownSouth on 4 January 2012

Free Business Intelligence Workshop

If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop.  The details are below:

Unlock your Data with the Microsoft Business Intelligence Platform

Event Details:
November 8, 2011

Registration at 8:00am
 
Microsoft Office, Las Colinas
LC1
7000 N. State Highway 161
Irving,…

Read more

2 comments, 1,302 reads

Posted in SQLDownSouth on 1 November 2011

SSIS 2012: Project Reference

One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task.  Open the Execute Package Task Editor and select Package from the left window.  Select Project Reference for the ReferenceType property.

Now you can reference any package…

Read more

1 comments, 1,800 reads

Posted in SQLDownSouth on 24 October 2011

SQL Server 2012 SSIS – Why is my toolbox empty?

So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed to open my toolbox, of course I went to the menu bar selected View > Toolbox. To my surprise the toolbox was completely empty.

What the #$%#? What to do?…

Read more

16 comments, 14,769 reads

Posted in SQLDownSouth on 13 October 2011

SSRS 2008 R2: Implementing Row-level Security

When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there are a couple of solutions that can be used to quickly and easily resolve the problem. First, you could follow the steps in this whitepaper, Implementing Row and Cell Level…

Read more

1 comments, 5,772 reads

Posted in SQLDownSouth on 13 October 2011

Newer posts

Older posts