SQL Server 2014 In-Memory

April 1, 2014 – SQL Server 2014 with built-in in-memory technology can accelerate your business and enable new scenarios that make you more competitive. Here are some key things you should know about in-memory technology in SQL Server 2014 and how it can benefit your organization.

    • It’s built-in.
      • If you know SQL, you know how to use our in-memory technology.
      • It’s not a separate database product, and there are no new APIs to learn.
      • You can take advantage of other powerful SQL Server features such as AlwaysOn as well as in-memory capabilities.
      • You don’t need to buy multiple product SKUs – the SQL Server 2014 Enterprise SKU gives you in-memory capabilities across OLTP, DW, and analytics.
    • It’s flexible – run in-memory tables alongside traditional tables on disk.
      • We don’t believe having to load the entire database into memory is an optimal architecture, as putting cold data into memory doesn’t help. SQL Server 2014 allows you to select the most utilized tables and have them reside in memory.  This means you can significantly improve your transactional performance without having to refresh hardware.
      • We even provide tools built right into SSMS that let you know the optimal tables and stored procedures to migrate to memory.
      • You can query both traditional on-disk tables and in-memory tables through a single query.
    • It’s pervasive across all SQL Server workloads.
      • SQL Server 2014 is the third release of our in-memory technology, which started back in SQL Server 2008 R2 with in-memory analytics. Then in SQL Server 2012, we added in-memory capabilities for data warehousing with an in-memory ColumnStore. Now with SQL Server 2014, you also have in-memory OLTP and an enhanced in-memory ColumnStore that is now updatable and offers much higher data compression.
      • This means we can uniquely speed your transactions, queries, and analytics.
    • It lets you remove database contention and utilize CPU and Core capacity.
      • SQL Server 2014 has a unique in-memory OLTP design point of removing contention in the database by removing locks and latches and still ensuring 100% durability. You can learn more about this unique architecture by watching David DeWitt’s PASS Summit 2013 keynote.
      • This means much higher throughput and speed of transactions as well as much lower latency. You can now harness the full power of your CPUs.

 

SQL Server 2014 provides breakthrough performance for all your mission-critical workloads. If you haven’t already, please download the evaluation copy of SQL Server 2014 and see for yourself the performance gains that in-memory technology provides for your applications. If you want to dev/test SQL Server 2014 quickly and efficiently, you can spin up an image of SQL Server 2014 in minutes in a Microsoft Azure Virtual Machine.

SQL Server 2014 Mission Critical

March 18, 2014 – Running SQL Server 2014 – with built-in in-memory technology to speed up transactions, queries, and analytics – on Windows Server 2012 R2 can provide key capabilities for your mission-critical applications.

    • Breakthrough performance with in-memory built in.
      • SQL Server 2014 has in-memory technology built in to the data platform that can significantly speed transactions, queries, and analytics.
      • Windows Server 2012 R2 can provide massive compute and memory in both physical and virtual environments so you can take full advantage of SQL Server in-memory technology. Windows Server 2012 R2 provides 640LPs with up to 4TB of memory in a physical environment and 64vCPUs and up to 1TB of memory per VM in a virtual environment.
    • SQL Server 2014 provides the 9’s of availability you need with AlwaysOn.
      • SQL Server 2014 AlwaysOn technology can provide synchronous replication for zero transaction loss and asynchronous replication for disaster recovery solutions. You can now have up to eight readable secondaries and the option to place the secondaries in Azure Virtual Machines for fast and cost-effective cloud disaster recovery.
      • For SQL Server instances running in a physical environment, you can use Windows Server 2012 R2 Failover Clustering to provide server-level high availability and disaster recovery. If you are running SQL Server instances in a virtual environment, you can use Windows Server 2012 R2 Failover Clustering and Windows Azure Hyper-V Recovery Manager to provide both local and geographical business continuity and disaster recovery.
    • SQL Server is the least vulnerable database the last 5 years in a row*.
      • Least vulnerable means the least number of security patches you have to implement, which means less downtime.
    • SQL Server offers Premier Mission Critical support for your most critical database applications.
      • Get solution validation, architectural reviews, on-site engineering, and fastest response times available from Microsoft with Premier Mission Critical support.

Download this datasheet to learn more about SQL Server 2014’s mission-critical features.

*  National Institute of Standards and Technology Comprehensive Vulnerability Test Database, 4/17/2013.


 



FY2015 Chapter Goals: Supporting Local Data Communities

March 18, 2014  There’s nothing like nurturing in-person relationships with folks who share the same passion as you do. And our 291 grassroots Chapters located around the globe are doing PASS proud by enabling local networking and shared learning with data professionals living and working in the same area.

This is my second year as Director of PASS Chapters, and while we’ve accomplished much this past year, I’m already looking forward to where we need to focus our time and energy in fiscal year 2015 (FY2015).  Here are the Chapter Portfolio goals we’re proposing to support and grow local data communities:

    • Enable Chapters to access more content on a variety of topics, including Cloud, Big Data, and Business Analytics.
    • Continue to provide great benefits to Chapter Leaders, such as access to PASS content and events, in a fiscally responsible manner by establishing parameters for PASS event complimentary registration eligibility. These parameters will be managed via self-reporting tools for Chapters, available in early FY2015.
    • Help establish at least 10 new BI/BA-focused Chapters.
    • Look into setting up additional SQL Server-related Chapters in countries with no or very few Chapters, helping support increased knowledge sharing and learning in those communities.

If you have yet to connect with data peers in your area, I encourage you to look into joining – or starting – a PASS Chapter near you. And before I sign off, I’d like to extend a huge thank you to all the Chapter leaders who work tirelessly to share their passion for knowledge and the community. Please send your feedback on these goals to wendy.pastrick@sqlpass.org.
– Wendy Pastrick
Chapters Director, PASS Board


 


FY2015 Goals for PASS Virtual Chapters

March 18, 2014 – Participating in PASS Virtual Chapters (VCs) – which deliver free online training from leading data experts – is one of the easiest ways you can keep your skills and knowledge up-to-date and get involved in the community.

Serving close to 25,000 data professionals from around the world, our interest-based VCs provide technical content and networking year-round through live and recorded webinars. Whether you are a DBA, developer, BI or BA professional or looking to learn in your local language, there is a VC for you. We also have VCs focused on professional development and Women in Technology topics.

As co-leader of the BI VC, I know firsthand how much work goes into setting up virtual learning sessions – our VC leaders spend countless hours bringing great training directly to your computer.

Keeping both our leaders and our community of active participants in mind, we’ve put together the following VC goals for fiscal year 2015 (FY2015) and are working out the associated budget to support them:

    • Increase overall VC meeting attendance by 20%
    • Increase VC meeting attendance by 25% for the LATAM region
    • Deliver 16,000 technical training hours to the PASS community
    • Establish satisfaction benchmark metrics for VCs and solicit feedback for improvement and growth
    • Increase VC sponsorships to provide additional learning opportunities for VC participants

As I dig into my first term on the PASS Board of Directors, I’m delighted to represent and help grow our VCs serving the expanding data community. Feel free to contact me at jen.stirrup@sqlpass.org with ideas on growing and supporting these valuable online user groups.
– Jen Strirrup
Virtual Chapter Director, PASS Board


 


PASS Programs – FY2015 Portfolio Goals

February 18, 2014 – Behind PASS’s reputation for delivering incredible technical content stands dedicated Program Committee teams. PASS Programs encompasses PASS’s largest volunteer group – typically 60 or more team members involved in reviewing and selecting speakers and sessions for PASS Summit and the PASS Business Analytics  Conference, building guidelines and resources for creating top presentations, ensuring all PowerPoint slide decks meet the highest standards, and working to improve processes for developing and evaluating speakers and encouraging participation in all PASS speaking opportunities, including at local and Virtual Chapter meetings, SQLSaturday and SQLRally events, and 24 Hours of PASS.

PASS Programs are always in the spotlight, but especially so this time of year as we gear up for an exceptional lineup of speakers and sessions at the 2nd annual PASS BA Conference in May and launch the PASS Summit 2014 Call for Speakers this week. And we’re looking even farther ahead by putting forward the following goals for fiscal year 2015 (FY2015), which begins July 1, 2014:

    • Execute a robust and diverse educational program: Deliver 160,900+ technical training hours across PASS Summit 2014 and PASS BA Conference 2015, reduce by 20% the number of poorly rated sessions, and provide better attendee guidance through role- and skill-based learning tracks.
    • Improve Program metrics and data collection: Increase session evaluation submissions by 15%, and work on ways to improve session room allocations.
    • Innovate with technology: Enhance Orator functionality to improve Program processes and session scheduling, and scope out a centralized portal for global speaker and session information across PASS.
    • Grow global speaker pool: Enhance speaker resources and communication channels to involve and develop speakers in communities around the world, and improve speaker guidance by sharing focused feedback during call for speakers and through session evaluation results.
    • Improve and standardize Program processes and agreements: Blueprint the BA Conference Program process, attract more Program Committee volunteers, and engage volunteers in special projects for improving processes and results.

As I begin my term on PASS Board of Directors, I’m honored and humbled to lead the team responsible for organizing world-class educational programs that equip SQL Server, Business Intelligence, and Business Analytics professionals for today’s fast-changing world of data. Don’t hesitate to contact me at amy.lewis@sqlpass.org with other ideas for strengthening our content offerings and supporting and growing our awesome speaker pool.
– Amy Lewis
Program Director, PASS Board

Volunteers Portfolio: Goals for FY2015

February 17, 2014 – Volunteers have a hand in all aspects of the PASS community – setting up Chapter and Virtual Chapter meetings, organizing PASS SQLSaturday events, speaking at events, reviewing session abstracts for events, and so much more. PASS would not exist without our passionate, dedicated, and hardworking volunteers from around the globe.

To bring focus to the important tasks of growing PASS’s volunteer pool, better organizing volunteer efforts, and recognizing volunteers’ valuable contributions, we reinstated the Volunteers portfolio last year. I am proud to serve as director of this portfolio and would like to share the main goals we’ve put forward for the coming fiscal year, budget permitting, which begins July 1, 2014:

    • Streamline the volunteer channel: This effort, which began last year with the rollout of the myVolunteering section on myPASS, aims to facilitate volunteer recruitment and help grow leaders throughout the world. Targets for FY2015 are to enlist 100% of volunteers through myVolunteering and to connect 100 additional volunteers through the service, which lets members regularly know about volunteering opportunities in their selected interest areas.
    • Provide a rewarding experience for volunteers: Grow the Outstanding Volunteer of the Month program – which recognizes dedicated volunteering efforts – to an average of five submissions per month, including soliciting regular submissions from Chapter and VC leaders and SQLSaturday organizers.
    • Develop accountability and reward programs: Work with community-facing portfolios to track volunteer contributions across the PASS organization and enhance volunteer appreciation and non-monetary rewards.

I’ve had such valuable experiences serving as a PASS volunteer in all sorts of capacities, and I look forward to any ideas you have for involving more community members and celebrating their efforts – just email me at sri.sridharan@sqlpass.org. And don’t forget to fill out your myVolunteering preferences and to say thank you to your favorite, hardworking PASS volunteer by nominating them for Outstanding Volunteer of the Month.
– Sri Sridharan
Volunteers Director, PASS Board

PASS SQLSaturday Portfolio Goals FY2015

February 17, 2014 – Greetings to all our PASS SQLSaturday organizers, volunteers, attendees, and sponsors! I hope everyone is recharged and ready for great things in 2014. I know I’m energized by talking with so many of you in the past few months since I was elected to the PASS Board of Directors.

Although my term didn’t officially begin until January 1, I’ve been in meetings, crunching data, and reviewing history so I would be prepared to serve as SQLSaturday Director on the PASS Board for the next two years. All this homework has proved invaluable for the beginning of budget planning and our first Board meeting of the year last month.

The Board still needs to work through the budgeting process before anything is 100% finalized, but I wanted to share the key SQLSaturday portfolio goals we’ve put forward for fiscal year 2015 (FY2015), which begins July 1, 2014:

    • Grow SQLSaturday reach and service to local data communities: We’re on target this fiscal year (2014) to see over 25,000 SQLSaturday registrations across over 85 events worldwide. Our goal for FY2015 is to increase those numbers to over 27,000 registrations across 90 SQLSaturday events, including at least three additional events in Latin America.
    • Redesign SQLSaturday website: This effort, probably the largest technology expenditure for PASS in the next year, is already underway and will be extensive, including functionality to facilitate events in languages other than English.
    • Adapt the SQLSaturday model for business analytics-focused events: We’re moving forward with our first Business Analytics Edition of SQLSaturday in Dallas this spring, ahead of the PASS Business Analytics Conference in May. And we look to facilitate four grassroots events at the local level in FY2014 to provide BA-focused content, grow speakers, and serve members.
    • Increase sustainability: Reduce event and materials cost through branding reuse and economies of scale where appropriate.

After years of volunteering for, speaking at, attending, and organizing SQLSaturday events, I’m looking forward to being your voice on the PASS Board. If you have ideas or feedback, please reach out to me at tim.ford@sqlpass.org.

See you at a SQLSaturday soon!
– Tim Ford
SQLSaturday Director, PASS Board

Welcoming Global Alliance Partner Dell Software

February 4, 2014 – PASS is thrilled to welcome Dell Software as a Platinum Level Global Alliance Partner, transitioning the company’s already strong individual event and program sponsorships into a comprehensive, strategic relationship that supports the worldwide PASS community year-round.

As a Platinum Level Global Alliance Partner, Dell Software will be a Platinum sponsor of both the PASS Business Analytics Conference and PASS Summit and will be supporting PASS Virtual Chapters, 24 Hours of PASS virtual events, PASS SQLSaturday events, and the entire PASS community through Connector sponsorships, web advertising, and more.

“We are very excited to be partnering with PASS as a Global Platinum Partner,” said Matt Wolken, vice president and general manager, Information Management, Dell Software. “With data growth and complexity driving the need for better management of leading databases, SQL Server continues to play a critical role in the IT management ecosystem. That’s why Dell Software remains focused on providing solutions for SQL Server that help organizations worldwide solve business-critical challenges, and why we are committed to remaining a leader now and well into the future. Our support for the PASS organization and the SQL Server community as a whole provides clear proof of that commitment.” 

PASS sponsors are a vital part of the community, supporting the organization’s many training and networking opportunities, including free learning events. Through the Global Alliance Program, PASS looks forward to bringing many new opportunities and added value to our community and to our partners. For information about becoming a PASS Global Alliance Partner, please contact Craig Ellis.

Best of PASS Summit 2013

February 3, 2014  As the Program Committee prepares to open the PASS Summit 2014 call for speakers later this month, we’re excited to recognize the Top 10 sessions from PASS Summit 2013:


The Top 10 list is based on average attendee evaluations from sessions that had a minimum of 50 attendees and evaluations from at least 20 or 20% of those attendees (whichever is greater).

Recordings of these “best of” sessions are now available to all PASS members – just log in here to start watching. You can also view other selected PASS Summit 2013 sessions free on PASStv and own the entire set of PASS Summit 2013 session recordings.

And don’t forget to register by March 7 to save on this year’s event, Nov. 4-7, in Seattle.

PASS Board Approves Bylaw Amendments, Thanks CA for Support and Guidance

January 27, 2014 – At its in-person meeting in Seattle last week, the PASS Board of Directors approved amendments to the PASS Bylaws as Founding Partner CA relinquishes its two seats on the PASS Board. The bylaw changes amend Section VI.2., Composition and Qualifications, to reduce the number of both voting Directors and vendor-appointed Directors and to remove CA from appointing vendor-appointed seats:


With CA’s resignation from the Board – official as of January 31 – PASS will say goodbye to its two longest serving Board members, Rick Bolesta and Neil Buchwalter. Rick joined the PASS Board as a CA Founding Partner representative in Year 2 (2000), and Neil joined him on the Board a year later.

Rick and Neil’s longevity with the Board has been invaluable to PASS. They have played a huge role in guiding the work of the Board, especially in areas of governance, leadership development, and strategic direction of the organization. 

“One of my big takeaways from both these gentlemen is their ability to sit at the table during a Board meeting and always wear their PASS hat,” noted PASS President Thomas LaRock. “Over the years, they have consistently put the community first.”

On behalf of the community and the PASS Board and PASS HQ, we thank CA for its support and for allowing Rick and Neil to share their guidance and wisdom with us for so many years – they will be greatly missed.

 
You can read more about CA’s relationship with PASS in Andy Warren’s interview with Rick Bolesta from PASS Summit 2013.