|
|
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
|
|
|
|
|
|
| Thursday, October 09, 2008 |
|
|
|
| Tuesday, September 30, 2008 |
|
October 7th Meeting: SQL Server 2008 Resource Governor
By pwaters @ 12:22 AM :: 40 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 :: 129 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 :: 321 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 :: 424 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.
|
|
|
|
|
| Thursday, June 26, 2008 |
|
SSIS Tools, Tips and Tricks Presentation Notes
By pwaters @ 12:23 AM :: 1934 Views ::
0 Comments :: Member Interest
|
|
Here are some notes with a buch of links to topics discussed in our June 3rd, 2008 meeting.
I have put the Word document on my SkyDrive http://cid-89384f23767a9a97.skydrive.live.com/browse.aspx/Public?uc=1 .
1 Tools
1.1 BIDS Helper
1.1.1 Create Fixed Width Columns
1.1.2 dtsConfig File Formatter
I cannot get this to work. Ctrl-K,Ctrl-D does the same thing, but hard to remember.
1.1.3 Expression and Configuration Highlighter
For very large packages this might need to be disabled.
to enable or disable functionality go to Tools | Options ... The select BIDS Helper.
1.1.4 Expression List
This is a big time saver. All of your expressions are listed in one place. Also they can be edited from here as well.
To get to it go to View | Other Windows | Expression List (BIDS Helper)
1.1.5 Smart Diff
Smart Diff is great for comparing your working copy of a package against the last version checked into your version control system. In addition it makes the xml, the packages are saved as, easier to read by us humans.
1.2 SSIS Non Admin Access Tool
1.3 SSIS Package Manager - PacMan
1.4 Version Control
Use it early and often. There is no UNDO in many cases.
2 Tips
2.1 Creating Solutions
2.1.1 Start with a blank solution
|
| Read
More.. |
|
|
|
|
| Monday, June 02, 2008 |
|
June 3rd Meeting - SQL Server Integration Services (SSIS) Tools, Tips and Tricks
By pwaters @ 1:44 AM :: 448 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 :: 615 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 :: 575 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 :: 554 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
|
|
|
|
|
|