桃子视频

Category: PASS

Categories
PASS Presentation SQL Server Syndicated Syndication user group

Policy Based Management with SQL 2008

A few weeks back I presented at the Tampa SSUG meeting on Policy Based Management with SQL 2008. Unfortunately due to sickness and apparently my own laziness, I never got around to doing a follow-up post or posting my slide deck. First the slide deck:

As a warning the deck itself is a bit sparse with how-to info as the meat of my presentation is in demo format. Given that fact, I will start a series of blog posts covering Policy Based Management and how/what you can do with it. Keep an eye out in the coming weeks for those! In the meantime a big thank you for everyone that attended the Tampa presentation, hopefully I鈥檒l be giving this same presentation again at in August.

Categories
PASS Presentation Syndicated Syndication user group

Tampa SQL Server User Group Meeting 6/16: I鈥檓 Presenting!

Just wanted to post that tomorrow night I鈥檒l be presenting on Policy Based Management in SQL 2008 at the Tampa SQL Server User Group meeting. The details of the meeting are below, hope to see you there!

Date:
6/16/2009

Topic:
Policy Based Management

Speakers:
Jorge Segarra


Location:
Franklin Templeton Buidling ( )


Description:

Jorge Segarra will be presenting Policy Based Management. We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Servers!

Jorge has been a SQL DBA for over 5 years with experience with SQL 2000, 2005 and 2008. Some of his other specialties include virtualization, specifically on the VMware platform. He is currently the Database Administrator for University Community Hospital () in Tampa. Check out his blog at: .

Food and drinks will be provided by Jane Powell of . CIBER is a pure-play international system integration consultancy and outsourcing company with superior value-priced services and reliable delivery for both private and government sector clients. CIBER鈥檚 services are offered globally on an outsourced, project, or staffing basis, in both custom and ERP package environments, and across all technology platforms, operating systems and infrastructures.

As usual, SWAG from the group鈥檚 stash will be raffled. SWAG will include Office 2007, books and other items.

Categories
PASS Review Syndicated Syndication user group

Tampa SQL BI User Group 鈥� Designing Slowly Changing Dimensions

So Monday night was the monthly SQL BI user group meeting. Attending these meetings is always interesting for me since I鈥檓 not a BI-guy (leave out the gutter jokes please鈥�) so I definitely learn something new. I also leave with a raging headache since I have trouble wrapping my head around some of this crazy stuff. I tip my hat off to you guys that specialize on the BI side of SQL Server. I鈥檝e come to realize that its kind of like Texas Hold 鈥楨m poker vs Omaha. When it comes to SQL we鈥檙e all playing the same game with very different rules. Anyhow, I digress, back to the recap.

We started off with a general 鈥渨hat鈥檚 going on鈥� discussion in the world of tech/SQL/etc. We talked about some of the big stuff that happened that day such as Microsoft鈥檚 during their E3 presentation, the public launch of Microsoft鈥檚 new search engine: , the current state of job market (looking better, contact as he has quite a few SQL jobs available), (expires at the end of this month), next month鈥檚 meeting (I鈥檒l be presenting on Policy Based Management), and the announcements regarding and 鈥淕emini鈥�, which turned out to be a very hot topic for the night! For the record our group is looking for more info and demos on Gemini so if you鈥檙e available for a talk and want to visit sunny Tampa drop Rob Hatton a line!

Speaking of Rob, he was our featured presenter this month on the topic of Designing Slowly Changing Dimensions. The discussion was based around the Kimball Methodology which if you鈥檙e not familiar with then you are highly encouraged to go grab a copy of . On the whole I found the presentation really good but after awhile some of the concepts start flying over my head.Some things I did walk with is that when you鈥檙e doing a data warehouse project some things you need to realize is that 80% of your effort will go towards the ETL, 5-10% to the cube and the remaining to the relational stuff. Another little tidbit I picked up is that apparently 3/4 of the source data that the BI pros in the room have dealt with to load into the staging portion of the DW are CSV/txt files which surprised me. Then again I鈥檓 a DBA so I believe everything should live in nice relational databases! I don鈥檛 mean to skimp on the details of the presentation mostly because I wouldn鈥檛 do it justice and I鈥檇 probably be wrong about the details. Rob鈥檚 slide deck should be available on the user group鈥檚 website soon and when it is I鈥檒l link it here.

As an added bonus, and due to our lengthy discussion and excitement about SQL 2008 R2 and 鈥淧roject Gemini鈥�, from Microsoft, managed to show us a quick 6 minute video clip from 鈥檚 presentation on Gemini. Unfortunately it was without audio so we couldn鈥檛 get detailed explanations of the features. If you鈥檙e curious about Gemini check out that has everything you need to know.

Categories
PASS SQL Server Syndicated Syndication user group

Tampa Bay SQL Server BI User Group Meeting Tonight!

Just an FYI tonight is the monthly meeting. Tonight鈥檚 presentation will be by our fearless leader Rob Hatton on Creating Slowly Changing Dimensions.

The meeting will begin at 6:30 PM in the new Microsoft Office at:

5426 Bay Center Drive
Suite 700
Tampa, FL 33609

Our sponsor this month is Steve Turner () of .

T2 Software Services offers a wide range of people services to its Clients through:

路Consulting Services 鈥� IT Supplemental Staffing (Staff Augmentation)

路Project Outsourcing 鈥� With full Project Management & Responsibility

路Placement Services 鈥� Direct Placement (Contingency Search)

As per my new modus operandi, I will give a follow up post on the meeting in the next couple of days. See you there!

Categories
PASS Review SIG SQL Server Syndicated Syndication

PASS DBA SIG: Understanding the Default Trace

Today during lunch was the monthly PASS webcast for the Database Administration SIG. This month鈥檚 topic was understanding the default trace and was presented by Jonathan Kehayias ( ). Jonathan did a great job as he very clearly explained the nuances of the default trace (i.e. what it really is, how you query it, what鈥檚 it do, etc.).

The presentation files are . If you get a chance definitely check out the on-demand replay which should be available next week. On a side note this is my second or third one of these I鈥檝e attended and I absolutely love it! I think is doing a great job providing this sort of on-going training for the community and I also tip my hat to people like Jonathan who are willing to take time out of their day to present.