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

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, 454 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, 249 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, 489 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, 173 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, 567 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, 195 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, 2,518 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, 318 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, 697 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, 142 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, 796 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, 638 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,099 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,341 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

11 comments, 9,725 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, 4,417 reads

Posted in SQLDownSouth on 13 October 2011

SSRS 2008 R2: Show Column Meta-Data in ToolTip

First, I want to apologize to the three people that read my blog. Sorry for going dark for such a long period of time. I am not going to commit to writing on a regular basis just yet, but I will be back consistently soon. Enough about me, let’s talk…

Read more

1 comments, 1,439 reads

Posted in SQLDownSouth on 6 October 2011

SSRS 2008 R2: How to dynamically size your INDICATORS

The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS demonstration and I stumbled upon an additional feature that makes the indicator even more visually appealing. Using a not so obvious property of the indicator you can set its size.…

Read more

6 comments, 12,193 reads

Posted in SQLDownSouth on 25 May 2011

SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)

I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL Lunch is back.

#60-Let’s Talk about SQL Powershell


Speaker: Max Trinidad

Add To Outlook: https://www.livemeeting.com/cc/usergroups/join?id=G83CS9&role=attend
Add To Calendar

Live Meeting URL:

Date and Time: 5/24/2011 11:30:00 AM CST

BIO: Max…

Read more

0 comments, 644 reads

Posted in SQLDownSouth on 20 May 2011

WHERE HAVE YOU BEEN, patrick leblanc????

Ok, so what have I been up to?  Well a lot has changed for me over the past couple of months, primarily my job.  Initially I wasn’t going to blog about this, but after a couple of conversations with a few well respected people in the SQL community I decided… Read more

3 comments, 670 reads

Posted in SQLDownSouth on 19 May 2011

Newer posts

Older posts