Daily Coping 18 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-18
20 reads
Blog Posts
Cool Stuff in SQL Server 2022 – IS DISTINCT FROM
I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was...
2022-08-17 (first published: 2022-08-04)
1,266 reads
Daily Coping 17 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-17
19 reads
Working with Neo4j Imports–I HATE CASE SENSITIVITY
I’ve been working to better understand graph databases and where they can be useful. There is a file from Neo4J that comes with the Desktop and contains a data...
2022-08-17 (first published: 2022-08-08)
239 reads
Daily Coping 16 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-16
21 reads
SQL Server Query Tuning and Optimization by Benjamin Nevarez
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as ... Continue reading
2022-08-16
148 reads
Creating a HEAD utility for Windows 10
One of the things I did often in my first career job was create utilities that we could use as a network support team. I was an intern coming...
2022-08-15
104 reads
Daily Coping 15 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-15
19 reads
Max server memory recommendations are just a suggestion
Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has...
2022-08-15 (first published: 2022-08-03)
422 reads
Slides from SQL Saturday Los Angeles 2022
If you attended my talk at SQL Saturday Los Angeles 2022, then you can get my slides here: Adopting a DevOps Process for your Database.
2022-08-15
23 reads
Blogs
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...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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