|
|
Sponsors
|
 |
|
|
|
|
|
Special Offers
|
 |
|
|
|
 |
|
|
Welcome
|
 |
|
Welcome to the SQL Server Innovators Guild (SSIG) site.
Our group meets the 1st Tuesday of each month at ECPI in Greenville, SC.
|
|
|
|
News
|
 |
|
|
|
|
| Sunday, April 05, 2009 |
|
April 7th Meeting: SQL Server Replication
By pwaters @ 6:41 PM :: 988 Views ::
0 Comments :: Meetings
|
|
Please register here.
If you read the last email you might have notice I had the date for this meeting a month off. Sorry about that.
6:00 – 6:30 Pizza and Networking sponsored by MDI Group
6:30 – 6:40 Announcements
6:40 – 7:50 Ram Garipall :SQL Server Replication
7:50 – 8:15 Russ Jester: The new SSIG web site and NHibernate
8:15 – 8:30 Closing remarks and give-a-ways
Ram Garipall: SQL Server Replication
SQL Server Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using SQL Server replication data can be distributed over local and wide area networks, dial-up connections, wireless connections, and the Internet to different locations and remote or mobile users.
The presentation will have few slides and a demo of replication setup between a Server with enterprise edition and a client with SQL Express.
Ram Garipalli is a certified Oracle and SQL Server DBA working for TiBA solutions as Senior Database Administrator and Data Analyst. He is working with SQL server for more than 10 years and has experience with Reporting services, Integration Services, Analysis Services, and Replication.
Russ Jester: The making of the new SSIG web site.
Russ will introduce us to our new web site, describe the technologies used and then elaborate on it use of NHibernate.
|
|
|
|
|
| Wednesday, February 25, 2009 |
|
March 3rd Meeting: Policy-Based Management
By pwaters @ 10:36 PM :: 1130 Views ::
0 Comments :: Meetings
|
|
Please register here.
6:00 – 6:30 Pizza and Networking Sponsored by FGP
6:30 – 6:40 Announcements
6:40 – 7:00 Ken McClaren : SQL Server 2008 Activity monitor
7:00 – 8:15 Paul S. Waters: Policy-Based Management
8:15 – 8:30 Closing remarks and give-a-ways
Paul S. Waters: Policy-Based Management
This presentation has a few slides and lots of demos. We will be covering some of the most useful new features in SQL Server 2008; Policy-Based and multi-server management. We will cover how to set up policy-based management, and a few use cases. There are even some nice use cases for application developers. Much of what will be presented can also be used against SQL Server 2000 and 2005 databases.
In our last meeting with K. Brian Kelley he mentioned this as being a great new tool to help secure and understand your environment, so I thought this would be a great way to keep the momentum he got going in February going in March.
|
|
|
|
|
| Thursday, February 05, 2009 |
|
|
|
| Wednesday, January 21, 2009 |
|
February 3rd Meeting: Fortress SQL Server
By pwaters @ 4:48 AM :: 1071 Views ::
0 Comments :: Meetings
|
|
6:00 – 6:30 Pizza and Networking sponsored by TEKsystems .
6:30 – 6:40 Announcements
6:40 – 7:00 Ken McClaren : Lessons Learned: Upgrading to SQL Server 2008
7:00 – 8:15 K. Brian Kelley: Fortress SQL Server
8:15 – 8:30 Closing remarks and give-a-ways
K. Brian Kelley: Fortress SQL Server
We'll look at best practices for securing SQL Server and the data contained within from both a DBA and developer perspective. Starting with the basics of how to relate security to business personnel, we'll then dive in to the technical aspects of locking down SQL Server. SQL Server 2000 through 2008 will be covered.
K. Brian Kelley is a SQL Server author and columnist focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a database administrator / architect for AgFirst Farm Credit Bank. He formerly served as a systems and security architect where he worked on Active Directory, Windows security, VMware, Citrix, and of course, SQL Server. In the technical community, Brian is part of the Midlands PASS Chapter, an official chapter of PASS. Brian is also a junior high youth minister at Spears Creek Baptist Church in Elgin, SC.
|
|
|
|
|
| Saturday, November 01, 2008 |
|
|
|
| Thursday, October 09, 2008 |
|
|
|
| Tuesday, September 30, 2008 |
|
October 7th Meeting: SQL Server 2008 Resource Governor
By pwaters @ 12:22 AM :: 1477 Views ::
0 Comments :: Meetings
|
|
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 Resource Governor
8:15 – 8:30 Closing remarks and give-a-ways
Steve Wright – Director of Product Support SQL Sentry, Inc.
In this presentation, Steve 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.
We will also be just 4 days from SQL Saturday #9. If you want to attend and have not registered, please register on the SQL Saturday Site.
There is some awesome training in Atlanta coming up soon. Take a look at http://www.solidq.com/na/Directions.aspx .
|
|
|
|
|
| Monday, September 01, 2008 |
|
September 2nd Meeting: SQL Saturday, Dynamic Data, New T-SQL in SQL Server 2008
By pwaters @ 11:23 PM :: 1489 Views ::
0 Comments :: Meetings
|
|
Please register at http://ssig080902.eventbrite.com/
Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 , SQL Saturday, Dynamic Data, New T-SQL in SQL 2008
8:15 – 8:30 Closing remarks and give-a-ways
SQL Saturday
Saturday October 11th at ECPI we will be having a SQL Saturday. The event is free to all attendees and is organized and implemented by volunteers. Some of the volunteer positions take a good deal of time and effort, but most do not. A list of volunteer positions will be reviewed and anyone that will like to participate is welcome to volunteer.
We will have a discussion about to topics already being presented and taking suggestion for other topics.
Dynamic Data
A very high level, but practical use of the new ASP.NET Dynamic Data features in .net 3.5 SP1.
New T-SQL in SQL Server 2008
A few of the new T-SQL enhancements are quite useful and long over due. We will look at a few of these and discus there uses.
|
|
|
|
|
| Tuesday, July 15, 2008 |
|
August 5th Meeting: Preventing SQL Injection Attacks
By pwaters @ 9:44 AM :: 1399 Views ::
0 Comments :: Meetings
|
|
"Presenting a new angle on a popular attack vector on databases: SQL Injection."
We will describe types and techniques of SQL Injection attacks on both RDBMS-based web applications and built-in database stored program units, and show how simple SQL Injection can be used to own the database server through the means of privilege escalation.
We will also list ways of preventing SQL Injection attacks - ranging from secure coding practices to various external tools that will alert and prevent SQL Injection attempts, and demonstrate how hacker techniques of evasion can be used to subvert them.
Finally, we will introduce new deep inspection tools for Microsoft SQL Server that can prevent SQL injection, even in zero-day scenarios.
Take away points:
. How SQL Injection attacks work
. Secure coding practices
. Existing tools for SQL Injection prevention and techniques to evade them
. New resilient technologies used to solve entirely SQL injections, even those exploiting zero-day vulnerabilities
|
|
|
|
|
| Thursday, June 26, 2008 |
|
July 1st Meeting: Canceled
By pwaters @ 1:09 AM :: 1672 Views ::
0 Comments :: Meetings
|
|
We are canceling our July Meeting. July has been a tough month for us to have a meeting. Some years July 4th is on a Tuesday and all others it is within a few days. In the future we will not be scheduling a meeting in July.
|
|
|
|
|
|
|
 |
|
|
Affiliate Groups
|
 |
|
|
|
|
|
Favorite Links
|
 |
|
|
|
 |