Industries
| Industry |
Percentages |
Visitors |
|
Technology |
23% |
106950 |
|
Education/Non Profit |
12% |
55800 |
|
Manufacturing/Automotive
|
8% |
37200 |
|
Service Providers
|
8% |
37200 |
|
Healthcare |
7% |
32550 |
|
Financial |
7% |
32550 |
|
State/Local Government |
6% |
27900 |
|
Retail/Services |
6% |
27900 |
|
Insurance |
5% |
23250 |
|
Banking
|
4% |
18600 |
|
Media/Entertainment
|
3% |
13950 |
|
Federal Government
|
2% |
9300 |
|
Telecommunications |
2% |
9300 |
|
Legal/Accounting |
2% |
9300 |
|
Transportation/Logistics |
2% |
9300 |
|
Energy/Mining/Chemicals |
2% |
9300 |
|
Travel/Hospitality |
1% |
4650 |
|
Pharmaceuticals |
1% |
4650 |
|
Utilities
|
1% |
4650 |
|
Database Platforms
| Platform |
Percentages |
Visitors |
| MS SQL Server |
91% |
423150 |
| MS Access |
59% |
274350 |
| MS Excel |
49% |
227850 |
| Oracle |
38% |
176700 |
| MS SQL Server Express |
34% |
158100 |
| MySQL |
26% |
120900 |
| IBM DB2 |
14% |
65100 |
| Sybase |
10% |
46500 |
| DBase |
6% |
27900 |
| Pervasive SQL |
5% |
23250 |
| Informix |
4% |
18600 |
| PostgresSQL |
4% |
18600 |
| Teradata |
3% |
13950 |
| FileMaker |
3% |
13950 |
| Progress |
3% |
13950 |
| Clipper |
2% |
9300 |
| Paradox |
2% |
9300 |
| Centura |
1% |
4650 |
| Firebird |
1% |
4650 |
| Interbase |
1% |
4650 |
| SQLBase |
1% |
4650 |
| Other |
8% |
37200 |
|
Support Multiple Databases
|
|
Percentages |
Visitors |
|
Multiple |
62% |
288300 |
|
Single |
39% |
181350 |
|
SQL Server Version of Interest
|
Version
|
Percentages |
Visitors |
|
SQL Server 2005 |
93% |
432450 |
|
SQL Server 2008 |
54% |
251100 |
|
SQL Server Express |
36% |
167400 |
|
SQL Server 2000 |
32% |
148800 |
|
Members Database Experience
|
Experience
|
Percentages |
Visitors |
|
0-6 Mo's |
2% |
9300 |
|
6-12 Mo's |
1% |
4650 |
|
1-2 Years |
5% |
23250 |
|
2-5 Years |
14% |
65100 |
|
5+ Years |
79% |
367350 |
|
Member Expertise Level
|
Level
|
Percentages |
Visitors |
|
Beginner |
3% |
13950 |
|
Learning but Functional |
22% |
102300 |
|
Very Comfortable |
54% |
251100 |
|
Expert |
21% |
97650 |
|
Technologies Used
|
Technology |
Percentages |
Visitors |
|
T-SQL |
79% |
367350 |
|
.NET |
69% |
320850 |
|
ODBC |
60% |
279000 |
|
ADO/ADO.NET |
51% |
237150 |
|
Visual Basic |
48% |
223200 |
|
OLEDB |
41% |
190650 |
|
ASP |
39% |
181350 |
|
BI Native Server Tools |
38% |
176700 |
|
Javascript |
33% |
153450 |
|
BI 3rd Party Tools |
27% |
125550 |
|
AJAX (incl 3rd Party Tools) |
25% |
116250 |
|
PL/SQL |
22% |
102300 |
|
Java |
17% |
79050 |
|
ANSI SQL |
16% |
74400 |
|
C++ |
13% |
60450 |
|
PHP |
11% |
51150 |
|
|
Primary Job Functions
| Job Function |
Percentages |
Visitors |
| Developer |
33% |
153450 |
| SQL Server DBA |
28% |
130200 |
| Other/IT Professional |
12% |
55800 |
| IT Executive |
7% |
32550 |
| Consultant/Reseller/Integrator |
7% |
32550 |
| Systems Administrator |
5% |
23250 |
| Other/Multi Vendor DBA |
4% |
18600 |
| Other/Non IT Professional |
3% |
13950 |
| Oracle DBA |
2% |
9300 |
|
Additional Job Functions
| SQL Server DBA |
57% |
265050 |
| Developer |
55% |
255750 |
| Systems Administrator |
34% |
158100 |
| Consultant/Reseller/Integrator |
21% |
97650 |
| IT Executive |
14% |
65100 |
| Other/Multi Vendor DBA |
13% |
60450 |
| Oracle DBA |
12% |
55800 |
| Other/Non IT Professional |
10% |
46500 |
| DB2 DBA |
2% |
9300 |
|
Database Pain Points
| Pain Point |
Percentages |
Visitors |
| Building Packages with SSIS |
48% |
223200 |
| Disaster Recovery |
45% |
209250 |
| Security - Intrusion Protection |
41% |
190650 |
| Backup and Recovery Steup/Test |
38% |
176700 |
| Replication |
35% |
162750 |
| Data Management/Upgrading/Moving DB |
30% |
139500 |
| Install to Live With SQL Server |
28% |
130200 |
| Full Text Indexing |
23% |
106950 |
| Building DTS Packages |
20% |
93000 |
| Managing Staff |
13% |
60450 |
|
Geographical Locations - Headquarters
| Location |
Percentages |
Visitors |
| North America |
85% |
395250 |
| Europe |
8% |
37200 |
| Asia |
3% |
13950 |
|
Australia |
2% |
9300 |
| South America |
1% |
4650 |
|
Oceania |
1% |
4650 |
|
Offices in Other Geographical Locations
|
Location |
Percentages |
Visitors |
|
North America
|
90% |
418500 |
|
Europe |
42% |
195300 |
|
Asia |
33% |
153450 |
|
Australia |
23% |
106950 |
|
South America
|
22% |
102300 |
|
Africa |
13% |
60450 |
|
Oceania |
11% |
51150 |
|
Other |
5% |
20250 |
|
Number of Employees
| Number |
Percentages |
Visitors |
| 1 |
3% |
13950 |
| 2-10 |
13% |
60450x |
| 11-50 |
10% |
46500 |
| 51-100 |
8% |
37200x |
| 101-250 |
10% |
46500 |
| 251-500 |
13% |
60450 |
| 501-1,000 |
7% |
32550 |
| 1,000 + |
37% |
172050 |
|
Number of SQL Servers in Company
| Number |
Percentages |
Visitors |
| 1 |
6% |
27900 |
| 2-5 |
21% |
97650 |
| 5-10 |
21% |
97650 |
| 11-20 |
16% |
74400 |
| 21-50 |
14% |
65100 |
| 50+ |
22% |
102300 |
|
Number SQL Server Express Instances
| Number |
Percentages |
Visitors |
| 0 |
52% |
241800 |
| 1 |
8% |
37200 |
| 2-10 |
21% |
97650 |
| 11-20 |
10% |
46500 |
| 20+ |
10% |
46500 |
|
Participation in Training
| Participate |
Percentages |
Visitors |
| Yes |
56% |
260400 |
| No |
45% |
209250 |
|
Searches On SSWUG
|
Time Period |
|
Searches |
|
Annual
|
|
5,000,000+ |
|
Month |
|
416,666 |
|
Day |
|
13,698 |
|
|