|
|
| 2011 Baltimore SQL Server Users Group Meeting Schedule | Date | Speaker | Title and Abstract | Sponsor | January 3, 2011 | | No Meeting | | | February 14, 2011 | Yair Granek | Title - Plug and Play Scalability & Performance Solution Abstract - Information runs today’s business. Customers, employees and real time applications rely more and more on the content of the DB’s. As the demand on the DB’s continue to increase, IT’s, developers and system architects search for ways to maintain Performance levels and Response Time during heavy loads or Peaks, without major investment in infrastructure nor modification of the applications/DB.
Established in 2007, SafePeak Technologies is a privately held company. It is led by an experienced management team and backed by leading investors.
SafePeak Technologies, a leading company in the area of performance and scalability of enterprise application systems, developed a pioneering solution that gives instant acceleration of performance and scalability of existing information applications and systems. Specifically, SafePeak is an industry first automated in-memory dynamic caching solution, that boosts speed of data access to microsecond speed, while has a seamless integration that requires no code changes on application and database levels (Plug & Play). SafePeak installations accelerate Web Servers, E-commerce portals, Document Management, CRM, ERP and other enterprise applications. SafePeak works with well established partners creating a global reselling channel network for distribution and support of SafePeak solutions in different local markets. Partners from USA, Europe and Asia Pacific are already providing local reselling and support service. View Presentation Slides | SafePeak | | | Ilay Golferd | Title - SQL Server Query Performance Monitoring Abstract - This session will cover the following items: What is query performance monitoring as I understand it
What specifically to monitor
Execution times for stored procedures and user defined functions
Deadlock detection
Lock chain detection
How to interpret the results | | | Jeremy Kadlec of Edgewood Solutions 
| Title - New Features in SQL Server 2008 for DBAs - Part 2 Abstract - Come check out some new features in SQL Server 2008 that will not only benefit your organization, but you as a DBA. This demo packed session will cover multi-server administration, multi-query, policy based management, new T-SQL commands and more. In this session we will break down these topics so you can see how they will benefit you, your team and your organization. Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP. | | March 14, 2011 | Kun Lee 
| Title - SQL Server Transactional Replication - Advanced Features, Scripting, Source Safe and more Abstract - Replication is one of the important Microsoft SQL Server features for many companies. However, very often I see many DBAs and Developers maintaining replication through the GUI. This makes it harder to standardize the deployment and even harder to automate it. In our environment we have a number of special requirements to maintain replication, such as special indexes on the subscribers, supporting republishing replication (AKA, Publishing Subscriber) and most important, keeping all code in Source Safe. So, I’d like to share what I have done with my current company with a lot help from my colleagues. Hopefully these lessons learned will help other DBAs or I can get great feedback from you on our approach, so that I can apply your lessons learned, to my current process. View Presentation Slides Bio - Kun is a database administrator in Bethesda, Maryland. His areas of interest are database administration, architecture, data modeling and development. He loves technologies of all kinds. | Idera | April 11, 2011 | Andy Novick 
| Title - Programming with the SQLCLR in SQL Server Abstract - SQL Server provides the capability to run .Net code right inside SQL Server Engine on a par with T-SQL in what’s called the SQLCLR. This gives the programmer an expanded choice of programming language and some new object types. This presentation shows you how to write C# or VB.Net routines and execute them in SQL Server as one of the supported SQL object types: - Stored Procedure
- Scalar or Table User-defined Function
- Trigger
- User-defined Aggregate
- User-defined Type
Each of these objects has its own requirements and opportunities. Using the SQLCLR as opposed to T-SQL has tradeoffs and we’ll examine when T-SQL is better and when using SQLCLR is best. We’ll also take a look at error handling and performance comparisons between T-SQL code and similar .Net code. Bio - Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. | Telerik | | May 9, 2011 | Vladimir Yangurskiy of Microsoft | Title - Using PowerShell™ in SQL Server Management Abstract - In this presentation I’m going to show how to setup/configure and use PowerShell™ for SQL administration. Also, in series of practical examples I’ll demonstrate how you can utilize your existing knowledge of SQL Server to customize PowerShell for your day-today needs. View Presentation Slides | Experis IT | June 13, 2011 | Roman Rehak of mywebgrocer | Title - SQL Server Development Tips and Tricks Abstract - This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment. View Presentation Slides | MSSQLTips.com | July 11, 2011 | Ray Barley of RDA Corp 
| Title - Building BI Solutions with SharePoint 2010 and SQL Server 2008 R2 Abstract - An overview of building Business Intelligence solutions that leverage SharePoint 2010 and SQL Server 2008 R2. Topics to be discussed include building dashboards with PerformancePoint Services, self-service BI with Excel 2010 PowerPivot and Report Builder 3.0, and configuring/running Reporting Services in SharePoint Integrated mode. Ray will be raffling off several copies of a new book that he co-authored: SharePoint 2010 Business Intelligence Unleashed View Presentation Slides Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com). | Red Gate | August 8, 2011 | Edwin Sarmiento, SQL Server MVP 
| Title - Gone Clustering in 60 Minutes Abstract - Creating a SQL Server 2008 Failover Cluster on Windows Server 2008 has become a lot easier with the availability of online resources such as MSSQLTips.com. However, making it easy does not mean ignoring the basic principles of the underlying technology. In this session, learn the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology, allowing you to build highly available database infrastructures. Bio - Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada. | LogicMonitor | | September 12, 2011 | Jeremy Kadlec of Edgewood Solutions
| Title - SQL Server Denali for DBAs and Devs Abstract - With SQL Server Denali CTP 3 bits available for download, come check out what is new, what has changed and what has stayed the same in SQL Server. Jeremy will share some of his experiences with Denali testing and deliver some demos to start to introduce the new feature set. Come join us to get your first exposure to SQL Server Denali to learn how debugging has improved, what you have access to in a contained database and much more. Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP. | Telerik | October 10, 2011 | Jeremy Kadlec of Edgewood Solutions
| Title - Building Blocks for Your SQL Server Career Abstract - Do you have the needed skills for your SQL Server career? Whether you are looking to land your first job or advance into a managerial position, this session will offer recommendations to you. From interview tips to skills all employers are looking for in SQL Server professionals, this session will benefit you. Bio - Jeremy is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com and a SQL Server MVP. | Redtail Creek Software | | Ray Barley of RDA Corp
| Title - Creating SharePoint 2010 Content Databases with PowerShell Abstract - PowerShell is now the preferred way to perform SharePoint administration. This session will demo how to use PowerShell to create content databases and site collections that are associated with a specific content database. Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com). | | November 14, 2011 | Ray Barley of RDA Corp
| Title - Introduction to Log Shipping and Database Mirroring Abstract - In this session we will discuss the pros and cons of log shipping and database mirroring. We'll walk through demonstrations of how to perform the setup using SQL Server management Studio and by running T-SQL scripts. Bio - Ray Barley is a Principal Architect at RDA Corporation (http://www.rdacorp.com). | Idera | | December 12, 2011 | Brad McGehee of Red Gate 
| Title - Introduction to SQL Trace Abstract - While many DBAs are familiar with SQL Server Profiler, they are not familiar with SQL Trace. Very briefly, SQL Trace allows you to capture Profiler traces using system stored procedures, without the extra overhead of using the Profiler GUI, helping to minimize the amount of resources used for capturing traces.
In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts.
This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice. Bio - Brad M. McGehee is the Director of DBA Education for Red Gate Software, an accomplished Microsoft SQL Server MVP with over 15 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. | Red Gate |
| |
|