SQL Session – Execution Extract, Transform, and Load your Data Warehouse
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.
One data warehouse buzzword that often gets used is "ETL", also known as extract, transform, and load. But what does this really mean from a data warehousing perspective and how do we use SQL Server Integration Services to perform these ETL functions? This session will answer these questions and show solutions to common ETL problems.
SQL Session – Execution Plan Caching and Reuse
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.
In this presentation, Alejandro is going to talk about how batches are cached and reused (SS 2005 / 2008), and a review of best practices on maximizing reuse of cached plans.
SQL Session – Inside SQL Server 2008 Resource Governor
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.
In this presentation, Aaron Bertrand will provide an overview of Resource Governor, a new feature in SQL Server 2008 that will give DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He will explain how you can leverage SQL Server 2008's Resource Governor not only for preventing the "runaway query" but also for prioritizing workloads, testing consolidation approaches, meeting service level agreements, and configuring a charge back system. Aaron will also provide information about what you cannot or should not do with Resource Governor. This presentation is the basis of an upcoming white paper to be published soon.
Pages
Categories
- Book Review (3)
- fiction (3)
- life (26)
- Microsoft SQL (197)
Blogroll
Photos
shannon and diane
If you want to see my LinkedIn profile, click on this button:
Interesting Articles
- The Solo Adventures 20100909 Lambert V.
- Robots Taught to Deceive 20100909 CmdrTaco
- How do radar detectors and jammers work? [Mad Science] 20100909 Esther Inglis-Arkell
- Ride a Polar Bear to Work: Comic 20100909 The Awesomer
- A Better DBA Job Description For Everyone 20100909 Thomas LaRock
- Censorship Stays as iPhone App Development Rules "Relax" [Apple] 20100909 Jesus Diaz
- Where to Find Funny Shows Online This Fall [Streaming Television] 20100909 Kevin Purdy
- iOS 4.1 Jailbreak is Close, as Bootrom Exploit is Confirmed [Apple] 20100909 Kat Hannaford
- Toys With Mental Illnesses—Seriously [Toys] 20100909 Kat Hannaford
- Droid 2 R2-D2 boot animation, live wallpapers leak out at light speed 20100909 Donald Melanson