SQLSaturday #55 - San Diego 2010
Event Date: 09/18/2010 00:00:00
Event Location:
- Provide Commerce
- 4830 Eastgate Mall
- San Diego, California
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Reducing the impact of database changes on an app
Abstract: The session is about domain driven development. It seems most ORM frameworks being out there do not really solve the abstraction problem between the two as these are table centric. Do such really follow SOA principles when it comes to treating the db? Empower your next project with… server side ORM. I will let you deeply rethink what you’ve done so far.
My approach let me save days or weeks of otherwise wasted development hours when it comes to “make a change”. You might feel ORM of your choice seem let you kickstart the project faster, but then… every major change and tweak here and there is a nightmare (refactor, recompile, retest, redeploy). Rewriting an app after every change is like working one step forward, two step backwards.
Speaker(s):
- Rajmund Rzepecki
Track and Room: Track 3 - N/A
Title: SQL Design Patterns
Abstract: atterns emerge as both templated solutions to recurring problems and designs, as well as provide useful ways to encapsulate complex ideas into smaller, friendlier terms. Patterns gained popularity in the object-orientated community since the Fowler and the Gang Of Four, but declarative languages, like SQL, have had little-to-no coverage of how these patterns can be applied. Understanding SQL design patterns is a crucial skill every SQL developer must learn and use in their career. SQL patterns can be applied to small projects or large, multi-million dollar systems, to provide common solutions to complex problems. Patterns create a foundation for “best practices” for SQL, Database Architecture, managers.
Speaker(s):
- Jim Bears
Track and Room: Track 2 - N/A
Title: Replication ABCs
Abstract: Database Replication is a daunting subject. This session will lay out the basics of what replication is, the options available to you, the tools you can use and a survey of related technologies. To anyone considering the use of replication in their environment, this session will give you the information needed to make intelligent decisions.
Speaker(s):
- Steve Hendricks
Track and Room: Track 1 - N/A
Title: Getting SQL Service Broker Up and Running
Abstract: 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.
Speaker(s):
- Denny Cherry
Track and Room: Track 1 - N/A
Title: Building nTier Apps with Entity Framework - Part 2
Abstract: Learn how to build real world nTier applications with the new Entity Framework and related services. Make sure to attend Part 1. This second part to the series will focus on using the Entity Framework in an nTier/ SOA world by separating out the different layers using T4 templates and using the new WCF Data Services to easily expose entity models via REST and to Silverlight clients. Lots of code!
Speaker(s):
- David McCarter
Track and Room: Track 3 - N/A
Title: Implementing Fine-grained Data Security
Abstract: Data security presents a challenge for many groups in a company. Application requirements often specify different data content for various users, while those responsible for security recognize the need to limit access as much as possible. Available options typically involve trade-offs in security, flexibility, and added work. SQL Server provides a number of security features, but row-level security is missing. This session will consider some current architectural approaches to implementing flexible data security, and then examine a packaged solution for SQL Server to effectively customize row and column access for users without login accounts.
Speaker(s):
- Mark Stewart
Track and Room: Track 2 - N/A
Title: SQL at the Speed of Flash
Abstract: Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant performance increases using solid state storage. The bottom line: SQL runs 4-10x faster on solid state. This session will discuss the various solid-state storage options with their pros and cons. This session will provide practical knowledge around the use of solid state storage for databases and will use real-world use cases to demonstrate the performance advantages of using solid state.
Speaker(s):
- Sumeet Bansal
Track and Room: Track 2 - N/A
Title: Ace the Interview
Abstract: Job Search: Too often what separates us from the job we want is that we don’t do HOW to interview. Sadly, if you don’t know how to do something, you will probably not do it well. This session is designed to give you the inside track on what employers are looking for and includes an interactive hands-on portion where you can hone your interviewing skills.
Speaker(s):
- Steve Hendricks
Track and Room: Track 3 - N/A
Title: Caching your data with Microsoft AppFabric
Abstract: Take your system to the next level and scale highly read infrequently changed data with AppFabric today! AppFabric (code named “Velocity”) has been released and is the latest high availability caching product from Microsoft. Every database professional should understand this new technology as another tool in scaling their database systems. This session will review the physical and logical architecture, configuring, and interacting with AppFabric API. Session will demo retrieving data from SQL Server and caching it into an AppFabric structure.
Speaker(s):
- Troy Gatchell
Track and Room: Track 3 - N/A
Title: Database “Insecurity”
Abstract: We all know that database security is important. Data is the lifeblood of modern business. Moreover, Microsoft has given us tremendous tools for securing our databases at the database level. Yet, how many database developers and database administrators use them? How many understand them? Database security is woefully neglected. There are relatively few articles published on database security. There are no new books on database security. Compare this with the tremendous number of books, articles and conferences on Network Security. Yet, our databases are vulnerable. This is a call to action.
Speaker(s):
- David Moutray
Track and Room: Track 1 - N/A
Title: SQL Azure Deep Dive
Abstract: In this demo-filled session, Lynn will explain the differences between Windows Azure storage and SQL Azure. She wil demonstrate working with SQL Azure storage in your application and discuss the option to connect a non-cloud hosted front end and/or a cloud-hosted front end to a SQL Azure back end solution. Lynn will also talk about migration strategies and best practices. In her talk, you wil also learn recommended business scenarios for cloud-based storage. Finally, she will cover in detail features of SQL Server RDMS which are and are not supported in SQL Azure.
Speaker(s):
- Lynn Langit
Track and Room: Track 1 - N/A
Title: Database Antipatterns
Abstract: We’ve all seen them. We’ve commiserated with one another about them over coffee at conferences and in blog sites. Bad database design is much more common than good database design. This discussion will cover a few of the most prominent “Antipatterns” common to database design today.
Speaker(s):
- David Moutray
Track and Room: Track 1 - N/A
Title: XML Data Type
Abstract: Knowing how to manipulate XML data in SQL Server can greatly benefit any DBA. In addition to Microsoft providing vital server information through extended events and data definition language (DDL) triggers in XML format, XML has become a ubiquitous format. Learn the basics on working with the XML Data Type in SQL Server.
Speaker(s):
- Matt Galaviz
Track and Room: Track 3 - N/A
Title: Looking at LINQ
Abstract: LINQ was introduced in .NET 3.0… by .NET 4.0 parts of it are almost depricated. Let’s look at LINQ, what are its strengths, where does it fit moving forward. We’ll talk about LINQ to SQL, LINQ to Dataset, LINQ to Entities, LINQ to CAML and where each of these fit.
Speaker(s):
- Bill Sheldon
Track and Room: Track 2 - N/A
Title: Query Tuning - Get it Right the First Time
Abstract: Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Dean Richards
Track and Room: Track 2 - N/A
Title: Building nTier Apps with Entity Framework - Part 1
Abstract: Learn how to build real world nTier applications with the new Entity Framework and related services. With this new technology built into .NET, you can easily wrap an object model around your database and have all the data access automatically generated or use your own stored procedures and views. The session will demonstrate how to create and consume these new technologies from the ground up and focus on database modeling including views and stored procedures along with coding against the model via LINQ. Dynamic data website will also be demonstrated. Lots of code! Make sure to attend Part 2.
Speaker(s):
- David McCarter
Track and Room: Track 3 - N/A
Title: Performance Tuning with Traces
Abstract: We’ll touch on SQL Profiler and review its best practices so that you don’t impact the production system while gathering data. We’ll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We’ll also examine the things that I look for when troubleshooting performance issues.
Speaker(s):
- Tara Kizer
Track and Room: Track 2 - N/A
Title: Reading the SQL Server Execution Plan
Abstract: 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.
Speaker(s):
- Denny Cherry
Track and Room: Track 1 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Lynn Langit
Contact: http://blogs.msdn.com/SoCalDevGal
Lynn is a Sr. Developer Evangelist. She has been working with SQL Server since 6.5. Prior to joining Microsoft, she did production work with SQL Server, Analysis Services and more. Her blog is http://blogs.msdn.com/SoCalDevGal
Bill Sheldon
Contact: http://www.nerdnotes.net/blog
William Sheldon is a contributing editor for SQL Server Magazine and a Microsoft MVP for Visual Basic .NET. He’s coauthor of Professional Visual Basic .NET with .NET 4.0 (Wrox), Professional Office Business Application Development (Wrox) and has been an instructor at University of California, San Diego. He is currently working in corporate IT with Rubio’s restaurants.
Troy Gatchell
Troy Gatchell is a seasoned SQL Server professional with a bachelor’s degree in computer information systems and a master’s degree in business administration. He has a decade of experience in design and administration of large scale SQL Server implementations. Currently, Troy is a Sr. Database Administrator for Provide-Commerce. Troy has a passion for table partitioning, T-SQL code optimizations, VLDB implementations, and teaching.
Dean Richards
LinkedIn: Dean Richards
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Mark Stewart
Contact: http://Bitkoo.com
Mark Stewart has over 20 years experience in application design and development using SQL Server and Oracle in a variety of industries. He is currently a Senior Project Manager at Bitkoo, a software security company.
David Moutray
MCITP Database Administrator and MCTS Database Developer, with 4 years experience in database administration and development. (Several years experience as a systems administrator prior to that.) Passionate about database design, development and good administration. Enthusiastic to embrace new technologies impacting the database world. A perpetual student who wishes to share his knowledge (and his questions) with the database community.
David McCarter
Contact: http://dotnettips.com
David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com… a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is quot;David McCarter#39;s .NET Coding Standardsquot;). He is one of the founders and directors of the 20 year old San Diego .NET Developers Group (www.sddotnetdg.org)
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Rajmund Rzepecki
Rajmund’s brain always molds and adapts all ideas/concepts that he encounters into new inventions/approaches. Had never written same line of code twice. Worked on creating million dollar technologies instantly adopted and reused across entire company and product line. Had experience with real time market data and trading client as well as government and banking. Enjoys a unique capability of seeing things what others can’t really see such as adopting new technologies in solving problems in IT.
Matt Galaviz
I have been working with SQL Server since SQL Server 2000 and currently work as a Database Administrator.
David Moutray
MCITP Database Administrator and MCTS Database Developer, with 4 years experience in database administration and development. (Several years experience as a systems administrator prior to that.) Passionate about database design, development and good administration. Enthusiastic to embrace new technologies impacting the database world. A perpetual student who wishes to share his knowledge (and his questions) with the database community.
Sumeet Bansal
Sumeet Bansal is Principal Solutions Architect for Fusion-io. He designs architectural solutions with Fusion-io products that deliver unprecedented levels of scalability, performance and simplicity.
Sumeet has more than 11 years IT and database-infrastructure experience, including work as vice-president of information technology at MS SQL-based Internet retailer Wine.com, senior database architect for MS SQL-based eVineyard inc., and systems analyst for Akiba Bank Limited.
Jim Bears
For over 18 years, repeatedly recognized for developing innovative solutions for multi-million dollar, globally deployed software and systems. Jim Bears is a frequent speaker in Southern California user groups and Code Camps, and also serves as a Director for the San Diego .NET Developers Group, mentor at the San Diego .NET Tech Immersion Group, and Co-Founder of SQLSaturday San Diego. He also currently serves as Chief Technology Officer for Computer Market Research, Ltd
Steve Hendricks
Steve Hendricks is a sought after speaker and consultant on database and job search topics. Having been a Database Administrator since 1997 and Microsoft certified since 2000, he has seen and heard it all. His sessions are always well attended and highly anticipated.
Tara Kizer
Contact: http://weblogs.sqlteam.com/tarad
Tara Kizer has 16 years of experience with SQL Server, 13 of it as a DBA. She currently works at Qualcomm, where she is a DBA supporting mission critical systems with high performance and high availability requirements. She has been a Microsoft SQL Server Most Valuable Professional (MVP) since July of 2007. She is one of the top contributors (34k+ posts) in the SQLTeam.com forums and posts under the username tkizer.
David McCarter
Contact: http://dotnettips.com
David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com… a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is quot;David McCarter#39;s .NET Coding Standardsquot;). He is one of the founders and directors of the 20 year old San Diego .NET Developers Group (www.sddotnetdg.org)
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Steve Hendricks
Steve Hendricks is a sought after speaker and consultant on database and job search topics. Having been a Database Administrator since 1997 and Microsoft certified since 2000, he has seen and heard it all. His sessions are always well attended and highly anticipated.
Sponsors
The following is a list of sponsors that helped fund the event: