Introducing SQL+ Dot Net
SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.
Back to Basics; Masking Address Data
Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking technology in SQL Provision.
The Performance of Window Aggregates Revisited with SQL Server 2019
T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.
Pages and Extents: Stairway to SQL Server Indexes Level 4
We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.
The Data Incident
Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.
One-way and Two-way Tabulation Example in SQL Server - Part 2
In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.
Transform your SQL Server permissions
SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.
SSIS: Read Event viewer with WMI Data reader
Access OS event viewer and read it from a SSIS package using WMI Data reader task
The Creepiness of AI
It seems that many companies are implementing AI into their systems. Steve notes that this isn't always a good idea.
Blogs
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers