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

  • 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!

     

  • New Article: Row Level Security for SQL

    Recently, Tech Target was nice enough to ask me to start writing a series of articles for their SearchSQLServer.com website.  I have often made good use of articles on their family of websites. I hope that the articles that I compose will prove helpful as well.

    I chose Row Level Security(RLS) for my first article for several reasons.  First, I think it makes sense that an organization wants to maintain control as much as possible over the data it possesses. Now that I work for DB Best, Migrations from another Data Platform to SQL Server or Azure is part of the regular business that we do. Oracle and DB2 offer their take on RLS and now SQL Server has another feature that makes it easier for the transition.  RLS is currently in "Preview" on Azure SQL Databases and is scheduled to be part of the new features in SQL Server 2016.

    Here is a link to my article.  I hope that you enjoy it! 

  • New Challenges Ahead!

    I just joined the team at DB Best Technologies as a Principal Solutions Architect.  Check out their website at www.DBBest.com.  DB Best is probably best known for providing the SQL Server Migration Assistant (SSMA) tool and associated support for it.  The SSMA tool was just recently updated to provide support for migrations from DB2.  The other data platforms supported by SSMA are Oracle, Sybase, and even Access.  Not only can the SSMA tool help an organization migrate to SQL Server on-prem, but also to the cloud even to a SQL Azure Database.  

    Migrations are only a portion of DB Best’s portfolio of services. Consolidation, Private/Public/Hybrid Cloud, Upgrades, BI, Big Data, and Mobile Development are other services that are offered.  Part of my role is to work with customers to determine how to best optimize their experience with SQL Server, Azure, and other IT assets.  For example, I might be working with a customer who is migrating to SQL Server and I would enlighten them on the Possibilities of the environment that they are migrating to such as leveraging the Analytic and Reporting Tools that are part of the SQL Server ecosystem.

    I have always enjoyed seeing that lightbulb go off in someone’s head as I describe a concept or idea that fits their needs.  Before entering the consulting world full time over 10 year ago, I was on the full-time faculty at High Point University.  Seeing those lightbulbs go off is very satisfying and is probably one of the reasons why I became so involved in the SQL Server Community years ago.

    In this new role, I look forward to having the lightbulb lighting up over my head as I encounter new environments and hope to continue to light up other people’s lightbulbs on a continuous basis.

     

     

More Posts Next page »

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement