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
June 13th BAVC Virtual Chapter Meeting
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5 or 6 sessions on each track. This will be the largest SQLSaturday event I have been a part of. It will be my first time at a SQLSaturday… Read more
Thursday May 16th at noon central, we are going to be educated by MCM and past SQL Server MVP Robert Davis talking about “How to deliver a public-facing website on a global scale.” The online webcast is part of the monthly presentations by the PASS Data Architect Virtual Chapter which… Read more
I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th at Georgia State University. If you follow @SQLPass and #SQLSatAtl on twitter, you might have seen tweets about 775+ registered attendees for this event. You can still get on… Read more
Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at a Business Analytics conference. This session is hosted by the PASS Virtual Chapter for Business Analytics which was started by Mellissa.
May 2nd PASS BA VC Meeting
Some Tuesday mornings I have bacon with eggs and an English muffin. Not today though. I am blogging about Why I Love Presenting for T-SQL Tuesday #41 hosted by Bob Pusateri. I will attempt to answer all his questions.