Category: PASS General
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.
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.
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 firstname.lastname@example.org.
– Wendy Pastrick
Chapters Director, PASS Board
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 email@example.com with ideas on growing and supporting these valuable online user groups.
– Jen Strirrup
Virtual Chapter Director, PASS Board
March 17, 2014 – Have you clicked a link in the PASS Connector newsletter lately? Visited sqlpass.org or one of our event websites? How about “Like”-ing the PASS Facebook page, retweeting a post from @sqlpass, @pass24hop, or @passbac, or sharing a blog post or question via the PASS or PASS Business Analytics Conference LinkedIn group? If so, Marketing thanks you!
In addition to delivering on PASS’s annual fundraising goals by promoting and supporting our international PASS Summit and PASS BA Conference events, Marketing’s overarching goal is to spread the word about all aspects of our organization and its offerings – and to encourage active participation.
Toward those ends, here are some other key goals we are putting forward as we look toward fiscal year 2015 (FY2015), beginning July 1, 2014:
- Increase engagement with active PASS members through focused and relevant content/ programs, improved social media engagement with an eye on shared learning for the community, and encouraging local and virtual participation with Chapters.
- Grow our BA membership by establishing a consistent, segmented communications strategy around BA content and interests and support and drive BA participation in local and Virtual Chapter activities, BA-related SQLSaturday events, and other community efforts.
- Grow and support EMEA and LATAM PASS communities: Publish EMEA and/or LATAM content in Connector newsletters, issue quarterly email to LATAM and EMEA members highlighting PASS and local news, and support Chapters, VCs, and SQLSaturday portfolios as they extend community reach into EMEA and LATAM.
Everything the Marketing team does is focused on helping PASS members – and the broader data community – connect with each other, share their experiences, and learn how to improve their skills and get the most out of their organization’s data. Have other ideas for how we can share the PASS message? Please contact me at firstname.lastname@example.org – I’d love to hear them!
– Denise McInerney
PASS VP, Marketing
March 7, 2014 – I wanted to thank everyone for all the great feedback we received on the PASS SQLSaturday goals. I know many of you are excited about the undertaking of the new SQLSaturday website.
There have been a few questions around open-sourcing the site that I’d like to address. Rebuilding the site – accessed by tens of thousands of SQL Server professionals a year – is a major IT project and needs to be undertaken in a controlled and concentrated environment. In concept, open-sourcing the site is an interesting idea, but in terms of execution, we’re simply not in a position to make that happen. The site will be created in the DNN environment in order to facilitate content management functionality for the 80+ volunteer organizers who put on events on a yearly basis.
We started the community feedback process back in the fall with roundtable discussions at PASS Summit and an open meeting with those who expressed interest in providing feedback. We are currently building out wireframes for the site and will share a prerecorded webinar in the next week or so for anyone interested in reviewing. In an effort to keep the feedback process as manageable as possible, we will set up a feedback site for a select group of representative SQLSaturday community individuals from around the world to help us shape this new and improved SQLSaturday website. If you are interested in putting your name forward to be part of this feedback group, please contact us via email with “SQLSat website feedback” in the subject line.
– Tim Ford
SQLSaturday Director, PASS Board
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 email@example.com with other ideas for strengthening our content offerings and supporting and growing our awesome speaker pool.
– Amy Lewis
Program Director, PASS Board
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 firstname.lastname@example.org.
See you at a SQLSaturday soon!
– Tim Ford
SQLSaturday Director, PASS Board
February 4, 2014 – Over the past few weeks, the PASS Board of Directors has been working to establish overall PASS and portfolio-specific goals for fiscal year 2015, which begins July 1, 2014. These goals will help shape both the direction and budget for PASS for the upcoming year. Here’s where we will be focusing our efforts and resources in support of the vibrant and growing PASS community.
Overall PASS Goals
- Establish PASS as the community leader in Microsoft data technologies.
- Deepen our reach throughout Europe, the Middle East, and Africa (EMEA) by increasing local and virtual programs to serve community members.
- Establish a foundation for PASS in Latin America (LATAM), working with local leaders to provide programs that serve Spanish and Portuguese-speaking community members.
To hold the Board of Directors accountable and help us achieve the aims we set as a group, we have also established some Board-specific goals:
- Global Growth: Refine and determine a scalable, global paid event model.
- Elections: Establish a process to ensure each eligible voter may cast no more than one ballot in a PASS election.
- Performance Management: Design and implement a performance-management program across portfolios and PASS Headquarters to provide visibility, transparency, and accountability.
- Technology Innovation: Enhance our information technology strategy, operational processes, and organizational alignment.
Each portfolio team has established its own goals based on these overall objectives. Over the next two weeks, each PASS Director will blog about their portfolio’s goals. We look forward to your feedback and working together to continue to achieve great things for the PASS community.
– Thomas LaRock,
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.