Posted by
Jason Massie 
on Thursday, July 17, 2008 at 2:37 PM to
query optimizer, SQL performance tuning, Indexes, PASS, Data collection
167 Views |
0 Comments |
Here are the slides and scripts from my June presentation at the North Texas SQL Server Users Group. The presentation was on the Data Collector in SQL Server 2008 but it was short so I also touched on filtered indexes, query hashes and troubleshooting. Enjoy and let me know if you have any questions.
Also Peter Debetta is presenting TONIGHT at 6:30 on the following topics:
"We'll be discussing the various ways you can secure your SQL Server data via encryption, including the new Transparent Data Encryption feature of SQL Server 2008."
Stop by.
Posted by
Jason Massie on Wednesday, June 18, 2008 at 2:58 PM to
SQL Server 2008, SQL performance tuning, Indexes, PASS, Data collection, RC0
162 Views |
0 Comments |
Reminder: You can catch me at the North Texas SQL Server User's Group tomorrow night. The Data Collection presentation that I put together may be short so I have a few backup slides and demo's on filtered indexes, queries hashes and the 2 second SQL Server 2008 upgrade. Directions and details can be found at http://northtexas.sqlpass.org
Hope to see you there.
Posted by
Jason Massie on Monday, June 09, 2008 at 8:35 AM to
tsql, SSRS, PASS, Data collection
139 Views |
0 Comments |
I am going to give a talk on the data collector in SQL Server 2008 at this month's meeting.
Topic:
Data Collections in SQL Server 2008
Date:
Thursday, June 19th, 2008
Overview:
Data collections are a new feature in SQL Server 2008. They allow you to collect perfmon, trace or query data to a central database. We will start off by setting up and configuring Data Collections. We will look at the default collections and historic reports in Management Studio. We will cover setting custom collections and providing a UI with SSRS.
Directions etc can be found here.
Posted by
Jason Massie on Thursday, June 05, 2008 at 8:49 PM to
SQL Server 2008, SQL Connections, PASS, TechEd
126 Views |
0 Comments |
What can I say? Another great day at TechED. My highlight was Adam Machanic's error handling session. I learned something new! I liked Andrew Kelly's trace session too but I do everything he does when analyzing traces already. Nice to know that I was on track. I have a trace session coming up in Swynk's vconference that is pretty similar + SQL 2008 updates. I worked the storage engine station for a while and helped customers. That was cool. I did sneak in to Peter DeBetta's and Michael Wang's session for a few minutes to snap a few picks.
As cool as TechED is, I must say that the SQL content is better at PASS and SQL Connections. I have done all three from both sides of the podium. I can honestly say that from a purely technical view of things, I would rank it like this: PASS, SQL Connections, TechED.
Anyway, here are today's the pics.
P.S. I can't wait to get home to the wife and kid's. Hi, honey!