SelectViews Show Available Now
Kalen Delaney on the show today talking about her work with SQL Server, upcoming workshops and other thoughts. Also on the show, SQL Server 2008 R2, Mary Leigh Mackey from AvePoint and much more.
[Watch the Show]
Featured Script
GetTbColValues
Find table column names… (read more)
SSIS Class – Online, 12 Hours/classes
Eric Johnson’s class starts May 15 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. There is SO MUCH information packed into this course, it’s unbelievable. Take a look at the class sessions here.
If you’re working with SSIS, or considering it, you can’t go wrong.
[Find out more] here at the class site.
Call for Speakers/Presentations
Interested in speaking/presenting at the SSWUG.ORG Fall Virtual Conference? This is your chance! Just let us know what you’d like to present on – we’re actively taking session abstracts and ideas and would LOVE to hear from you! We make it painless to present, and you get to present on topics that are your passion, things you wished YOU had known. What have you learned in the field? What best practices have you discovered? What challenges and workarounds are you working with? We’d love to hear from you! Click here to submit your session idea(s) and proposals. It won’t take long and it’s a lot of fun to do. I look forward to hearing your thoughts!
[Enter your session proposals here] – SQL Server, Business Intelligence, SharePoint and .NET sessions are all key to this event.
Drop me a note if you have questions about the process or presenting – swynk@sswug.org
Making the Most of Your Data – Your Experiences?
I’ve been increasingly talking with people that are facing the challenging split personality of an online transaction processing system (OLTP) with reporting and data warehousing requirements. The challenge comes from the realization that the two database environments can be (and often are) very different. Changes include normalization changes (egad – sin of sins) and optimization issues like indexing.
With an OLTP system, normalization is pretty critical. While there are surely cases where you denormalize in that type of environment, generally speaking you’ll want to have pretty standard third normal form. Great. BUT, in a data warehouse environment, in many cases it can make sense to denormalize and summarize information in support of specific reporting requirements. What’s more, with optimization, you often will index differently for ACD (add, change, delete) environments when compared with a data warehouse (typically read-type operation) environment.
All of this is leading up to a question. What have your experiences been? Have you split apart your databases and had some success (or challenges) in architecting solutions for the split purposes?
I’d really like to hear about your experiences. Please click here to send me an email, let me know.