THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

  • 24 Hours of PASS - Evolution of the Data Platform - The Grand Finale - Schedule Change

    I was originally schedule in the 24th slot of the upcoming 24 Hours of PASS which was to begin at 7am ET on May 26.  I called it the Grand Finale.

    As with many events, schedule conflicts arise. So, the Grand Finale session will now be referred to me as the Grant Finale session.  Grant Fritchey will now be speaking at 7am ET on May 26.  My session will be where Grant's was before the change - May 25 @7pm ET..  See the entire schedule here: http://www.sqlpass.org/24hours/2016/edp/Schedule.aspx

    My original post about this incarnation of 24 Hours of PASS is here: http://sqlblog.com/blogs/rick_heiges/archive/2016/05/18/24-hours-of-pass-evolution-of-the-data-platform.aspx 

    Register Today!

  • 24 Hours of PASS - Evolution of the Data Platform - The Grand Finale

    I am honored that I was selected to present my session "Winning with Column Store: A Customer Story" for the upcoming 24 Hours of PASS event.  Details about my session and the 23 other sessions may be found here - http://www.sqlpass.org/Events/24HoursofPASS.aspx 

    I want to thank the other speakers for the preceding sessions warming up the crowd for me.  :-)  Yep, my session is the last one for this event which will start at 7am ET on May 26. 24 Hours of PASS kicks off on May 25 at 8am ET.  There is a lineup of great sessions with extraordinary speakers - so don't let this opportunity to learn about the latest innovations of the Microsoft Data Platform.

    If you know my history, I am very excited to be a part of the content for this event!  I first led the effort for this event back in 2009 and have volunteered to help out with this event when I can.  Thankfully, we no longer need to deal with some of the limitations that LiveMeeting forced on us, but LiveMeeting served our needs for the first few years.

    This session is a bit different for me.  Often my sessions are focused on how a particular feature or technology works or how to get started on a path to get to the next step.  Although we will highlight some technical details and go over some index basics, I think the more interesting discussion will be around the decisions that we made in this time boxed pilot for this customer.

    As the title points out, this is a story from a customer engagement earlier this year.   The session is designed to walk you through the experience as closely as possible and to cover the actions taken to get to the test which shows the magic of the Column Store index.  We had to make some compromises along the way which I will call out.  Our proving ground offered some challenges that never got to where I wanted it to be, but we made due with what we had and did not let "Perfect" be the enemy of the "good" or "good enough".

    I really want to encourage everyone to attend.  I also invite you to let your co-workers, friends, customers, and even developers know about the event.  I was fortunate enough to be able to present this session locally at two user group meetings in NC over the past few weeks.  I received valuable feedback that will make this session even better on May 26. I look forward to seeing you at the event!

     

     

  • Basic Availability Groups in SQL Server 2016

    Since SQL Server 2012, Database Mirroring (DBM) has been a deprecated feature meaning that it will be eventually removed in a future version of SQL Server.  It is still available in SQL Server 2016.  One of the best things about DBM is that it was a limited feature in Standard Edition since SQL Server 2005. The AG feature first introduced in SQL Server 2012 was the successor of DBM, but there were some details which prevented it from being offered at the Standard Edition level such as the requirement for Active Directory Domain security.

    To address the eventual removal of DBM from SQL Server, Microsoft has created a new level of AG called a Basic Availability Group.  It is to be very similar to the pros/cons of DBM in Standard Edition today.  The following represent a summary of the new Basic AG:

    -          Maximum of Two (2) Replicas (the Primary and one secondary)

    -          One (1) database per AG

    -          The Secondary Replica is not Active/Readable, but a Database Snapshot could still be utilized

    -          Microsoft Clustering Services(MSCS) Required - No Witness – MSCS detects failover via quorum

    Due to this new term of Basic Availability Group, the current term of Availability Group may also be referenced as Advanced Availability Group going forward.

    One other difference between DBM and a Basic AG is that the Basic AG supports both Synchronous and Asynchronous modes.  DBM only supported Synchronous mode.  I believe the main reason for this change is to make it easier for the secondary replica to be in an Azure VM.  DBM is still in SQL Server 2016; I would have to believe that it will not be in the next release of SQL Server - whenever that is.

    Here is another blog post about SQL Server 2016 Availability Groups.  http://sqlblog.com/blogs/rick_heiges/archive/2016/01/20/new-article-what-s-new-in-sql-server-2016-availability-groups.aspx

    Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}
  • New Article: What's New in SQL Server 2016 Availability Groups

    I am pleased to announce that I had another article published at TechTarget.com (SearchSQLServer.com). The topic is focused on what's new in SQL Server 2016 Availability Groups.  I actually created this article a while back and finally got published. It does not have information about Basic Availability Groups, but I will be blogging about that soon in another post soon to follow.

    Here is the link: http://searchsqlserver.techtarget.com/feature/Whats-new-in-2016s-SQL-Server-AlwaysOn-Availability-Groups

     Enjoy!

     

    Follow-up Note:  Here is a link to the follow-up blog post on Basic AGs.  http://sqlblog.com/blogs/rick_heiges/archive/2016/01/21/basic-availability-groups-in-sql-server-2016.aspx 

     

  • Speaking at SQL Saturday #470 in Washington DC on Dec 5


    I am pleased to announce that I will be speaking at SQL Saturday 470 in Bethesda, MD at the Microsoft MTC on Dec 5!  The event is already sold out with a waiting list!

    http://www.sqlsaturday.com/470/eventhome.aspx

    My topic is "First Look at SQL Server 2016".  Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.I also plan on being available throughout the day to answer questions on SQL Server 2016 to the best of my ability.

    I am currently scheduled for the first session in the morning.  I hope to see you there!  After my session is complete, I will try to find a table perhaps near the vendors to answer any questions that you may have about SQL Server 2016.

  • Speaking at SQL Sat 452 in Charlotte on Oct 17!

    I am pleased to announce that I will be speaking at SQL Saturday 452 in Charlotte on Oct 17!  Last year, this event had a great turnout.  Be a part of it this year! Register Now!

    http://www.sqlsaturday.com/452/eventhome.aspx 

    My topic is "First Look at SQL Server 2016".  Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.I also plan on being available throughout the day to answer questions on SQL Server 2016 to the best of my ability.

    This should be a great event!  Help make great by being part of it!  See you there!

    Published Monday, October 05, 2015 4:01 PM by RickHeiges
  • Update on My Dynamic Data Masking Article - Behavior Change in CTP 2.4

    Introduction

    Recently, an article of mine was published by TechTarget.com on the SearchSQLServer.com site titled “An introduction to SQL Server 2016 dynamic data masking” which can be found here.  I encourage you to read the article in order to get the most out of this blog post and to better understand this feature.  This article was based on the SQL Server 2016 CTP 2.2 release.  Since CTP 2.4 was recently released, I decided to run my script from the article and look for behavior differences. 

    The Difference

    Everything in my script worked the same except for where I test using a “SELECT INTO” approach to get around the data masking.  Here is the code snippet and result from the article.

    Execute as user = 'TestUser';

    Select * INTO dbo.maskemployee from dbo.employee;

    REVERT;

     

    Grant select on maskemployee to TestUser;

     

    Execute as user = 'TestUser';

    Select * from dbo.maskemployee;

    REVERT;

     

     

    When I ran this portion of my script in CTP 2.4, I was happy to see that the security hole had been addressed.  The “SELECT INTO” now creates the maskemployee table with the masked data INSTEAD of the real data.  On a side note, I also ran this script in CTP 2.3; the behavior was the same as CTP 2.2.

    What about Azure SQL Database?

    The Azure SQL Database preview was also recently updated.  I am happy to report that the above behavior is consistent with that outlined above.  One other note that I’d like to make about Dynamic Data Masking in Azure is that there are now suggestions for columns to be masked and also suggestions of what type of mask to use when navigating the blades.  I think that this is a good idea for those just starting to play with this feature, but that it will most likely go unused once the user is more experienced

    Summary

    As SQL Server 2016 gets closer to release next year, the CTP releases show progress on how the team at Microsoft is moving forward.  I imagine the team is starting to move into the “fit & finish” phase of some of these features.  I continue to look forward to see what’s next.

     

  • Speaking at SQL Sat 445 in Raleigh on Oct 10!

    I am pleased to announce that I will be speaking at SQL Saturday #445 on October 10, 2015!

    When I first moved to North Carolina 25 years ago, I moved to Raleigh.  The Triangle is a great place to live and raise a family.  There is still time to register.  Go to the following link:  http://www.sqlsaturday.com/445/eventhome.aspx

    My topic is "First Look at SQL Server 2016".  Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.I also plan on being available throughout the day to answer questions on SQL Server 2016 to the best of my ability.

    This should be a great event!  Help make great by being part of it!  See you there!

  • Speaking at SQL Sat 440 in Pittsburgh on Oct 3!

    I am pleased to announce that I will be speaking at SQL Saturday #440 on October 3, 2015!

    I am originally from Western PA and it is always good to get back "Home".  This will be my 3rd time at this SQL Saturday event.  There is still time to register.  Go to the following link:  http://www.sqlsaturday.com/440/eventhome.aspx 

    My topic is "First Look at SQL Server 2016".  Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.I also plan on being available throughout the day to answer questions on SQL Server 2016 to the best of my ability.

    This should be a great event!  Help make great by being part of it!  See you there!

  • PASS Summit 2015 - I have a Lightning Talk!

    I will once again be going to the PASS Summit.  This year I will have a 10 minute Lightning Talk on Rethinking the Resume. Essentially, we will discuss various ways to make your Resume stand out and show some examples of how others have rethought their resume.  I have reviewed 100s of resumes over the years and I want to share several that stood out.  Perhaps you will get an idea on how to make your resume stand out.

    If you haven't registered yet, what are you waiting for?  It is a week long celebration of being a data professional.  It is a great place to Connect with your peers, Share a Tip / Story / Issue, and Learn how too make your life easier.  Here's a link so that you can register.

    http://www.sqlpass.org/summit/2015/RegisterNow.aspx

     

    The summit has been a success for many years and while many things change, many things stay the same.  I wrote a series of blog posts about what to expect at the summit.  Although there will be some differences, these blog posts are still relevant for this year.  Below is a link to the Summary Blog post.

     http://sqlblog.com/blogs/rick_heiges/archive/2011/09/19/pass-summit-2011-what-you-can-expect-at-the-conference-summary.aspx 

    Hope to see you there! 

  • PASS Elections: Fuzzy Math

    The following is an observation and not a swipe at the process.  As I understand the current process, the regional seats are filled first before the open seats are filled.

    We have 4 excellent candidates running for 3 seats on the PASS BoD this year.  One seat is earmarked for EMEA; one is for US/Canada; and one is open.  We have 1 candidate that qualifies for the EMEA seat - Jen Stirrup.  This means that Jen will be re-elected. The remaining three candidates are all eligible for the other two seats - one US/Canada and one Open. 

    When you cast your vote, there are three main scenarios as I see it:

     - Scenario 1: Don't vote for Jen and cast three votes for the other candidates.  This effectively means that you voted but really did not vote.  BTW, I am not advocating that you don't vote for Jen - this is an observation on the situation and no endorsement is put forth here.

    - Scenario 2: You vote for Jen and you need to pick 1 or 2 of the others - OR - you don't vote for Jen and cast only two votes for the other candidates.  This will at least make your vote impact the results in some aspect. Again, there is no advocacy here to support or not support any particular candidate.

    - Scenario 3: You only cast a vote for the ONE candidate that you feel most strongly about.  Perhaps this magnifies your vote the most.  Again, I am just illustrating how you vote impacts the results.

    As an aside, you can't vote more than once for a particular candidate; in other words you can't cast all three of your votes for Candidate A.  At this point, I am unsure of what I am going to do. But I will vote.  I hope that this blog post will make you do some additional research on the candidates before deciding how to cast your vote. I'm sure that all of these candidates want to make sure that you have an informed opinion when you cast your vote.

    Go Research and then Go Vote! 

  • New Article: Dynamic Data Masking in SQL Server 2016 and Azure SQL DB

    My latest article on a new feature (Dynamic Data Masking) coming to SQL Server 2016 and Azure is now available.

    Dynamic Data Masking essentially displays characters instead of real data to non-privileged users.  The data is not stored as a masked values.  As with anything, there are pros and cons with this approach.  It is another tool in the toolbelt to help keep data secure.  Combining DDM with other security features may be the right solution for your situation.

    Here is the link to the article.

    Enjoy!

  • Speaking at SQL Sat 427 in Sioux Falls, SD on July 18!

    SQL Saturday finally comes to South Dakota!  Register Now! - http://www.sqlsaturday.com/427/eventhome.aspx

     Here are some of the other featured speakers:

    Database Snapshots - Making Your Job Easier            Paul Timmerman

    Continuous Integration for Databases                           Steve Jones

    Developing SQL Skills                                                        Panel Discussion

    I will be doing a session titled "A First Look at SQL Server 2016" which will first highlight the new features coming out in the next version and also focus on two features that I have had more exposure to - Row Level Security and StretchDB

    If you are in the area, please drop by and experience SQL Saturday for yourself.  Best of all - it is FREE!  

  • New Article: A Look at StretchDB - a New Feature in SQL Server 2016

    My article on the new StretchDB feature in SQL Server 2016 is now available.  StretchDB allows you to have a table in your database to be partially on-prem and partially in Azure. If you have a database with a lot of historical data that doesn't change, this feature may be a good fit for your situation. I hope that you enjoy the article.

     http://searchsqlserver.techtarget.com/tip/A-look-at-StretchDB-a-new-feature-in-SQL-Server-2016

     

  • Heading to SQL Sat NYC!

    I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon.  I have delivered this session many times and is usually well attended.  The session is geared for the person who has heard of Perfmon but not used it.  This is very much a 100 level offering.

    The last time that I was in NYC for a large SQL Server event was just about 10 years ago.  It was the "Get Ready for SQL Server 2005 Roadshow" that was sponsored by Microsoft, PASS, and SQL Server Magazine.  The cost was $99 for a whole day; about 450 people attended.  There were 3 tracks - DBA, Dev, and BI.  Scalability Experts did the DBA track, Solid Quality Learning (as it was known back then) had the BI Track, and Dev Mentor had the Dev track.

    Although I attended many of these Road Shows and eventually presented the DBA track at some locations, I learned a lot from the audience.  I still do.  The questions that are asked really provide an opportunity for learning.  You can also see patterns start to emerge over time from questions.  For example, one question that was asked often was "Can I mirror a database to another instance on the same box?".  The first couple of times that I heard the question, my instinct was "Yes, but why? You are defeating the purpose when you do this.".  When so many people ask this question, you have to dig deeper.  In essence, what a lot of people were saying was this - "I trust my hardware a lot more than I trust your software in terms of uptime".  Servers were becoming more and more fault tolerant with spare power supplies, fans, hard drives, etc.  This increased reliability.  From one point of view, being able to mirror to another instance on the same box was just another level of redundancy.

    When you attend a SQL Saturday or other event, please don't hesitate to ask a question.  It just might be the same question that others have and it helps everyone learn more. 

    Also, the speakers at SQL Saturday events are giving up their Saturday too.  A great way to thank the speaker is to provide written feedback on the evaluation forms.  This is almost like gold to the speakers.

    If you are in the NYC area on May 30th, I encourage you to attend.  The event is almost "Sold Out". so be sure to register today!  http://www.sqlsaturday.com/380/eventhome.aspx 

    See you there!

     

More Posts Next page »

This Blog

Syndication

Privacy Statement