Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all the fun and exciting new changes. Are you as thrilled as we are? Start your modernization journey now!
Recently Microsoft introduced SQL server 2022, the most hybrid SQL server version we have ever known. These are exciting times! There is so much going on with the Microsoft data platform that it is hard to keep up with all the different new things that are being released. The number of feeds with new extensions, new plug-ins, new tools is gigantic! We love it!
It doesn’t matter if they are small or big, we can always learn something from them and use those tools to serve our customers, our business better in their day-to-day operations.
With the introduction of SQL server 2022, SQL server 2012 came to an end. After ten years, the time is there to decommission those SQL server versions. SQL Server 2012 meant the start of a new generation of SQL servers. The first of its kind where Microsoft introduced Always on Availability groups.
It feels like yesterday when I first touched the availability group feature. I remember I was so enthusiastic when I first saw this in action. I’ve installed and set up many different SQL servers and versions over the years and I’m always amazed at what new features are shipped within every release.
This post would become too large when going into detail on all the different cool features. Therefore, a new series is coming up on our Kohera blog. Keep an eye on our website.
The most important message we want to give you with this post is that it’s time to start your data modernization journey. You are missing out on all the fun and exciting new changes.
Even if you run SQL server 2022 on an Azure SQL VM (IaaS) in the cloud, there are cool things waiting for you, like the SQL IaaS extension which allows you to manage your Azure SQL VM in a more efficient way. And not to forget, all the other features available natively inside SQL server 2022.
Kohera can help and assist you along the way. At Kohera we believe in a phased approach. We have created a data(base) modernization program to help you navigate through all the hurdles you need to take.
The program consists of different phases. Each phase with its own focus and next steps.
We start by giving an inspirational workshop, based on Microsoft best-practices and Microsoft Immersion Workshop material. This workshop gives you insights into the different possibilities and tiers and allows you to work together hands-on in lab environments. This way, you already familiarize yourself with the different options.
In the following phase we will do a full assessment of your environment to make sure we have the complete scope. Based on this assessment we will create a first blueprint of what could become your new SQL fleet or SQL Server estate.
In this phase we will also offer a POC to already migrate and modernize some of the databases. This will show you the potential of opportunities you will have when the whole environment is modernized.
The next phase will consist of a full project phase and will contain the actual modernization of the whole SQL fleet. We will migrate and modernize the fleet based on the requirements, constraints, and feedback we gained during the assessment phase. We always do this in an iterative way to smoothen the process.
After migration and modernization is done, Kohera will keep on assisting you, choosing the right flavors. We can also take care of your whole SQL server fleet via support agreements.
Act now, your modernization journey starts here! We promise you; it will be fun, challenging, and instructive!
#happyquerying
© 2023 Kohera
Crafted by
© 2022 Kohera
Crafted by
Cookie | Duration | Description |
---|---|---|
ARRAffinity | session | ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user. |
ARRAffinitySameSite | session | This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie records the user consent for the cookies in the "Advertisement" category. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | CookieYes sets this cookie to record the default button state of the corresponding category and the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | The website's WordPress theme uses this cookie. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | Cloudflare set the cookie to support Cloudflare Bot Management. |
pll_language | 1 year | Polylang sets this cookie to remember the language the user selects when returning to the website and get the language information when unavailable in another way. |
Cookie | Duration | Description |
---|---|---|
_ga | 1 year 1 month 4 days | Google Analytics sets this cookie to calculate visitor, session and campaign data and track site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognise unique visitors. |
_ga_* | 1 year 1 month 4 days | Google Analytics sets this cookie to store and count page views. |
_gat_gtag_UA_* | 1 minute | Google Analytics sets this cookie to store a unique user ID. |
_gid | 1 day | Google Analytics sets this cookie to store information on how visitors use a website while also creating an analytics report of the website's performance. Some of the collected data includes the number of visitors, their source, and the pages they visit anonymously. |
ai_session | 30 minutes | This is a unique anonymous session identifier cookie set by Microsoft Application Insights software to gather statistical usage and telemetry data for apps built on the Azure cloud platform. |
CONSENT | 2 years | YouTube sets this cookie via embedded YouTube videos and registers anonymous statistical data. |
vuid | 1 year 1 month 4 days | Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos on the website. |
Cookie | Duration | Description |
---|---|---|
ai_user | 1 year | Microsoft Azure sets this cookie as a unique user identifier cookie, enabling counting of the number of users accessing the application over time. |
VISITOR_INFO1_LIVE | 5 months 27 days | YouTube sets this cookie to measure bandwidth, determining whether the user gets the new or old player interface. |
YSC | session | Youtube sets this cookie to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt-remote-device-id | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt.innertube::nextId | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
Cookie | Duration | Description |
---|---|---|
WFESessionId | session | No description available. |