dba delta force
DESCRIPTION
DBA Delta Force. SQL Server 2012 features for the DBA. Agenda. About me Discontinued and Deprecated features in SQL Server 2012 New features to be aware of ColumnStore Indexes Thanks. Gareth Swanepoel From South Africa, originally Been in IT for 20+ years - PowerPoint PPT PresentationTRANSCRIPT
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
DBA Delta ForceSQL Server 2012 features for the DBA
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
AgendaAbout me
Discontinued and Deprecated features in SQL Server 2012
New features to be aware of
ColumnStore Indexes
Thanks
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Gareth Swanepoel
From South Africa, originally
Been in IT for 20+ years
Was first a sysadmin, then a DBA
DBA Consultant with Pragmatic Works
Currently authoring 3 chapters in the upcoming SQL Server 2012 Pro Admin book
eMail : [email protected]
Twitter : @GarethSwan
Website : www.MyGareth.com
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Discontinued &Deprecated features
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Discontinued featuresBACKUP DATABASE WITH [MEDIA]PASSWORDCompatibility version 80 (SQL 2000)VIA connection protocolSQL Mail, Net Send & pager notificationsAll 32-bit support (AWE, etc.)SQL Server Distributed Management Objects (SQL-DMO)
Reference: http://technet.microsoft.com/en-us/library/ms144262(v=SQL.110).aspx
Features not available in SQL Server 2012
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Deprecated featuresCompatibility version 90 (SQL 2005)Remote serversAbility to return result sets from triggersBACKUP {DATABASE | LOG} TO TAPESQL Server Profiler
Reference: http://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx
Features not available in the next and future versions of SQL Server
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
New & improved featuresExtended Events – New Session Wizard & Session UIContained database authenticationCustom (user-defined) database rolesAuditing enhancementsAlwaysOnFileTable and Full-text Semantic SearchT-SQL enhancements
Features that DBA's care about that will kick butt in SQL Server 2012
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
ColumnStore IndexesColumnStore Indexes – the basics
The Fangorn Forest: Home of the Ents
ProductID OrderDate Cost
310 20010701 2171.29
311 20010701 1912.15
312 20010702 2171.29
313 20010702 413.14
data page1000
Row Store (Heap / B-Tree)
ProductID
310
311
312
313
data page2010
OrderDate
20010701
20010701
20010702
20010702
data page2000
data page2040
Cost
2171.29
1912.15
2171.29
413.14
Column Store (values compressed)
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
ColumnStore IndexesKey Characteristics of CSI's
Columnar data formatFaster query resultsQuery processingTable cannot be updated
The Fangorn Forest: Home of the Ents
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
ColumnStore Indexes
DEMO
The Fangorn Forest: Home of the Ents
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
ColumnStore IndexesBest Practices
Choosing ColumnsDO … put CSI's on large tables onlyDO … structure queries as star-joinsDON'T … use OUTER JOINDON'T … use UNION ALLDON'T … use string filters, etcDON'T … use NOT IN (<subquery>)
The Fangorn Forest: Home of the Ents
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
ServicesSpeed development through training and rapid development services from
Pragmatic Works.
ProductsBI products to convert to a Microsoft BI platform and simplify development on
the platform.
FoundationHelping those who do not have the
means to get into information technology and to achieve their dreams.
eMail : [email protected]
Twitter : @GarethSwan
Website : www.MyGareth.com
Sales : [email protected]