Upcoming PASS Summit 2016

Posted on by

PASS_2016_200x200[1] It’s that time of the year again when data professionals across the world converge at Seattle for one of the largest gatherings of data professionals around the world. This is one week of deep technical sessions delivered by community experts, MVPs and Microsoft engineers. With such a high concentration of data professionals around the world, you cannot discount the phenomenal networking opportunities at the event.

PASS Summit is the must-attend conference for all data professionals. There is a wealth of learning, connections, and immediate solutions gained in 3+ jam-packed and inspiring days. And possibly one of the largest congregation of data professional in the world with over 4000 attendees. Our Corporate Vice President, Joseph Sirosh, will talk about Cloud Intelligence Innovations during his keynote session on Day 1. David DeWitt, a very familiar face at PASS summit and in the community, will talk about Data Warehousing in the Cloud during his keynote session on Day 2.

The SQL Server Tiger Team (@mssqltiger) will be delivering sessions, will be at the clinic and is eager to hear from SQL Server customers. I published a blog post which is a summary of what the Tiger team will be upto at the PASS Summit.

Parikshit and I will be delivering a session on Always On enhancements and how it would help monitor, support and troubleshoot your environments better and even make your critical environment more reliable and available!

My session at PASS Summit

Session: SQL Server Enhancements that Keep Your Environment Always On
Speaker: Parikshit Savjani, Amit Banerjee
Session Code: DBA-313-M
Session Date: October 27th
Session Time: 1:30PM – 2:15PM PST
Level: 300
Duration: 75 minutes
Room: TCC Tahoma 5

What you can expect: SQL Server Always On Availability Groups provides a number of out-of-the-box enhancements in SQL Server 2012, 2014 and 2016 which helps analyze common issues with relative ease. Attend this session to find out more about how the new enhancements can be leveraged to improve reliability, reduce manual effort and increase uptime. This session will also do a deep dive using demos of the new visualizations available for common scenarios leveraging the new diagnostic and supportability improvements that were added. As a bonus, we will show you new visualizations and data analysis techniques for common issues that you face in your Always On environments.

Attaching a CDC enabled database on SQL Server 2016

Posted on by

When you detach a database with Change Data Capture enabled on SQL Server 2014 and below and attach it to a SQL Server 2016 instance, you could run into the error mentioned below while execute Change Data Capture (CDC) related procedures.

Error:

Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 639 [Batch Start Line 0]

Could not update the metadata that indicates table [<schema name>].[<object name>] is enabled for Change Data Capture. The failure occurred when executing the command ‘insert into [cdc].[captured_columns]’. The error returned was 213: ‘Column name or number of supplied values does not match table definition.’. Use the action and error to determine the cause of the failure and resubmit the request.

This is due to the fact that there is a metadata change in SQL Server 2016 associated with Change Data Capture which does not happen till you manually execute sys.sp_cdc_vupgrade against the newly attached database on the SQL Server 2016 instance.

The “Attach a Database” online documentation has also been updated to reflect this information.

#AskSQLTiger Twitter Chat on June 27

Posted on by

Join the SQL Server Tiger team for a Twitter Chat on Monday, June 27th from 10 -11 AM PST. You can ask anything about Query Performance on SQL Server for our first Twitter chat. 

Log on at the time above, make sure to include #AskSQLTiger in every Tweet you make, and you’ll be part of our discussion. Or, follow this link to see the #AskSQLTiger feed. Tools like TweetdDeck, HootSuite can be helpful in following along in a Twitter Chat. Members of the @mssqltiger will be moderating the discussion.

More details can be found here.

Recent session at PASS HADR VC session

Posted on by

I recently delivered a session for High Availability and DBA Fundamentals on June 14th about the recent High Availability and Disaster Recovery enhancements that were delivered/to be delivered in recent Service Packs of SQL Server. The session recording is available on YouTube, the slide deck is available on Slide Share and the demo scripts along with the Power BI dashboards are available on GitHub

SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 provide extended events which helps track down two of the most common issues that DBAs have to cope with during an outage situation related to Availability Groups: Latency and Lease Timeouts (which could result in failovers). These new extended events have been shipped based on customer feedback that we heard, acted up and shipped. If you have an Availability Group setup, then come learn about the new enhancements shipped with SQL Server 2012 Service Pack 3 and the upcoming SQL Server 2014 Service Pack 2 and above which allows you to troubleshoot failovers more easily and pin point the latency in your environment more efficiently.

Sessions at SQLNEXUS and SQLBITS

Posted on by

I will be presenting at two different conferences in Europe: SQL Nexus and SQLBITS. Joseph Sirosh, Corporate Vice President of the Data Group, will be delivering the keynotes at both these conferences. There are multiple sessions from Microsoft speakers from Data Group, SQL Server Customer Advisory Team (more famously known as SQLCAT) and other SQL Server community experts which would make this conference worth your time.

My team, MSSQLTIGER, will be presenting other sessions at these events. A full list can be found on the Tiger blog.

SQL Nexus – 2nd – 4th May, 2016

Session Name: Recent SQL Server Enhancements: We heard, We built, We shipped! (Session Link)

Length: Full Day

Date: 2nd May, 2016

Session Abstract:

  • Have you wondered if there was an enhancement which made your job easier in monitoring or troubleshooting a SQL Server issue?
  • Have you ever wished for a change in SQL Server which made your job easier?
  • Did you wonder what SQL Server can do for you in the cloud?

If your answer was YES to any of the questions above, then attend this session to know more about the improvements in SQL Server which would help your current workloads on SQL Server 2012, SQL Server 2014 and SQL Server 2016.  We will discuss enhancements done for high availability and disaster recovery, monitoring, performance, scalability and much more along with demos and scripts that you can take home. We will talk about how we listened, understood and delivered on feedback that we received from customers using SQL Server.  We will also show you ways to leverage data movement capabilities between your on-premise datacenters and Azure which will help you expand your boundaries to Azure SQL DB and Azure Virtualizations.

This is a session for DBAs, Database Developers and anyone who runs a production SQL Server instance on the ground, up in the cloud or anywhere in between!

You can also catch us at SQL Clinic where we you can drop by to say Hi, ask your SQL Server question or provide feedback about the product!

SQL BITS – 4th May – 7th May, 2016

Session Name: Debugging made easier using Extended events (Session Link)

Level: 300

Date: 6th May, 2016

Time: 3:30pm – 4:45pm

Session Objectives:

  1. Understand the diagnostics enhancements available in SQL Server database engine in SQL Server 2012 Service Pack 3 and above
  2. Leverage the diagnostics to troubleshoot and mitigate issues quickly in mission-critical environments
  3. Simplify troubleshooting experience for common SQL Server scenarios

Session Name: Always On Availability Group Troubleshooting Ninja (Session Link)

Level: 400

Date: 6th May, 2016

Time: 12:15pm – 1:15pm

Session Objectives:

  1. Troubleshoot failovers in your Availability Group easily
  2. Determine the reason for connectivity loss and timeouts
  3. Understand which part of your topology is the reason for latency