Hi There, We are working on the 2023 Learning Calendar and need your input. Let us know what would you like to learn. Based on the topics you suggest to us, we will organize webinars, virtual events & chat shows with industry experts. Click here to give us your topics. Meanwhile, here are some important reminders: #First Data Platform Summit recorded classes (Pre-Cons & Post-Cons) are now available at 75% off the list price. Use the discount code BLACKFRIDAY. These in-depth training classes were delivered at DPS 2022, 2021 & 2020 and were recorded so that we can share them with the ..read more

Hi There, We are writing to you after a while, hope you are doing well. We have loads of SQL & Data learning opportunities for you. #First Data Platform Summit recorded classes (Pre-Cons & Post-Cons) are now available at 75% off the list price. Use the discount code BLACKFRIDAY. These in-depth training classes were delivered at DPS 2022, 2021 & 2020 and were recorded so that we can share them with the community. They offer 8-hrs deep-dive content. So go ahead, and explore the classes that suit your job & career goals. There are more than 50 such classes to choose from. Explore ..read more

Hi There, We are writing to you after a while, hope you are doing well. You will be happy to know that the breakout session recordings from Data Platform Virtual Summit 2022, are now available. To access the recordings, Click Here. DPS 2022 has dozens of sessions around SQL technologies including SQL Server, Azure SQL, SQL Managed Instance, SQL on Linux, Kubernetes, Azure SQL Hyperscale, and more. How to access the content? Step 1: Become a DPS member. There is no cost. Absolutely free. Click Here. Step 2: Log in. Step 3: Access the content. Click Here. (Please refresh (CTRL + F5) after login ..read more

This article first appeared in the SQLServerGeeks Magazine. Author: Josephine Bush . Subscribe to get your copy. In this article, you will learn about centralizing and reporting on auditing data in SQL Server and Azure SQL. In previous issues of SQL Server Geeks Magazine, I described how to set up SQL Server Audit and Azure SQL auditing. An important part of auditing is being able to easily query the data and report on it. SQL Server Audit Centralization Each of my production servers has a SQL Server Audit setup. These collect permissions and schema changes for that server. I want all producti ..read more

Hi There, Three learning avenues for you. #1 DataPlatformGeeks Community has announced weekly webinars. Each Thursday at 9.30 am EDT, starting from June 16 until Aug 11. Learn more. #2 Data Platform Summit 2022 Pre-Cons are announced. Learn More. #3 SQL Tutorials. Explore. Do forward this email to your team members. Stay tuned. More learning content coming your way. Regards SQLServerGeeks Would you like to continue receiving info about more learning opportunities? If yes, please subscribe to our new list. Did you know that there are 30+ Video Courses (Recorded Classes) available at PeoplewareI ..read more

This article first appeared in the SQLServerGeeks Magazine. Author: Josephine Bush Subscribe to get your copy. In this article, you will learn about the different methods for auditing in Azure SQL Database and Azure SQL Managed Instance. For a summary of what auditing is, please refer to the July SQL Server Geeks magazine. Here’s a quick summary of the different ways you can audit based on the different cloud offerings. To learn more about extended events or SQL Server Audit, please refer to the July, August, and November issues of SQL Server Geeks magazine. You have a few options for auditin ..read more

In today’s blog, we will be looking into SQL Server Query Cost, Memory Grant & SQLRESERVATIONS Clerk. Every query has a cost, which SQL Server records in the Execution Plan. This is the cost assigned to the query by the optimizer. While troubleshooting query performance in SQL Server, it is crucial to be are aware of this cost. In many cases, queries are sorting and hashing as a result of internal operations. For such queries, SQL Server requires an additional memory grant which is requested from a clerk called SQLRESERVATIONS. For this demo, we will be using the AdventureWorks2014 databas ..read more

In today’s blog, we are going to be talking about Buffer Pool Usage. This is the first of many blogs we will be creating about SQL Server Memory Troubleshooting. This blog is inspired by a very common question that comes up in forums where we find DBAs complaining about SQL Server hogging up memory. The first thing we need to understand is SQL Server loves memory, as it allows it to cache a large number of data pages and index pages in memory so that they can be served faster to the clients when required. Our prime objective is to find out which aspect of SQL Server is consuming memory. It’s a ..read more

Hi There, Our learning partner, SQLMaestros, is kick-starting the SQL Server Performance Tuning Master Class from Feb 14. It is a 40-hour deep-dive content, the most comprehensive training you will ever receive on the subject. Talk to your manager and get sponsored. Learn more. Not interested? No worries, take a look at new learning content: #1 New SQL Tutorials: Find most expensive IO queries SQL Server Statistics Histogram in action What is the execution time? Browse here. #2 Highly rated SQL articles from 2021 are included in the January 2022 edition of the SQL Magazine. Download your co ..read more

This article first appeared in the SQLServerGeeks Magazine. Author: Satya Ramesh. Subscribe to get your copy. In this blog we will prove the point that both the truncated and deleted data can be rolled back, if they are used in certain transactions with a proper database backup and restore mechanism. Without any further delay let’s get in to the demos. Let’s create TruncatevsDelete database and then two tables DeleteTest & TruncateTest --Step 1: Execute the following statement(s) to create a database USE [master]; GO IF EXISTS ( SELECT name FROM sys.databases ..read more