|
|||||
|
|||||
|
Get Your Own BlogIf you would like to blog on SQLServerCentral.com then send an email to webmaster@sqlservercentral.com. All BlogsFeedsArchives for this blog
AlwaysOn: Configuring Secondary Read-Only AccessNow 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:
0 comments, 286 reads Posted in SQLDownSouth on 8 February 2012 Speaking for Baton Rouge UGs and SQL Lunch Next WeekI 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, 222 reads Posted in SQLDownSouth on 2 February 2012 PowerView: Coordinating Chart ColorsDuring 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. … 0 comments, 126 reads Posted in SQLDownSouth on 10 January 2012 Speaking at Knoxville SQL Server User GroupI 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, 124 reads Posted in SQLDownSouth on 4 January 2012 Free Business Intelligence WorkshopIf you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are below:
2 comments, 184 reads Posted in SQLDownSouth on 1 November 2011 SSIS 2012: Project ReferenceOne 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… 1 comments, 148 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?… 1 comments, 232 reads Posted in SQLDownSouth on 13 October 2011 SSRS 2008 R2: Implementing Row-level SecurityWhen 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… 0 comments, 282 reads Posted in SQLDownSouth on 13 October 2011 SSRS 2008 R2: Show Column Meta-Data in ToolTipFirst, 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… 1 comments, 191 reads Posted in SQLDownSouth on 6 October 2011 SSRS 2008 R2: How to dynamically size your INDICATORSThe 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.… 6 comments, 261 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 Live Meeting URL: Date and Time: 5/24/2011 11:30:00 AM CST 0 comments, 133 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, 95 reads Posted in SQLDownSouth on 19 May 2011 Report Builder: Change Report Server ConnectionA question that I have been asked quite often is, “How can I change the Report Server that I am connected to in Report Builder?” I never really thought about it until then. To change the connection click the Disconnect link located at the bottom of the Report Builder Designer:… 0 comments, 267 reads Posted in SQLDownSouth on 19 May 2011 SQL Lunch #51–SQL U Presents Women in TechnologyThis week I am happy to announce the second SQL University SQL Lunch presentation. What’s makes this exciting is that the speakers are a group of some of the most respected and talented SQL Server women professionals in our community. If you have time on Friday join the meeting.PLEASE… 0 comments, 127 reads Posted in SQLDownSouth on 17 March 2011 SSRS: Shared DataSet, Not So Shared!!!I was really excited about the concept of Shared DataSets when they were introduced. My excitement diminished a little when I ran into a small issue. When you create an embedded data set based on a SSAS Cube that includes a parameter, a hidden dataset is automatically created that provides… 5 comments, 274 reads Posted in SQLDownSouth on 14 March 2011 SSRS: My Filter is not Working!!!I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the filter to our surprise it did not work. The actual problem involved using a table that contained a column that was of a CHAR data type. After a little digging… 1 comments, 199 reads Posted in SQLDownSouth on 7 March 2011 SQL Lunch #50 - Solitary Containment (An Overview of SSIS Containers)Join us tomorrow on the SQL Lunch for a little SSIS.Topic: #50-Solitary Containment - An Overview of SSIS Containers 1 comments, 106 reads Posted in SQLDownSouth on 2 March 2011 I travel, I work, I EATAs most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During my travels I encounter new people, new places and what I realized recently new food. I am not going to say this is some type of new blog series… 0 comments, 104 reads Posted in SQLDownSouth on 12 February 2011 Presentations: Slides and DemosOver the past couple of weeks I have given several presentations. At each presentation I have promised to post the slides and demos for each. Well finally here they are. I want to apologize for the long delay. SQL Lunch 47 – Introduction to Change Data Capture (watch video Read more 0 comments, 74 reads Posted in SQLDownSouth on 9 February 2011 Speaking at the Houston SQL Server Users GroupSince I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users Group) to let me speak at her monthly Users Group meeting. Fortunately, she did not have anyone lined up, therefore she graciously agreed. If you are in the Houston… Read more 2 comments, 72 reads Posted in SQLDownSouth on 7 February 2011 |
Subscribe to this blog
