Sep-2011 ~ How to audit and prevent unwanted user actions ~ John Miner

Posted by admin

 

Presenter: John Miner of Sensata Technologies
Topic: How to audit and prevent unwanted user actions

 

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. How do you prevent and audit unwanted user actions to key data?

This presentation will review techniques on how to prevent and/or audit data and schema changes.

The following topics will be presented with examples.

1. Granting correct user access is vital
2. Using DML triggers to keep an DATA audit trail.
3. Using DDL triggers to keep an SCHEMA audit trail.
4. Preventing unwanted DATA modifications
5. Preventing unwanted SCHEMA changes
6. Preventing table TRUNCATIONS
7. New Feature in 2008 – change data capture

Biography:

John Miner (www.craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

Aug-2011 ~ Double Feature ~ John Miner & Grant Fritchey

Posted by admin

 

Presenter: John Miner of Sensata Technologies
Topic: Working with bit patterns

 

In today’s manufacturing environment, production lines are automated with robotics and sensors. Many of these low end microprocessors and/or integrated circuits are designed for specific tasks such as temperature and pressure control.

This presentation will review how to store the memory buffer in a table and use a view to interpret the results.

The following topics will be presented with examples.

1. Using the VARBINARY data type to store the bit pattern.
2. Storing a version number just in-case the decode changes.
3. Breaking the pattern into registers and nibbles.
4. Left shifting of the bits.
5. Right shifting of the bits.
6. Combining bits from two registers.
7. Putting it all together with a view.

Managing your data well can lead to savings in disk space as much as 75%.

Biography:

John Miner (www.craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

 

Presenter: Grant Fritchey of Red Gate
Topic: Seven Different Solutions for Bad Parameter Sniffing

 

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad.

In this session we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then, we’ll explore how parameter sniffing can go wrong and I’ll show you seven different ways you can deal with it when it does.

You’ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment. Everyone has heard about twitter, facebook and linkedin but how or why does one get started?

Biography:

Grant Fritchey has twenty+ years experience in IT. That time was spent in technical support, development and database administration. He works for Red Gate Software as a Product Evangelist and writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He has published two books, “Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the Southern New England SQL Server Users Group and its current president and works on part-time, short-term, off-site consulting contracts.

Jul-2011 ~ SQL Server & CRM User Groups – Combined Meeting

Posted by admin

 

Presenter: Andy Novick of Novick Software
Topic: The Biggest Loser: Database Edition

 

Fat! That’s how you’d have to describe most databases these days. Gigabytes piled on megabytes until the terabytes add up and up. In one way, we think of disk space as cheap. After all you can go down to the local office supply store or on-line and buy a terabyte drive for less than $100. But can you really use justify that for a database?

Not of you want to get the kind of performance, redundancy and disaster recovery that are demanded of today’s applications, so you use a SAN, or a multi-drive array or solid-state storage and pretty soon you’re spending some real money. Add it up: the san, the fiber network, SSD’s, the disaster recovery system, the development system, the QA system, backup space and staff to manage it all. Pretty soon that $100 terabyte turns into around $75,000. Managing your data well can lead to savings in disk space as much as 75%.

The Biggest Looser: Database Edition presentation shows you how to put your database on a diet using the features of SQL Server: •Compression •Filtered indexes •Maintenance, REBUILD and REORGANIZE •Index management: Do you really need all those indexes? •Application Changes. Topics include •How to calculate the storage required for each row? •How to measure the actual storage of each row •How to find hidden overhead such as Snapshot Isolation bytes •How to recover extra space •Why NOT to SHRINK your database files •Why log files grow and how to keep them under control •How to shrink log files the right way •Rebuilding files to recover all the extra space

Biography:

Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server’s capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular “SQL Server Load-fest” event conduced in Waltham, MA.

 

Presenter: Anne Stanton of FM Global
Topic: Joining the Conversation in a world of Social Media

 

Everyone has heard about twitter, facebook and linkedin but how or why does one get started?

Why do people care about this trend and what is really in it for you? This session is going to be focused not only on the social media tools and their potential integration to Dynamics CRM, but also on some of the business reasons why joining into the conversation can increase profits and reduce marketing costs.

Biography:

Anne Stanton has a combination of business and technical expertise. She started her career in the 80s as a programmer working with ancient languages like Fortran 77, Basic, Turbo Pascal and Cobol and then built out her expertise as a master of software applications. Mid stride in 2005, she summarized her mix of computer science and business experience by going back to school. She completed her MBA with a sub specialty in Accounting. Anne has spent twenty six years working with technology and is still very passionate about all that it can do to help businesses excel.

Her recent focus has been working with the Microsoft Dynamics xRM platform and Microsoft Dynamics CRM software. She was awarded as the 7th Microsoft MVP for CRM and has a long running blog, (www.crmlady.com) and twitter feed (crmlady) on the subject. She has worked with Microsoft Dynamics CRM as a customer, partner practice leader and consultant starting with version 1.2 which was released in 2004. Anne is currently a Principal Business Analyst for FM Global in Johnston, RI..

Jun-2011 ~ What’s new in SQL Server 2012 ~ Aaron Bertrand

Posted by admin

 

Presenter: Aaron Bertrand – Senior consultant for SQL Sentry, Inc.
Topic: What’s new in SQL Server 2012 (Denali)?

 

Presentation cover many of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Presentation includes several demos and no marketing.

Introduce people to some of the new features they will be getting in Denali. Prepare people for some negative changes (e.g. mirroring now becomes most useful in Windows Enterprise Edition only). Discuss issues of migrating / upgrading from current editions.

Biography:

Aaron Bertrand is a senior consultant for SQL Sentry, Inc, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging at sqlblog.com since 2006, focusing on manageability, performance, and new features; tweets as “@AaronBertrand;” and speaks frequently at user group meetings and SQL Saturday events.

May-2011 ~ Designing Custom Maintenance Plans with TSQL ~ John Miner

Posted by admin

 

Presenter: John Miner of Sensata Technologies
Topic: Designing Custom Maintenance Plans with TSQL

 

Have you ever received a call from a client asking for help when their SQL Server database is corrupted? You suggest that they restore the database from the last good backup. There is a long pause on the phone as the client states that the only backups/tapes they have are bad. Do not let this situation happen to you!

This presentation will review how to build a custom maintenance plans from the ground up using TSQL commands.

1. Verify integrity of databases.

2. Backup databases (full versus differential).

3. Backup logs

4. Maintain database indexes.

5. Maintain index/column statistics.

6. Remove older data from [msdb].

7. Remove older backups from file system.

We will be reviewing best practices for daily, weekly and monthly tasks. This includes tape rotation schemes and restoring those backups to make sure they really work.

Biography:

John Miner (craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance.

Apr-2011 ~ Database Design for mere Developers ~ Steve Simmon

Posted by admin

 

Presenter: Steve Simon of State Street Bank
Topic: Database Design for mere Developers

 

Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design. In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development “patterns and anti-patterns”, final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.

Biography:

Steve Simon is an AVP with State Street Corporation Boston. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe 2009. He has just recently presented his PASS 2008 Summit presentation in Johannesburg South Africa. Steve has also presented 5 papers at the Information Builders’ (IBI) International Technology Summits. He has also had 2 papers published in IBI Journal & is a regular Webinar presenter for IBI.

Mar-2011 ~ Leveraging TSQL to solve business problems ~ John Miner

Posted by admin

 

Presenter: John Miner of Sensata Technologies
Topic: Leveraging Transaction SQL 2008 to solve business problems

 

This presentation will review how to build a database solution from the ground up using SQL commands. What if you were a SQL Server developer at a local consulting company tasked with creating a database for a local Boy Scout of America (BSA) Troop, where would you begin?

The following topics will be reviewed to make sure you have a successful data storage solution.

Defining the Database: Defining file groups for the database, Creating schemas to separate tables by functionality, Creating normalized tables to hold the BSA data, Adding data integrity to the design with constraints/triggers, Adding referential integrity to the design with primary/foreign keys, Adding logins/users and granting rights Loading initial Data:

Loading data into staging area with BULK INSERT, OPENROWSET or BCP, Quick review of TSQL statements for TRANSACTIONS, CONTROL FLOW, and ERROR HANDLING, Writing Stored Procedures to move staging data to production, Schedule Procedures using SQL Server Agent Giving Developers Access: Using stored procedures to lock down CRUD (create, read, update, and delete) operations, Using functions and views to look at the data differently.

In my next presentation, I will be going over advance topics such as PARTITIONING – for keeping track of all those Christmas Trees they sell each year, FILESTREAM – for showing images of the merit badges they might earn, SPATIAL – for keeping track of GPS latitude and longitude coordinates when hiking, and XML for interacting with other systems via messages.

In my next presentation, I will be going over advance topics such as PARTITIONING – for keeping track of all those Christmas Trees they sell each year, FILESTREAM – for showing images of the merit badges they might earn, SPATIAL – for keeping track of GPS latitude and longitude coordinates when hiking, and XML for interacting with other systems via messages.

Biography:

John Miner (craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance.

His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

Dec-2010 ~ Gathering and Interpreting Server Metrics ~ Grant Fritchey

Posted by admin

 

Presenter: Grant Fritchey – SQL Server MVP
Topic: Gathering and Interpreting Server Metrics

 

Before you can start tuning SQL queries, it’s vital that you know how your server itself is behaving. You need to know what the memory, IO and CPU on the machine look like while the system is at rest and under load. You need to establish this baseline in order to better interpret the results of your later query tuning efforts.

There are a number of inherent methods built into SQL Server and the Windows operating system that can supply you with this vital information. There are even third party tools that can take a lot of guess work and manual labor out of the process of establishing these vital measures. This session will cover all the tools necessary to generate a baseline measurement for performance of your SQL Server system. The session is a small part of and serves as an introduction to the one day pre-conference seminar on query performance tuning being offered at SQLRally in May.

Biography:

Grant Fritchey has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last seven years he has been working at a major insurance company as a DBA. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He also published two books, ”Dissecting SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the this Users Group and currently serving as the president. In April 2009 he was awarded as a Microsoft SQL Server MVP. You can also find him tweeting as @GFritchey and blogging at Home of the Scary DBA.

Oct-2010 ~ DMV’s as a Shortcut to Procedure Tuning ~ Grant Fritchney

Posted by admin

 

Presenter: Grant Fritchey – SQL Server MVP
Topic: DMV’s as a Shortcut to Procedure Tuning

 

Dynamic Management Views (DMV) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. More often than not people gather performance metrics through server side traces. This session will show how to gather information from the DMVs for currently executing, and recently executed queries.

The session will demonstrate combining this information with other DMVs to get more intersting information such as the query plan and query text. I’ll show where you can get aggregate information for the queries in cache to determine which queries are being frequently accessed or using the most resources. I’ll show how to determine which indexes are being used in your system and which are not. All of this will be focused, not on the DBA, but on the query writer, the developer or database developer that needs information to tune and troubleshoot data access.

Biography:

Grant Fritchey has twenty years experience in IT. That time was spent in technical support, development and database administration. For the last seven years he has been working at a major insurance company as a DBA. He writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He also published two books, ”Dissecting SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” He is one of the founding officers of the this Users Group and currently serving as the president. In April 2009 he was awarded as a Microsoft SQL Server MVP. You can also find him tweeting as @GFritchey and blogging at Home of the Scary DBA.