Professional Association for SQL Server

Welcome to the Greenville, SC Chapter

 Welcome

We have meetings on the first Tuesday of most months.  Our group meets at the Greeville Campus of ECPI. Our normal room is room #236 but check the visual displays when you arrive to confirm.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - Food and a chance to meet other SQL Server users.
6:30 - 6:45 -
General Q&A session & Announcements
6:45 - 8:15 - Presentation(s)
8:15 - 8:30 - Door prizes and Question & Answer session

 

 Next Meeting
Presentation Layer using Excel and SSAS - Tips & Tricks and Real World Examples
June 3, 2014



For more information and to register, please go to https://ssig201406.eventbrite.com

Presentation Layer using Excel and SSAS  - Tips and Tricks and Real World Examples





The old adage, “Too much data, not enough information”, is more apparent today with the explosion of data and computing power to collect it. In the Microsoft world, SQL Server, SSIS and SSAS provide the foundation for collecting and organizing the data for optimal retrieval. Excel is one of the most popular analytical tool in today’s business. Used in standalone mode, it is limited. Used in conjunction with the Microsoft BI Stack, its power is unleashed. This presentation demonstrates, using real world success stories, how Excel connected to OLAP cubes delivers the goods.

John Gardiner is all about maps, measuring and mathematics. Where are we? How long to get there? And what is the probability of getting there on time?  John has a degree in Mathematical Engineering, a Certificate in Geographic Information Systems, and a concentration of courses in accounting. He has spent most of his career working in IT, is not afraid to roll up his sleeves and code, and he specializes in bridging the gap between the business managers and IT geeks. John understands the power of information and has demonstrated the ability to deliver results using Microsoft SQL Server BI tools and techniques.

LinkedIn: http://www.linkedin.com/in/johngardiner08

 Meetings and News

Current Articles | Categories | Search | Syndication

Presentation Layer using Excel and SSAS - Tips & Tricks and Real World Examples - Article Rating

June 3, 2014



For more information and to register, please go to https://ssig201406.eventbrite.com

Presentation Layer using Excel and SSAS  - Tips and Tricks and Real World Examples





The old adage, “Too much data, not enough information”, is more apparent today with the explosion of data and computing power to collect it. In the Microsoft world, SQL Server, SSIS and SSAS provide the foundation for collecting and organizing the data for optimal retrieval. Excel is one of the most popular analytical tool in today’s business. Used in standalone mode, it is limited. Used in conjunction with the Microsoft BI Stack, its power is unleashed. This presentation demonstrates, using real world success stories, how Excel connected to OLAP cubes delivers the goods.

John Gardiner is all about maps, measuring and mathematics. Where are we? How long to get there? And what is the probability of getting there on time?  John has a degree in Mathematical Engineering, a Certificate in Geographic Information Systems, and a concentration of courses in accounting. He has spent most of his career working in IT, is not afraid to roll up his sleeves and code, and he specializes in bridging the gap between the business managers and IT geeks. John understands the power of information and has demonstrated the ability to deliver results using Microsoft SQL Server BI tools and techniques.

LinkedIn: http://www.linkedin.com/in/johngardiner08

Read More

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social - Article Rating

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social

Sponsored by 
FGP

It is that time of year again were we get together, relax our brains, and get to know each other a little better.  Things like, who is the better pool player, who cannot hit a dart board from 8 feet away, and who is a water, soda, pilsner, or stout drinker.

Please join us as we have a little end of year fun.  In the mix of chatter and laughs it is still OK to talk about SQL, BI, C#, VB, lambda expressions, and the like.  Also Joe and Paul would love to hear your thoughts about the groups, and improvements that we can make.

Please register at https://ssig201312.eventbrite.com (Not required to attend.  It is just to get an idea of the headcount so that we can have the tables arranged accordingly)

Location: Bailey's Pub & Grille from 6:00pm to 9:00pm Tuesday, December 3rd. Feel free to invite friends, spouse, co-workers, etc.

You will be responsible for paying for all or most of what you eat and drink.


 

 

Read More

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social - Article Rating

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social

Sponsored by 
FGP

It is that time of year again were we get together, relax our brains, and get to know each other a little better.  Things like, who is the better pool player, who cannot hit a dart board from 8 feet away, and who is a water, soda, pilsner, or stout drinker.

Please join us as we have a little end of year fun.  In the mix of chatter and laughs it is still OK to talk about SQL, BI, C#, VB, lambda expressions, and the like.  Also Joe and Paul would love to hear your thoughts about the groups, and improvements that we can make.

Please register at https://ssig201312.eventbrite.com (Not required to attend.  It is just to get an idea of the headcount so that we can have the tables arranged accordingly)

Location: Bailey's Pub & Grille from 6:00pm to 9:00pm Tuesday, December 3rd. 

 

Feel free to invite friends, spouse, co-workers, etc.

You will be responsible for paying for all or most of what you eat and drink. Read More

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social - Article Rating

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social



Sponsored by 
FGP

It is that time of year again were we get together, relax our brains, and get to know each other a little better.  Things like, who is the better pool player, who cannot hit a dart board from 8 feet away, and who is a water, soda, pilsner, or stout drinker.

Please join us as we have a little end of year fun.  In the mix of chatter and laughs it is still OK to talk about SQL, BI, C#, VB, lambda expressions, and the like.  Also Joe and Paul would love to hear your thoughts about the groups, and improvements that we can make.

Please register at https://ssig201312.eventbrite.com (Not required to attend.  It is just to get an idea of the headcount so that we can have the tables arranged accordingly)

Location: Bailey's Pub & Grille from 6:00pm to 9:00pm Tuesday, December 3rd. 



 



Feel free to invite friends, spouse, co-workers, etc.

You will be responsible for paying for all or most of what you eat and drink. Read More

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social - Article Rating

Sixth Annual GSP Developer's Guild and SQL Server Innovators Guild Winter Social



Sponsored by 
FGP

It is that time of year again were we get together, relax our brains, and get to know each other a little better.  Things like, who is the better pool player, who cannot hit a dart board from 8 feet away, and who is a water, soda, pilsner, or stout drinker.

Please join us as we have a little end of year fun.  In the mix of chatter and laughs it is still OK to talk about SQL, BI, C#, VB, lambda expressions, and the like.  Also Joe and Paul would love to hear your thoughts about the groups, and improvements that we can make.

Please register at https://ssig201312.eventbrite.com (Not required to attend.  It is just to get an idea of the headcount so that we can have the tables arranged accordingly)

Location: Bailey's Pub & Grille from 6:00pm to 9:00pm Tuesday, December 3rd. 



 



Feel free to invite friends, spouse, co-workers, etc.

You will be responsible for paying for all or most of what you eat and drink. Read More

SQL Change Tracking - From Setup to ETL with SSIS - Article Rating

 6:00 – 6:30 Pizza and Networking sponsored by FGP

6:30 – 6:40 Announcements
6:40 – 7:00 Clif's Corner: PowerShell 101 - Getting Started
7:00 – 8:15 Paul S. Waters: SQL Change Tracking - From Setup to ETL with SSIS
8:15 – 8:30 Closing remarks

SQL Change Tracking - From Setup to ETL with SSIS
A common business need to is have data from operational systems moved to a reporting database, data warehouse, or data mart. To make load time fast it is helpful to have values in the source system rows to indicate the order of row inserts and updates. It is also nice to have a way to tell when a row was deleted. Unfortunately, there are too many applications and databases that do not implement this basic best practice. SQL Server Change Tracking to the rescue!

SQL Server Change Tracking was introduced with SQL Server 2008 and provides a lightweight solution to this problem. This presentation will show you everything you need to know to start using SQL Server Change Tracking in a database and how to use it with SSIS.

Read More

SQL Change Tracking - From Setup to ETL with SSIS - Article Rating

 6:00 – 6:30 Pizza and Networking sponsored by FGP

6:30 – 6:40 Announcements
6:40 – 7:00 Clif's Corner: PowerShell 101 - Getting Started
7:00 – 8:15 Paul S. Waters: SQL Change Tracking - From Setup to ETL with SSIS
8:15 – 8:30 Closing remarks

SQL Change Tracking - From Setup to ETL with SSIS
A common business need to is have data from operational systems moved to a reporting database, data warehouse, or data mart. To make load time fast it is helpful to have values in the source system rows to indicate the order of row inserts and updates. It is also nice to have a way to tell when a row was deleted. Unfortunately, there are too many applications and databases that do not implement this basic best practice. SQL Server Change Tracking to the rescue!

SQL Server Change Tracking was introduced with SQL Server 2008 and provides a lightweight solution to this problem. This presentation will show you everything you need to know to start using SQL Server Change Tracking in a database and how to use it with SSIS.

Read More

SQL Change Tracking - From Setup to ETL with SSIS - Article Rating

 Tuesday, August 6, 2013 

6:00 – 6:30 Pizza and Networking sponsored by FGP
6:30 – 6:40 Announcements
6:40 – 7:00 Clif's Corner: PowerShell 101 - Getting Started
7:00 – 8:15 Paul S. Waters: SQL Change Tracking - From Setup to ETL with SSIS
8:15 – 8:30 Closing remarks

SQL Change Tracking - From Setup to ETL with SSIS
A common business need to is have data from operational systems moved to a reporting database, data warehouse, or data mart. To make load time fast it is helpful to have values in the source system rows to indicate the order of row inserts and updates. It is also nice to have a way to tell when a row was deleted. Unfortunately, there are too many applications and databases that do not implement this basic best practice. SQL Server Change Tracking to the rescue!

SQL Server Change Tracking was introduced with SQL Server 2008 and provides a lightweight solution to this problem. This presentation will show you everything you need to know to start using SQL Server Change Tracking in a database and how to use it with SSIS.

Read More

SQL Change Tracking - From Setup to ETL with SSIS - Article Rating

 Tuesday, August 6, 2013 

6:00 – 6:30 Pizza and Networking sponsored by FGP
6:30 – 6:40 Announcements
6:40 – 7:00 Clif's Corner: PowerShell 101 - Getting Started
7:00 – 8:15 Paul S. Waters: SQL Change Tracking - From Setup to ETL with SSIS
8:15 – 8:30 Closing remarks

SQL Change Tracking - From Setup to ETL with SSIS
A common business need to is have data from operational systems moved to a reporting database, data warehouse, or data mart. To make load time fast it is helpful to have values in the source system rows to indicate the order of row inserts and updates. It is also nice to have a way to tell when a row was deleted. Unfortunately, there are too many applications and databases that do not implement this basic best practice. SQL Server Change Tracking to the rescue!

SQL Server Change Tracking was introduced with SQL Server 2008 and provides a lightweight solution to this problem. This presentation will show you everything you need to know to start using SQL Server Change Tracking in a database and how to use it with SSIS.

Read More

Simplifying SQL Development with Red Gate - Article Rating

6:00 – 6:30 Pizza and Networking sponsored by Red Gate.
6:30 – 6:40 Announcements
6:40 – 7:00 Clif Dunaway: Getting Started with PowerShell
7:00 – 8:15 Stuart Ainsworth: Simplifying SQL Development with Red Gate
8:15 – 8:30 Closing remarks and give-a-ways

Simplifying SQL Development with Red Gate
This presentation will be an interactive overview of some of the key products in the Red Gate Developer's Toolbelt for SQL Server: SQL Search, SQL Prompt, SQL Compare, Data Compare, and SQL Source Control. The goal is to examine some basic approaches to common SQL development problems.

About Stuart Ainsworth
Stuart Ainsworth (MA, MEd) is a manager working in the realm of financial information security. Over the past 15 years, he's worked as a research analyst, a report writer, a DBA, a programmer, and a public speaking professor. In his current role, he's responsible for the maintenance of a data analysis operation that processes several hundred million rows of data per day.

Read More

Index Tuning for the DBA - Article Rating

Event Date: 2013-05-07
Please Register at http://ssig201305.eventbrite.com/

 

6:00 – 6:30 Pizza and Networking
6:30 – 6:40 Announcements
6:40 – 8:15 Ben DeBow: Index Tuning for the DBA
8:15 – 8:30 Closing remarks and give-a-ways.

Index Tuning for the DBA
Indexes are like a turbocharger for your queries: they help the engine process queries faster. Without having the right index strategy, you will be stuck managing a SQL Server environment that end users may constantly complain is “too slow.” How do you avoid that situation by knowing which indexes to add or which ones to remove if they are not working—especially if you are not intimate with a particular application’s database? Knowing fundamentals such as baselining performance and proactively monitoring performance are crucial for long-term index maintenance. This session will give you those fundamentals and more to enable you to implement a solid index tuning strategy for your company’s applications.

About Ben DeBow
Ben DeBow is a consultant who works with customers of all sizes on their mission-critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt.

Ben also helps raise money for the Cystic Fibrosis Foundation by participating in the Xtreme Hike for the Cure. To learn how you can help Ben help others, please click this link http://www.cff.org/LWC/BenDebow15842 .

Read More

What is a Business Intelligence (BI) DBA? - Article Rating

6:00 – 6:30 Food and Networking - Sponsored by Godshall

6:30 – 6:40 Announcements

6:40 – 7:00 Clif: A DBA Discussion 

7:00 – 8:15 Jorge Segarra: What is a Business Intelligence (BI) DBA? 

8:15 – 8:30 Closing remarks and give-a-ways.

 

What is a Business Intelligence (BI) DBA?

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out! 

 

About Jorge 
Jorge Segarra (aka SQLChicken) is an author, blogger, speaker, SQL Server MVP and community volunteer currently working as a DBA/BI Consultant for Pragmatic Works. Jorge has co-authored on several books including "SQL Server 2012 Bible" and “SQL 2008 Pro Policy-Based Management“. He was also a Redgate Exceptional DBA of the Year 2010 Finalist.
 

Clif Dunaway: A DBA Discussion

Clif will facilitate a discussion on some DBA topics of interest.  Such as storage, virtual servers vs physical, high availability, security and backup strategies, or other topics suggested from the meeting attendees. 

 

Read More

What is a Business Intelligence (BI) DBA? - Article Rating

6:00 – 6:30 Food and Networking - Sponsored by Godshall

6:30 – 6:40 Announcements

6:40 – 7:00 Clif: A DBA Discussion 

7:00 – 8:15 Jorge Segarra: What is a Business Intelligence (BI) DBA? 

8:15 – 8:30 Closing remarks and give-a-ways.

 

What is a Business Intelligence (BI) DBA?

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out! 

 

About Jorge 
Jorge Segarra (aka SQLChicken) is an author, blogger, speaker, SQL Server MVP and community volunteer currently working as a DBA/BI Consultant for Pragmatic Works. Jorge has co-authored on several books including "SQL Server 2012 Bible" and “SQL 2008 Pro Policy-Based Management“. He was also a Redgate Exceptional DBA of the Year 2010 Finalist.
 

Clif Dunaway: A DBA Discussion

Clif will facilitate a discussion on some DBA topics of interest.  Such as storage, virtual servers vs physical, high availability, security and backup strategies, or other topics suggested from the meeting attendees. 

 

Read More

A SQL Server Trifecta - Article Rating

Event Date: 2012-03-05

 

6:00 – 6:30 Food and Networking - Sponsored by RHI
6:30 – 6:45 Announcements
6:45 – 7:15 Lee Lee Johnson The XML Data Type
7:15 – 7:45 Clif Dunaway: How I manage over 2000 databases
7:45 – 8:15 Paul S. Waters: The T-SQL Merge Statement
8:15 – 8:30 Closing remarks and give-a-ways.

Lee Johnson: The XML Data Type

Have you ever wanted to send a list as a parameter to a stored procedure similar to the way some programming languages can send an array? Have you ever wanted to combine elements from a related table showing up as a single field in a select statement? I will show how to use XML to solve these problems along with other uses for XML data types. What used to take difficult solutions can now be accomplished very easily by using the XML functionality in SQL Server. 

 

Clif Dunaway: How I manage over 2000 databases

My daily duties consist s of managing 6 clusters, 13 SQL Instances, 18 servers and 2043 databases. In this presentation I will show you how I do it.

 

Paul S. Waters: The T-SQL Merge Statement

The T-SQL Merge statement can both insert and update data at the same time. It is a handy statement to know. In this presentation, we are going to start from the beginning and construct a basic, yet powerful merge statement.

Read More

Hacking the SSIS 2012 Catalog - Article Rating

Event Date: 2012-02-05

 

Hacking the SSIS 2012 Catalog

Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how! 

 

About Andy
Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.
Read More

SQL Social at Bailey's Pub & Grille - Article Rating

Event Date: 2012-12-04

Instead of our regular meeting, lets get together at Bailey's Pub & Grille and have some fun. Also, the GSP Developer's Guild will be joining us. 

Starts at 6:30ish and ends at whenever.  You will be responsible for paying for all or most of what you eat and drink.

SQL Social at Bailey's Pub & Grille - Article Rating

Event Date: 2012-12-04

Instead of our regular meeting, lets get together at Bailey's Pub & Grille and have some fun. Also, the GSP Developer's Guild will be joining us.  


Starts at 6:30ish and ends at whenever.  You will be responsible for paying for all or most of what you eat and drink.

Data Quality Services --Finally! - Article Rating

 Event Date: 2012-10-02

Data Quality Services --Finally!

Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create Data Cleansing Knowledge Bases to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Knowledge Bases can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together. 

 

Julie Smith has spent the last 12 years moving data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is an MCTS in SQL Server 2008 BI.   She is a Business Intelligence Consultant at Innovative Architects.  Prior to Innovative Architects,  she worked as a database developer at Key2 Consulting and  the Network Inc.   She is one of the co-founders of the The Cloverleaf School of Atlanta, which educates elementary aged children with ADHD, High Functioning Autism and other learning differences.  She remains “very simple woman with warm fuzzy secret heart.”
Read More

Waiter, There's a Fly in My Data - Article Rating

Please register at http://ssig201209.eventbrite.com/

September 4th, 2012
6:00 – 6:30 Food and Networking
6:30 – 6:45 Announcements
6:45 – 8:15 Rafael Salas : Waiter, There's a Fly in My Data
8:15 – 8:30 Closing remarks and give-a-ways.

Waiter, There's a Fly in My Data
Dealing with bad data is a painful and expensive experience. In this session, we'll explore the main causes of bad data and lay out key data-quality concepts that will help us better understand just how costly data-quality issues can be. Then we'll jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with SQL Server Data Quality Services (DQS) and Integration Services (SSIS).

We'll dive into the DQS knowledge-driven approach, reusability, cleansing, and matching and explore the opportunities for collaboration between data stewards and IT professionals. You'll see how to create a Knowledge Base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.

Rafael Salas is a recognized speaker, published author, and blogger with more than a decade of IT experience across multiple industries. He specializes in Business Intelligence and Information Architecture and is the recipient of multiple industry recognitions, including the Microsoft MVP award and The Data Warehouse Institute best practices award. His areas of expertise include data integration and data quality, data warehouse architecture, data analytics, data modeling, and data visualization. Rafael is also an active member of the SQL Server technical community and maintains a blog at www.rafael-salas.com.

Read More

Melissa Coates: Managed Self Service BI - Article Rating

Please register at http://ssig201208.eventbrite.com/

We have SWAG and a software license from Red Gate to give away.

August 7, 2012
6:00 – 6:30 Food and Networking Sponsored by FGP
6:30 – 6:45 Announcements
6:45 – 8:15 Melissa Coates : Managed Self Service BI
8:15 – 8:30 Closing remarks and give-a-ways.

Managed Self Service BI
You know BI. Right? Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed? Empowering knowledge workers is Microsoft's vision of delivering "BI for the Masses." In this session we will dismiss the hype & examine how "Managed Self-Service BI" complements Corporate BI in SQL Server 2012 and SharePoint 2010. Goals: (1) Provide overview & demonstrate Self-Service components. (2) Discuss & demonstrate techniques to monitor, manage, & secure the Self-Service BI environment.

Melissa Coates is a Business Intelligence developer in Charlotte, NC. As a Senior Consultant with Intellinet, she specializes in delivering BI and Data Warehousing solutions. Melissa has more than 10 years of experience as a hands-on developer with various reporting and analysis tools. She now works exclusively with Microsoft BI.

Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a really beneficial blend of technical, business, and training skills. She has a keen interest in visualization techniques and repeatable best practices. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com.

Read More

Shiny New T-SQL for SQL Server 2012 - Article Rating

June 5th, 2012
Please register at http://ssig201206.eventbrite.com/

Audrey Hammonds: Shiny New T-SQL for SQL Server 2012
There has been a lot of fanfare for some of the new features of SQL Server 2012. (AlwaysOn and T-SQL Windowing, I’m looking at you.) But there are a few other shiny little gems hidden between the replicas and frame clauses. The good folks at Microsoft have given T-SQL a few new features and functions, and it’s time to dig in and take a look at what presents they’ve brought us. T-SQL enhancements for 2012, including Result Sets, paging support, metadata discovery, new scalar functions, and the THROW clause for error handling are demonstrated in this session. Shiny!
 

Read More

Surviving Your Peak Database Load - Article Rating

Please register at http://ssig201205.eventbrite.com/

Pizza and Networking Sponsored by RHI.

Ben DeBow from SQLHA is Presenting:

Surviving Your Peak Database Load
Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these timeframes is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.

Read More

Hot topics at SQLBits X in London - Article Rating

Date: April 3, 2012
Sponsor: FGP

Last week, I was at SQLBits X in London, England for the launch of SQL Server 2012. In addition to some of the incredible new features in SQL Server 2012, there were also some other standouts, such as the latest version of BIDS Helper and discussions involving life cycle management best practices for database administration and development. The best practices reflect the trends that have been evolving in application development life cycle management such as version control, continuous integration, agile project management, geographically dispersed teams, etc. The format for this meeting will be to stimulate group discussion about the above-mentioned topics, as well as others. Feel free to bring your own topics to the discussion.

Paul S. Waters

Read More

Meeting: Basics of Very Large DataBases (VLDB's) - Article Rating

Speaker:  Stuart R Ainsworth

Most database professionals know (from firsthand experience) that there continues to be a "data explosion". Databases are getting larger, and working with Very Large DataBases (VLDB's) is becoming more commonplace. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of VLDB's.
Special attention will be paid to the following areas:
* query design
* logical and physical data structures
* maintenance & backup strategies

 

Read More

SQL Tools, Tips and Tricks - Article Rating

 

Read More

SQL Tools, Tips and Tricks - Article Rating

 

Read More

SQL Tools, Tips and Tricks - Article Rating

 

Read More

 Announcements

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
 Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

Red gate