One of the first questions I got while interviewing for a potential position as a DBA was “If there is performance problem, where is the first place you would look?”
Now at this time, I was trying to move from Software Developer to DBA, and I answered that I would… Read more
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans and Multidimensional Analysis Services. These are 2 topics I deal with on a daily basis, so it is great I get to help others understand these technologies.
I also get… Read more
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not work on Monday. First, I would like to say that Hadoop is not going to replace SQL Server nor Business Intelligence. Second, a new thing is coming but it is… Read more
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick LeBlanc back in 2009 with #17 http://sqlsaturday.com/17/eventhome.aspx and with help from local User Groups (William Assaf – Sparkhound), it has expanded its topics and attendees. This event is… Read more
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day for spot check views of a system. The order here is not a countdown from 5 to 1. They are presented here in no particular order, because each has its…
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:
- No Duplicate data in columns in one table
- Relationships built as…
Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and Tricks presented in 5 minute lectures.
Thu, Jan 30 2014 12:00 (GMT-06:00) Central Time (US & Canada)
This is a SQL presentation for the YouTube…
Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in Analysis Services 2012. This is a presentation I have shown at 2 SQLSaturdays and the Baton Rouge SQL Server User Group as well as 24 Hours of PASS.
Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the BRSSUG Website: http://www.brssug.org/
Topic: Microsoft Azure!
This is an all user groups on deck meeting! SQL, .net, SharePoint, IT Pro, La-WIT…
Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips and Tricks for developers and DBAs.
Thu, Dec 19 2013 12:00 (GMT-06:00) Central Time (US & Canada)
Nigel Sammy - T-SQL: Tips and Tricks
Queries are running longer…
Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look at Steve’s experience while implementing a financial data warehouse.
Thu, Nov 14 2013 12:00 (GMT-06:00) Central Time (US & Canada)
Challenges to designing financial warehouses
The week is over and I waiting for my flight home. I did not to get to as many sessions as past summits, but that was replaced with speaking opportunities consisting of 1 half-day session, a 75 minute regular session and speaking at the Charlotte BI SQLSaturday.
Tuesday was a… Read more
Well, it is here folks. The PASS Summit 2013. If you have never been to a PASS Summit, please look in to attending one year. There is more SQL Server Learning than you could fit in a month. You just need to break it down into digestible chunks.
Monday… Read more
I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at the Reliant Center. The session in the first of the morning in the database track. SSIS 2012 has lots of new features, but this presentation focuses Change Data Capture component,… Read more
Please join us Thursday Sept 12th at noon Central for the monthly Data Architecture Virtual Chapter presentation. We will have SQL Server MVP talking about relational databases. Please don’t miss this session which is a preview to the Pre-Conference session Louis will be doing at the PASS Summit 2013 in… Read more
This will be the fifth SQLSaturday and Tech Day in Baton Rouge, LA on Saturday August 3rd, 2013.
I found a collection of SQLSaturday, SQLRally and PASS Summit shirts with various stickers collected over the last 5 or 6 years.
It is going to be hot this weekend in Baton… Read more
For 24 Hours of PASS 2013 Summit preview (#24HOP – twitter hash tag), I was asked to give a preview of the 1/2 day session on Slicing and Dicing in Analysis Serves 2012 for the upcoming PASS Summit 2013. My response: No Problem.
In Denver, it was the year… Read more
Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing a financial data warehouse in the real world. Come chat with a SQL Server MCP and seasoned data warehouse architect to reflect on his many years experience in this industry. Read more
Please join the Business Analytics Virtual Chapter as Mark Tabladillo talks about Best Practices for building a Framework for Data Mining. The GoToMeeting link for Noon Atlantic on June 13th is https://attendee.gotowebinar.com/register/7717448277059007488