March 2015
PASS Community News
Want to upskill & grow your knowledge in the data world?
Ready to learn from the world’s top analytics experts in over 60 sessions?
Use discount code
LABA13
for
$150
off registration
Share with your friends & colleagues!
The discount code cannot be combined with other BA Conference discount & cannot be used retroactively.
passbaconference.com
REGISTER TODAY
Select Virtual Chapter Meetings
VIRTUAL CHAPTER MEETING TOPIC
DBA Fundamentals Mar 3 11:00-12:00 (GMT-06:00) I’ve Got a SQL Database, Now What? presented by Denny Cherry
Global Spanish Mar 4 12:00-13:00 (GMT-05:00) SQL Server 2014 Delayed Durability visto desde una aplicatiόn presented by
Alejandro Cordero
Data Science Mar 6 13:00-14:00 (GMT-08:00) Introduction to R and Statistics for the Rookie – 5 week series, Part 3 presented by Jen Stirrup
High Availability &
Disaster Recovery Mar 10 12:00-13:00 (GMT-06:00) How to Configure Quorum in SQL Server presented by Kendra Little Virtualization Mar 11 12:00-13:00 (GMT-05:00) Benefits of Cisco Unified Computing System
for Consolidated SQL Server Workloads presented by Frank Cicalese
Professional
Development Mar 11 17:00-16:30 (GMT 00:00) Presentation Design. Why you should care? DBA Fundamentals Mar 17 11:00-12:00 (GMT 00:00) Building the Right Back-up Strategy
Upcoming SQLSaturdays
North America
International
•
Mar 21 #381 Richmond
•
Mar 28 #375 Silicon Valley
•
Apr 11 #387
Madison
•
Apr 11 #389
Huntington Beach
•
Apr 18 #364
Boston
•
Apr 25 #366
Ottawa
•
Mar 28 #382
Brisbane
•
Apr 18 #376
Budapest
•
Apr 18 #368
Costa Rica
•
Apr 25 #372
Exeter
•
Apr 25 #361
Joinville
Visit
www.sqlsaturday.com
to
register for a event near you!
7
Volunteering Opportunities
PASS would not exist without passionate, dedicated,
and hardworking volunteers from around the globe.
Volunteer today!!
For local opportunities please visit
volunteer.sqlpass.org
For PASS HQ related activities, please update the
Oct 26-30, 2015
Seattle, WA
Stay Involved!
•
Sign up for a free membership today at sqlpass.org
•
LinkedIn: Professional Association for SQL Server
•
Facebook: Professional Association for SQL Server Group
•
Twitter:
@SQLPASS
OPASS
Last Thursday of Each Month
6:30 PM
Cork and Olive
1061 South Sun Drive Ste. 1009 Lake Mary
Performance Troubleshooting
Using Wait Statistics
Paul Randal
Orlando .NET User Group
March 28, 2015
Seminole State College
Sanford, FL
Orlando .NET Code Camp 2015
SQLSaturday Jacksonville
Saturday, Feb 28, 2015
University of North Florida
Jacksonville, FL
40+ Sessions
Certifications – Second Shot
Retake any exam you don’t pass the first time, at no extra cost.
•
Register for an exam until May 31, 2015
•
1 Free retake if you don’t pass on 1
stattempt
•
Retake must be taken within 30 days
• All of the Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions
Expert (MCSE), Microsoft Certified Solutions Developer (MCSD), and Microsoft Specialist
certification exams are eligible
• Microsoft Technology Associate (MTA) exams and Microsoft Office Specialist (MOS) exams
do not qualify for this promotion
SQL Server Updates
•
Cumulative Updates
•
CU #6 for SQL Server 2014 RTM (Feb 16)
•
CU #15 for SQL Server 2012 SP1 (Mar 16)
•
CU #5 for SQL Server 2012 SP2 (Mar 16)
•
SQL 2008/2008 R2 End Of Life
•
Mainstream Support Ended July 8
•
Extended Support Ends July 9, 2019
•
Final Service Packs released!
• SQL 2008 SP4 • SQL 2008 R2 SP3
•
Build Reference
•
Extend and enhance BI development functionality
•
Visual Studio add-in for Business Intelligence
Development Studio (BIDS) and Server Data Tools (SSDT)
•
Version 1.7.0 released Mar 17
2 3
• Aggregation Manager • Calculation Helpers • Column Usage Reports
• Delete Unused Aggregations • Delete Unused Indexes
• Deploy Aggregation Designs • Deploy MDX Script
• Deploy Perspectives
• Dimension Data Type Discrepancy Check • Dimension Health Check
• Dimension Optimization Report • Duplicate Role
• Many-to-Many Matrix Compression • Measure Group Health Check
• Non-Default Properties Report • Parent-Child Dimension Naturalizer • Printer Friendly Aggregations
• Printer Friendly Dimension Usage • Roles Report
• Similar Aggregations • Smart Diff
• Show Extra Properties • Sync Descriptions
• Test Aggregation Performance • Tri-State Perspectives
• Update Estimated Counts • Validate Aggregations • Visualize Attribute Lattice
• Roles Report • Smart Diff
• Tabular Actions Editor • Tabular Display Folders • Tabular HideMemberIf • Tabular Pre-Build
• Tabular Sync Descriptions • Tabular Translations Editor
• Tabular Annotation Workaround • Unused Columns Report
• Batch Property Update • Biml Package Generator • Create Fixed Width Columns
• Deploy SSIS Packages • Design Warnings
• dtsConfig File Formatter
• Expression and Configuration Highlighter
• Expression List • Fix Relative Paths
• Non-Default Properties Report
• Pipeline Component Performance Breakdown
• Reset GUIDs • Smart Diff
• Sort Project Files
• Sortable Package Properties Report
• SSIS Performance Visualization • Variables Window Extensions
• Dataset Usage Reports • Delete Dataset Cache Files • Smart Diff
• Enable/Disable features • Preferences
• Version Notification
