Presentations at SQL Saturday #35.
Location: Dallas, TX
Twitter: none
Website: http://www.sqlsaturday.com/
Twitter: none
Website: http://www.sqlsaturday.com/
-
SQL Server Service Broker
- Griffin , Janis (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: Services Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. this presentation will explain how to use the Service Broker services and discuss best practices. A case study will review an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs.
Video Topics:
-
Power Pivot for Excel
- Liu, Lisa (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: Microsoft PowerPivot for Excel 2010, is a data analysis add-in that delivers unmatched computational power directly within Microsoft Excel 2010. In the presentation Lisa will provide an overview of the functionality provided by the PowerPivot tool.
Video Topics:- PowerPivot (1)
-
Bad SQL
- Hiten, Geoff (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: Learn to write (or at least recognize) T-SQL code that consumes hundreds of times more I/O and CPU Resources than optimal code. More importantly, see what the optimal counterpart looks like.
Video Topics:- SQL (3)
-
SQL server 2008 R2: Multi-Instance Management
- Mehra, Prem (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: In this session we will give an overview and demo of the multi-instance manageability tools and techniques available for you with SQL Server 2008 R2. The team will present the Utility Control Point. You will also learn about the Data-Tier Application Component, which can play a role when you are consolidating at the database level.
Video Topics:- SQL (3)
-
Relational Division & Relatives
- Celko, Joe (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: Relational divison was one of Dr. Codd's original 8 operators and it is very useful. There is Codd's Division, Todd's Division, exact division. These are easy to write with Standard SQL-92. But now we have sequenced clusters whcih are st done with the new ordinal functions.
Video Topics:- SQL (3)
-
Team System 2008 DB Functionality and Projects
- Ferrier, Kristin (1)
User Group/Event: SQL Saturday #35 (6)
Recorded On: 5/22/2010
Abstract: With VSTS 2008 Database Edition or Suite, one has access to automated data generation, schema comparison, data comparison, and unit testing options. This is a surprise to many people, as VSTS and SQL Server have often just brought to mind source control. We'll cover the aformentioned features and review database projects.
Video Topics:- VS DB (3)