|
|
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.
October 11th, 2008 at ECPI Greenville, SC
Register Now
|
|
|
|
News
|
|
|
|
|
|
| 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 :: 454 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 :: 535 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 :: 669 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 :: 856 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.
|
|
|
|
|
| Monday, June 02, 2008 |
|
June 3rd Meeting - SQL Server Integration Services (SSIS) Tools, Tips and Tricks
By pwaters @ 1:44 AM :: 854 Views ::
0 Comments :: Meetings
|
|
Register at http://ssig200806.eventbrite.com/
SQL Server Integration Services (SSIS) is a powerful and flexible data integration tool included with SQL Server 2005 Standard and above. As with most powerful and flexible tools, it is easy to hurt yourself with until you know a few tips and tricks coupled with a good toolkit. In this presentation you will learn some tips and tricks for making your SSIS projects go more smoothly, scale better, document themselves (almost), and learn a few time and butt saving tools to help you out.
Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 Paul S. Waters - SQL Server Integration Services (SSIS) Tools, Tips and Tricks
8:15 – 8:30 Closing remarks and give-a-ways
|
|
|
|
|
| Sunday, March 30, 2008 |
|
April 1st Meeting - Data Partitioning and DMVs
By pwaters @ 11:39 PM :: 1005 Views ::
0 Comments :: Meetings
|
|
Our last few presentations have been more focused on Business Intelligence then the SQL Server DBA . Well that streak is about to end. For our April 1st meeting Ram Garipalli from TiBA Solutions will be teaching us how to use database partitioning and Dynamic Management Views .
Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 Ram Garipalli - Data partitioning and Dynamic Management Views
8:15 – 8:30 Closing remarks and give-a-ways
|
|
|
|
|
| Monday, March 03, 2008 |
|
March 4th Meeting: New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
By pwaters @ 11:47 AM :: 917 Views ::
0 Comments :: Meetings
|
|
Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 John Welch, New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
8:15 – 8:30 Closing remarks and give-a-ways
New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
In this presentation, we will cover the new features in SQL Server 2008 that make delivering business intelligence and data warehousing solutions faster, easier, and more flexible. We’ll review all the major BI components of the SQL Server stack, including Analysis Services, Reporting Services, and Integration Services. We’ll also touch on a number of improvements in the relational engine that impact business intelligence.
About the presenter
John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting & analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 6 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, Software Development West (SD West), Software Management Conference (ASM/SM), and others. John has also been published in DM Review, SQL Server Professional, and XML Developer.
|
|
|
|
|
| Monday, March 03, 2008 |
|
March 4th Meeting: New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
By pwaters @ 7:42 AM :: 880 Views ::
0 Comments :: Meetings
|
|
Agenda
6:00 – 6:30 Pizza and Networking
6:00 – 6:45 Announcements
6:45 – 8:15 John Welch, New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
8:15 – 8:30 Closing remarks and give-a-ways
New Features in SQL Server 2008 for Business Intelligence and Data Warehousing
In this presentation, we will cover the new features in SQL Server 2008 that make delivering business intelligence and data warehousing solutions faster, easier, and more flexible. We’ll review all the major BI components of the SQL Server stack, including Analysis Services, Reporting Services, and Integration Services. We’ll also touch on a number of improvements in the relational engine that impact business intelligence.
About the presenter
John Welch is Chief Architect with Mariner, a consulting firm specializing in enterprise reporting & analytics, data warehousing and performance management solutions. John has been working with business intelligence and data warehousing technologies for 6 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, Software Development West (SD West), Software Management Conference (ASM/SM), and others. John has also been published in DM Review, SQL Server Professional, and XML Developer.
|
|
|
|
|
|
|
|
|
|
Affiliate Groups
|
|
|
|
|
|
|
Favorite Links
|
|
|
|
|
|