Awareness Technologies 3041 http://www.linkedin.com/in/mrdenny Southern California Denny Cherry http://itke.techtarget.com/sql-server 4.73 /avatars/3041/thumb/stream.28020.0 2010-02-01T22:25:42+00:00 264 2073 Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. By the end of this session you'll understand where SQL Service Broker is the right fit to be used, and you'll hopefully be ready to deploy it within your environment. http://www.mrdenny.com/downloads/2010.01.30_SoCal_Code_Camp/SQL%20Server%20Service%20Broker%20in%20the%20Real%20World.zip 2010-02-01T22:25:42+00:00 2010-01-31T10:15:00+00:00 5.0 2010-02-01T22:26:32+00:00 264 2074 We will be looking at some of the advanced features of SQL Service Broker as well as some of the advanced techniques which can be used to maximize the performance of the SQL Service Broker. http://www.mrdenny.com/downloads/2010.01.30_SoCal_Code_Camp/SQL%20Service%20Broker%20Advanced%20Performance%20Tips%20&%20Tricks.zip 2010-02-01T22:26:32+00:00 2010-01-30T16:00:00+00:00 5.0 2010-02-01T22:24:40+00:00 264 2072 We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them. All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server. http://www.mrdenny.com/downloads/2010.01.30_SoCal_Code_Camp/Back%20To%20Basics;%20Getting%20Back%20To%20The%20Basics%20of%20SQL%20Server.zip 2010-02-01T22:24:40+00:00 2010-01-30T13:30:00+00:00 5.0 2009-11-15T06:28:05+00:00 161 1833 In this session we will go over the how indexes work, and how to create them for maximum benefit. We will also go over some of the tips and tricks that DBAs use to improve index performance. http://www.socalcodecamp.com/session.aspx?sid=18c637ce-60e5-4edc-8f97-72d95351e69c 2009-11-15T06:28:05+00:00 2009-11-21T06:00:00+00:00 4.45 2009-11-15T06:29:04+00:00 161 1834 One of the biggest issues in database performance is around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server. http://www.socalcodecamp.com/session.aspx?sid=16653a24-69bf-4845-8de5-cc007c043ca5 2009-11-15T06:29:04+00:00 2009-11-21T06:00:00+00:00 4.95 2009-11-15T06:30:17+00:00 161 1835 In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output. This includes looking at the graphical as well as the XML version of the execution plan. We'll explore the variety of operators that the execution plan can present you with, and show you how to tell the SQL Server that you want to change the execution plan to get rid of the operators that you don't want to be using any more. http://www.socalcodecamp.com/session.aspx?sid=7798c7f2-0177-4d91-b9ad-8e1880ebe4a4 2009-11-15T06:30:17+00:00 2009-11-21T06:00:00+00:00 4.13 2009-11-15T06:26:24+00:00 1832 Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting. 605 E Huntington Dr, Monrovia, CA 91016 http://www.sgvdotnet.org/ 2009-11-15T06:26:24+00:00 2009-11-18T18:00:00+00:00 2009-08-20T20:53:45+00:00 1354 In just a few minutes, Denny Cherry will: * Walk through the process of setting up a Windows Server 2008 Cluster, and installing SQL Server 2008 in a clustered environment. * Go over the hardware and software requirements as well as the networking requirements. * Hold a live Q&A about the process and clustering in general. Clustering SQL Server provides a very reliable high availability solution which will allow your SQL Server database to survive a server hardware failure or system reboot. Bring cost-effective SQL server clustering to your database infrastructure and: * Understand what you need to set up a Windows Server cluster and SQL server. * Learn how to Configure iSCSI Shared Storage for SQL Server with StarWind Software. * Learn how to implement a failover cluster from a Windows Server 2008 Failover perspective. * Step-by-Step configurations to set up your Windows Cluster and SQL Server. http://www.starwindsoftware.com/denny-cherry-sql-server http://www.starwindsoftware.com/denny-cherry-sql-server 2009-09-30T15:40:05+00:00 2009-10-21T11:00:00+00:00 2009-10-09T17:24:48+00:00 202 1551 Talking about setting up the VMware 2009-10-09T17:24:48+00:00 2009-10-09T12:30:00+00:00 2009-09-30T15:38:25+00:00 1497 We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision. Webcast http://itknowledgeexchange.techtarget.com/sql-server/join-me-tomorrow-as-i-talk-about-virtualization/ 2009-09-30T15:38:25+00:00 2009-09-30T09:00:00+00:00 5.0 2009-08-20T20:51:41+00:00 1353 SQL Server Indexing for the Client Developer What Do all Those Undocumented Stored Procedures do? American Honda Motors Bldg 100, # 100-1E-13 1919 Torrance Blvd Torrance, CA 90501 2009-08-20T20:51:41+00:00 2009-09-10T19:00:00+00:00 4.7