Deepthi Goguri

@dbanuggets@techhub.social
73 Followers
39 Following
16 Posts
Microsoft Data Platform MVP, Speaker, Data Event Organizer, FoRG, Masters in Computer Technology, Love to teach about SQL Server! Persevere, Inspire and Empower!

Thanks to BrentOzar for hosting this month of T-SQL Tuesday!
Here is my contribution #tsql2sday

https://dbanuggets.com/2024/02/13/t-sql-tuesday-the-last-issue-i-solved/

T-SQL Tuesday – The Last Issue I Solved

Thanks to BrentOzar for hosting this month of T-SQL Tuesday. Please find the original post here. Brent asked us to share the last issue that we resolved. I recently resolved a replication issue. I …

Deepthi Goguri's SQL Server Blog

Started blog series on SQL Server 2022
This post covers the Query Store Advancements in SQL Server 2022!

Learn how you can leverage Query Store and its advantages to the fullest and use it to improve the performance of your queries

https://dbanuggets.com/2024/01/22/sql-server-2022-query-store-advancements/

SQL Server 2022: Query Store Advancements

If you are not very familiar with the Query Store feature, please check my series of blog posts on Query Store here. In this post, you are going to learn about the advancements of the Query Store r…

Deepthi Goguri's SQL Server Blog

BLOG POST!

In my previous blog posts, I have blogged about the step by step guide on how to enable the Azure AD Authentication to on-prem SQL Servers. In this post, you will learn how to enable Azure AD Authentication for the SQL Server 2022 hosted on Azure VM.

#sqlserver2022 #sqlserverdba #azuresql #AzureArc

https://dbanuggets.com/2023/09/19/sql-server-2022-enable-azure-ad-authentication-for-sql-server-on-vm/

SQL Server 2022: Enable Azure AD Authentication for SQL Server on VM

To enable the SQL Server 2022 on a virtual machine to use Azure AD, we need below things: Managed identity and its permissions to query Microsoft Graph: When you enable the AD on the SQL Server 202…

Deepthi Goguri's SQL Server Blog
T-SQL Tuesday #165 – That Job Description I read and Couldn’t Stop Laughing!

Please excuse me if this post is going to be the funny one, yes it is! I would like to first thank my dear friend Josephine Bush for bringing up this great topic and asking us to write about how th…

Deepthi Goguri's SQL Server Blog

NEW BLOG POST!

SQL Server 2022: Step by Step Guide to setup Azure Active Directory Authentication for SQL Server

Take the advantage of using Azure Active Directory Authentication for SQL Server along with the Windows authentication. This step by step guide will show you exactly how to set this up in your environments!

https://dbanuggets.com/2023/08/04/sql-server-2022-guide-to-setup-azure-active-directory-authentication-for-sql-server/

SQL Server 2022: Guide to setup Azure Active Directory Authentication for SQL Server

Image Source Applicable to- SQL Server 2022 on-prem on Windows and Linux and SQL Server 2022 hosted on Windows Virtual Machines. Once you install the SQL Server, there are three different authentic…

Deepthi Goguri's SQL Server Blog

NEW BLOG POST!

In this post, follow this Step-by-Step Guide to Connect your SQL Server to Azure Arc which helps you connect your on-prem Servers to Azure and manage your Servers centrally in Azure portal

https://dbanuggets.com/2023/07/20/sql-server-2022-step-by-step-guide-to-connect-your-sql-server-to-azure-arc/

SQL Server 2022: Step-by-Step Guide to Connect your SQL Server to Azure Arc

When you install SQL Server 2022 through the GUI, you will see an option in the features “SQL Server Extention for Azure” Source If you are selecting this option, be ready to have all t…

Deepthi Goguri's SQL Server Blog

NEW BLOG POST!

What is Azure Arc Enabled SQL Server?

Are you on SQL Server 2012 or higher? Are you using resources outside of Azure and facing a hard time managing and keeping a check on your inventory, desperately needing a central location where you can list out and manage all your resources? Then you need to know about "Azure Arc"

Here is a simple blog post starting with a series on Azure Arc explaining what it is in this first post. Check it out here:

https://dbanuggets.com/2023/07/07/sql-server-2022-what-is-azure-arc-enabled-sql-server/

SQL Server 2022: What is Azure Arc Enabled SQL Server?

Azure Arc will offer the capabilities to manage your On-prem SQL Server instances, other Servers, and applications that are running outside of Azure. It is like a central location where you can see…

Deepthi Goguri's SQL Server Blog

This April 11th at 12pm EST, Mikey Bronowski is going to talk about “Is Your Job at Risk?
Strategies to Thrive in a World of Automation”

Register here:
https://meetu.ps/e/M0Bbs/NY0W4/i

See you soon!

Is Your Job at Risk? Strategies to Thrive in a World of Automation, Tue, Apr 11, 2023, 12:00 PM | Meetup

How can you use the power of PowerShell and AI to secure your career? Learn how to use PowerShell to create automated processes that can help you stay ahead of the curve.

Meetup

NEW BLOG POST!

Learn from SQL experts all about their favorite new features in Azure and SQL Server 2022 and why. Added bonus content on their New Year Resolutions😊

Here is the wrap up of February month of T-SQL Tuesday!

https://dbanuggets.com/2023/02/26/t-sql-tuesday-159-wrap-up/

#sqlfamily #tsql2sday #sql #azure #SQLServer

T-SQL Tuesday #159 – Wrap Up

Deepthi Goguri's SQL Server Blog

NEW BLOG POST!

In the Quick Track series for the beginner’s guide to Azure SQL, this day blog post is all about Authentication and Access management!

Learn about the Authentication and Authorization available in azure and how you can laverage the Azure Active Directory authentication for your Azure SQL Database.

Can you still use SQL Authentication? How does that work with Managed Instance and Azure SQL Database and how it differs with on-prem databases. Learn about the details in this blog post!

https://dbanuggets.com/2023/01/26/quick-track-beginners-guide-to-azure-sql-authentication-and-access-management/

Quick Track: Beginner’s Guide to Azure SQL- Authentication and Access Management

Deepthi Goguri's SQL Server Blog