Category: PASS General

SQL Server 2014: Hybrid Scenarios

June 9, 2014 – SQL Server 2014 makes it easier than ever to unlock new hybrid scenarios between your on-premises SQL Server instances and Microsoft Azure. Here are three key hybrid scenarios that you can easily deploy with SQL Server 2014 and Azure to help reduce operational costs while improving business continuity:

    • Quickly develop and test SQL Server applications. You can spin up a SQL Server 2014 image in minutes on Azure Virtual Machines (VMs) for your next SQL Server development and test project. And with full SQL Server compatibility and many VM sizes to choose from, you can easily deploy the application into production on Azure or back on-premises. The best part is that you pay only for what you use, so you can reduceyour capital-expenditure investment to set up a dev/test environment for SQL Server. You can also now easily connect to and manage your SQL Server VMs in Azure through SQL Server Management Studio (SSMS).
    • Cost-effectively back up your on-premises SQL Server instances. SQL Server 2014 makes full SQL Server-level backup to Azure storage even easier with a new UI built directly into SSMS.  SQL Server 2014 also offers the ability to encrypt the backup, where you have the option to hold the encryption keys. In addition, a new complimentary backup tool lets you also back up previous versions of SQL Server to Azure.
    • Enable low RTO disaster recovery while improving BI reporting for your global offices. You can enable a low Recovery Time Objective (RTO) disaster recovery solution with SQL Server 2014 that not only improves business continuity but also gives you the ability to enhance business intelligence (BI) reporting for your global offices. The solution takes advantage of up to eight readable secondaries with the AlwaysOn feature in SQL Server 2014 and places them strategically across the many Azure global datacenters. You can use the readable secondaries to offload BI reporting or run backups, and they are much easier to deploy on-premises or on Azure with new the UI in SSMS.

These hybrid scenarios can benefit your on-premises SQL Server instances and help you innovate faster by providing flexible, cost-effective, and efficient ways of developing and testing new database applications. If you haven’t already, download the evaluation copy of SQL Server 2014 and try these new hybrid scenarios with Azure for yourself.  


 


Global Representation in NomCom and Board Elections

June 4, 2014  Discussions around this year’s Nomination Committee (NomCom) elections have raised some questions about global representation on the NomCom. The three community seats on the five-member NomCom match the three seats up for election on the PASS Board of Directors. Here’s a quick summary of where we are in the process of increasing international representation and participation in PASS leadership via regional seats and how that relates to this year’s NomCom and Board elections.

Last year, the PASS Board approved bylaw changes that allowed the transition of its formerly all open seats to a mix of open seats and regionally-reserved seats, paving the way for more international perspectives and representation on the Board. The bylaw changes also set the NomCom to mirror the composition of Board seats up for election in any given year. The Board began this transition by adding two regional seats for the 2014/2015 term: one US/Canada seat (won by Tim Ford in the 2013 Board elections) and one EMEA seat (won by Jen Stirrup).

The bylaws call for a total of two regional seats representing the US/Canada, one each to be up for election annually, so this year defines that second US/Canada seat on the Board. Thus, for the 2014 NomCom and Board elections, community members are voting to fill one US/Canada regional seat and two open seats. Going forward, at least one US/Canada and one open seat will be up for election each year, with the EMEA regional seat up for election every other year. You can review the process for awarding PASS NomCom and Board seats here.

The Board has been diligently working on the next steps for adding other regional seats to promote greater global perspective and representation. We will be sharing this with the PASS community in the coming weeks. As the Board grows globally via regional seats so will the NomCom.

The transition to additional regional seats is an important process, but I want to remind dedicated volunteers and prospective candidates outside of US/Canada and EMEA that you don’t have to wait until a seat is added for your region. As always, candidates from any region are eligible to run for open seats on the PASS NomCom and Board of Directors, and we encourage you to do so.

Good luck to all our NomCom candidates during this week’s election and to all those thinking about running for the PASS Board later this year. Watch Friday afternoon for announcement of the full NomCom – including this year’s Board-appointed member – after the Board approves the final election results and appointee nomination. And please let us know if you have any questions.
– Bill Graziano
Immediate Past President/NomCom Chair


 

NomCom Candidates Announced – Elections Next Week

May 28, 2014  It’s your turn! The candidate slate has been finalized and voting opens Tuesday, June 3, for three community seats on the 2014 PASS Nomination Committee (NomCom), which will manage the Board of Directors election. Your 2014 NomCom candidates are: 

    • Allen Kinsel - US/Canada & Open
    • Andy Warren - US/Canada & Open
    • Angela Henry - US/Canada & Open
    • Brandon Leach - US/Canada & Open
    • Chris Testa-O'Neill - Open
    • Erin Stellato - US/Canada & Open
    • Kendal Van Dyke - US/Canada & Open
    • Mark Broadbent - Open
    • Ryan Adams - US/Canada & Open
    • Steve Wake - US/Canada & Open
    • Tamera Clark - US/Canada & Open

The community representatives will reflect the three seats up for election on the PASS Board this year: one US/Canada seat and two open seats. Immediate Past President Bill Graziano will chair the NomCom, a five-member committee that manages the PASS Board of Directors elections process, qualifying, interviewing, and ranking potential candidates. A final slate is then submitted to the Board for approval. In addition, this year’s NomCom is charged with streamlining the process for involving and evaluating candidates and with enhancing opportunities for community engagement in the elections. A representative appointed by the PASS Board will round out the committee.

NomCom campaigning will begin June 2 – watch the Elections site to learn more about the candidates. Secure, individualized ballots will be emailed June 3 to all PASS members who have updated their profile by June 1. All ballots must be submitted by noon PT on June 6.

Thanks in advance for participating in the NomCom elections and the running of your organization – and good luck to all 11 candidates who applied for this important role!


Call for NomCom Now Open!

May 14, 2014 – Are you a dedicated PASS volunteer with a passion for improving our community? Then you’re eligible to apply for three community seats up for election on this year’s Nomination Committee (NomCom), which will oversee the 2014 PASS Board of Directors elections.

The call for NomCom applications is open now through noon PT May 22.

What Is the NomCom? 
The NomCom is a five-member committee that manages the PASS Board of Directors elections process, qualifying, interviewing, and ranking potential candidates. A final slate is then submitted to the Board for approval. In addition, this year’s NomCom is charged with streamlining the process for involving and evaluating candidates and with enhancing opportunities for community engagement in the elections.

Immediate Past President Bill Graziano will chair this year’s NomCom, which will include three elected community representatives reflecting the three seats up for election on the PASS Board this year: one US/Canada seat and two open seats. A representative appointed by the PASS Board will round out the committee.

Who’s Eligible to Run?
To be eligible to run for the NomCom, candidates must have a demonstrable track record of volunteering with PASS – such as serving as a Regional Mentor, Chapter or Virtual Chapter Leader, or Program Committee member – and participating in other volunteer endeavors. Note that as an essential part of the PASS Board elections process, the NomCom requires significant time and effort. By applying for the NomCom, applicants agree to the time commitments of the entire general elections process, including Board applicant interviews.

Thinking about running? See what recent committee members have to say about serving on the NomCom.

Get Started Today!
If you meet the eligibility requirements and are interested in serving on the NomCom, please download the application for full details and submit your completed form to governance@sqlpass.org by 12:00pm PT / 19:00 GMT May 22. Successful candidates will be notified by May 27.

NomCom elections will run June 3-6, with all PASS members who have updated their profile as of June 1, 2014, eligible to vote. Good luck and thanks in advance to all applicants!

PASS BA Conference in Review

May 14, 2014 – Last week’s PASS Business Analytics Conference featured three days of professional networking and the latest in analytics education delivered by the world's top BA/BI experts.

Relive your favorite moments or catch what you missed by watching the Day 1 keynote with Microsoft’s Kamal Hathi and Amir Netz and the Day 2 keynote with data visualization expert David McCandless. Then see what bloggers had to say (Day 1 | Day 2), check out our Flickr feed, and make sure you purchase a USB of all conference session and keynote recordings.

We look forward to seeing you next year in Santa Clara, CA, April 20-22  sign up today to receive conference updates!

Why Run for the NomCom?

April 29, 2014 – The call for PASS Nomination Committee applications opens in just two weeks. Thinking about throwing your hat into the elections ring for this year’s three community NomCom seats? Here’s some information to help you get ready.

The NomCom manages the PASS Board of Directors elections process, qualifying, interviewing, and ranking potential candidates. A final slate is then submitted to the Board for approval. In addition, this year’s NomCom is charged with streamlining the process for involving and evaluating candidates and with enhancing opportunities for community engagement in the elections.

Immediate Past President Bill Graziano will chair the five-member NomCom, which will include three elected community representatives reflecting the three seats up for election on the PASS Board this year: one US/Canada seat and two open seats. A representative appointed by the PASS Board will round out the committee.

To be eligible to run for the NomCom, candidates must have a demonstrable track record of volunteering with PASS – such as serving as a Regional Mentor, Chapter or Virtual Chapter Leader, or Program Committee member – and participating in other volunteer endeavors. Note that as an essential part of the PASS Board elections process, the NomCom requires significant time and effort. By applying for the NomCom, applicants agree to the time commitments of the entire general election process, including Board applicant interviews.

Thinking of running?

“There is no better way to contribute to the health of the PASS community than serving on the NomCom,” notes PASS Regional Mentor Ryan Adams, who served on last year’s committee. “You are vetting the future directors of the organization, who will provide strategic guidance, long-term growth, and stability to the community we love. It’s not just an opportunity to interview and ensure solid and motivated candidates for the community, it’s also a responsibility that has immense rewards.”

Fellow 2013 NomCom member Erin Stellato adds that serving the SQL Server community through the NomCom is about more than giving back. “It's about having the opportunity to really get to know the community members who choose to run for the Board, and then taking that information and helping the greater community decide who the best people are for the job,” she says. “The NomCom also gives you the chance to better understand the PASS organization as a whole and starts the wheels turning about other ways you can make a difference.”

Remember that to be eligible to vote in the NomCom and PASS Board elections, members must update their PASS profile by June 1. Whether you join the conversation about how to improve the organization, support your favorite candidates and vote, or run for office yourself, please get involved and help shape the future of PASS.

For more information about PASS’s elections process and running for the NomCom, contact PASS HQ Governance Administrator Janice Simpson.

Welcome Global Alliance Partner SQL Sentry

April 29, 2014 – PASS is excited to welcome SQL Sentry as a Gold Level Global Alliance Partner, expanding the company’s strong individual event and program sponsorships into a comprehensive, strategic relationship that supports the worldwide PASS community year-round.

SQL Sentry has been supporting database professionals through its tools since 2004, when the company released its first product and joined the SQL Server community. Over the years, SQL Sentry has worked to give back and strengthen the community, not just through event sponsorships but also through services such as the shuttles at PASS Summit 2013 in Charlotte and the high quality educational efforts its respected experts Aaron Bertrand and Kevin Kline share through events, blogs, and other venues.

"Teaming up with PASS for the Global Alliance Partner Program was the logical next step for SQL Sentry,” said Nick Harshbarger, Vice President of Sales and Marketing for SQL Sentry. “Since our roots come from many years of running a very large, complex SQL Server enterprise, we have appreciated the benefit of the unique community shepherded by PASS. The education we’ve received and the connections we’ve created through PASS have been critical to the growing success of our business. We are proud of our 10-year support of PASS and look forward to stepping up and helping the PASS community reach new heights of success.”

As a Gold Level Global Alliance Partner, SQL Sentry will be a Gold sponsor of PASS Summit, a Silver sponsor of the PASS Business Analytics Conference, and will be supporting 24 Hours of PASS virtual events, PASS SQLSaturday events, and the entire PASS community through Connector sponsorships, web advertising, and more.

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.

Early NomCom Kicks Off Elections Season

April 1, 2014 – Mark your calendar: An early Nomination Committee (NomCom) process will kick off this year’s PASS elections season, with applications opening in May for three community seats on the team that will manage the Board of Directors elections. The 2014 NomCom will also be working to streamline and improve our elections process for candidates and members alike.

As Immediate Past President, I’ll be chairing the five-member NomCom, which includes three elected community representatives who will reflect the three seats up for election on the PASS Board this year: one US/Canada seat and two open seats. A representative appointed by the PASS Board will round out the committee.

In addition to managing the Board elections, this year’s NomCom is charged with streamlining the process for involving and evaluating candidates and with enhancing opportunities for community engagement in the elections.

To give us time to discuss and implement any changes, the NomCom elections season will occur earlier this year, with NomCom applications opening May 14 and elections running June 3-6. Once seated, the NomCom will meet regularly from June 9-July 25 before Board applications open in early August and will participate in candidate interviews from August 27 to September 12.

To be eligible to run for the NomCom, candidates must have a demonstrable track record of volunteering with PASS – such as serving as a Regional Mentor, Chapter or Virtual Chapter Leader, or Program Committee member – and participating in other volunteer endeavors. Note that as an essential part of the PASS Board elections process, the NomCom  requires significant time and effort.

Remember that to be eligible to vote in the NomCom and PASS Board elections, members must update their PASS profile by June 1, 2014. Many of you have already completed your myProfile information, which helps PASS better serve your interests and allows us to do our due diligence in ensuring that eligible voters receive only one ballot. If you haven’t already, I encourage you to update your myProfile today!

Serving on the NomCom is one of the most rewarding ways to give back to the PASS community and be involved in helping shape the future of our organization. Have questions about what’s involved in running for and serving on the PASS NomCom? Don’t hesitate to reach out to me or PASS HQ Governance Administrator Janice Simpson
– Bill Graziano
Immediate Past President/NomCom Chair

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.