Configuration of Azure SQL Database Auditing
This article shows how you can configure auditing on your Azure SQL Database.
Understanding the Importance of Data Lineage in Modern Data Management
Data lineage is a component of modern data management that helps organizations understand the origins, transformations, and movement of their data. It is like a road map that shows us where our data has been, how it has changed, and where it is going, just like tracking the journey of a package:
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 3: The Database Class
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
The Voice of the Customer
This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to […]
Top of Your Profession
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
WhatsApp +52 6643030891 Get A1, B1, C2 telc zertifikat without exam
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Get TELC Zertifikat B2 Without Exam in * Slovenia WhatsApp +52 6643030891
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers