Transcript sql server stuff – work on laptop?

SQL Server User Group
September 25, 2014
SQL Server User Group Direction
Where we came from
Where we are going.......
What is tonight’s topic about???
• The time has come for change
• Lots of questions.......
– Who will run the group – Joshua, me,
management group
– All the rest stays the same, soggy pizza, 4th
Thursday of the month, and here at Quickstart
http://www.quickstart.com/ (Sql Soft)
– Same meeting format but looking at expanded
range of topics – all still centered on SQL
Server.
Expansion of Subjects?
Presentations?
Who – how – what?
• PASS 2014 Tracks
– Application & Database Development
– BI Information Delivery
– BI Platform Architecture, Development &
Administration
– Enterprise Database Administration &
Deployment
– Professional Development
More Who – how – what?
• From the 90’s – VB app to SQL Server 6.0
to
• Now - .net app-aspx/web site server/dynamic
delivery-store data as chunks/java/html/3rd party
tool for web page creation/OLTP dbases - DSS
dbases - OLAP (analysis services) - Operational
Data Stores/SSIS-streaming/Data Feeds to from
server - Big Data-Data Warehouse-Excel-AccessText Files-Master Data-Other dbases (Oracle,
Teradata, etc); Reporting Servicesdashboards/Email/Batch Jobs/Internal Search
Engines/Localization servers/a million 3rd party
tools
Pictures
• 90’s architecture
– basic client server with maybe a web server
• 2003 architecture
– Sql Server, DTS, Web server, App Server, Web site, Data Warehouse
• last 8 years architecture
– several databases on multiple servers, with web sites, search engines, .NET
apps, 3rd party tools, excel spreadsheets, text files, jobs, SSIS packages, data
feeds, big data, RSS feeds, and on and on.
• future ????
Jobs/Roles Responsibilities
count of meeting participants in those roles – 2 role per participant
• Title depends on the company – each seems to have
their own definition and some just call all of it DBA.
To me jobs are:
•
•
•
•
•
•
•
DBA – keeps the machines running - 7
Data Architect - 1
System Architect - 3
Developer - 4
Business Analyst - 3
Data Analyst - 5
Business Intelligence -1 - architect, analyst,
developer
• ETL specialist - 4
• GIS Specialist - 1
• DW analyst - 1
Resources
• Books – Love the in depth Microsoft Press
Books
• School – College, Tech Schools like
Quickstart http://www.quickstart.com/
Pluralsight
http://www.pluralsight.com/training
• PASS – 2014 will be in Seattle
• Google – web searches
• User groups – this group 20 years in Dec.
How can this user group support
you and stay relevant?
• Joshua will take over from here but first –
Who going to PASS????? Want to do a group
dinner?
• Thanks all
• chris will now type 
next -requested presentation topics (page 1)
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
rule: 1. presentations by only technical people – no sales people – vendors PASS videos
rule: 2. PASS videos - select good ones in lieu of a live presentation
grp
keyword
topic
all presentations resource lists
resources of info..... presentation on resources
arch system
arch - sql
sql is only one of servers in the system – ex sql, mongo,
MySql, hadoop, teradata, oracle, sybase, cloud, db2, unix,
arch system
arch - other dbases
what other dbase platforms are and how they compare to
sql
bi
ETL, ssis, ssas, ssrs ETL – ssis, ssas --- business analytics other tools,
bi
ETL, ssis, ssas, ssrs other features of sql olap/analysis services, ssis,
reporting services,
bi
ssrs - reports
BI --- reporting
bi
ssrs, ssis, big data
SSRS (DBA bits), SSIS, Big Data on sql server: hardware,
performance, what size table can sql server handle?
bi
ssrs, ssis, user data have lots of data but no way to get it back out to folks –
like reports or data marts
bi
ssrs, ssis, user data quick and dirty ways to get data out for folks
data
big data, dev
development stuff -- how to code, 2.7 billion rows in big tbl
data
big datasets, big data sql "big data" - Joshua - 3 billion rows. Charles - 1.5 million
rows
data
big datasets, ETL
data efficiency in ETL process in big datasets
data
big datasets, indexes indexes on big datasets on sql server, datasets – partitions
next -- requested presentation topics (page 2)
•
•
grp
dba
keyword
management
•
dba
management - sys
•
•
dba
dba
management - sys
perf monitoring
•
•
dba
dba
replication
sql monitoring
•
•
•
dba
dba-dev
dba-dev
virtual servers
no no's
pwrshell-mgmt
•
dba-dev
security
•
•
•
•
dba-dev
dba-dev
dba-dev
dba-dev-arch
spatial indexes
sql server 2014
third party tools
scalability
•
dba-dev-arch
scalability
topic
drive alignmt fusion io - kendra - drive alignment on
hardware - tim ford articles and blog
environments – how to create a new environment, how
to stop a dev environment from becoming production.
how do people handle ad hoc qry,
performance monitoring and hardware for stuff like
tempdb, solid stated drive
replication - charles & andrew
sql monitoring tools – tools with good reviews – idera –
mark, sql sentry, redgate, quest – dell,
virtual servers vs physical boxes
no no's of sql server
powershell – managing other sql servers, sharepoint
clusters, --- Tim --security and encryption – how to manage client/server
sides – performance, security, keys, certs.
GIS and sql - Andrew -- Bob indexes in spatial
what is coming after sql 2008 - what is in sql 2014
third party tools - how to administer sql with ....
data scalability --- what app/software does what –
Jeremiah Peschka – PASS virtual chapter presentation
monitoring - how to scale up to monitor multiple
servers – mark – dashboard.
next -- requested presentation topics (page 3)
•
•
keyword
dbase connections
•
•
grp
dev
now
app
dev
prof dev
•
prof dev
mentoring - outreach
•
•
•
•
prof dev
prof dev
prof dev
prof dev
mentoring - outreach
mentoring - outreach
mentoring - outreach
mentoring - outreach
•
SSUG PASS, Microsoft, vendors
file streaming
certifications
topic
Developer – how you access sql server from an application
– current best practices for pulling/sending data from sql to
-- plus sending from app to sql
file streaming
certifications -- what are they and how to get them -- do
along with resources presentation
next gen of database programmers - admins -- how to learn
this stuff.....
how to get new folks into this field or into this group
mentoring people as a group
how to advertise this group -- how to get the word out?
twitter or facebook - charles set up and manage linked in....
twitter
look at relationship with PASS or Microsoft ---- chris joshua