Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,750 reads
Acids and Databases: A look at ACID and transactions
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
167 reads
Happy Belated 150th Birthday Canada, and the Importance of Compliance, Especially Vulnerability Assessments
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
833 reads
DevOps–Fixing Poorly Named Constraints
I was building some code the other day and kept getting problems in my deployment for a change. The deployment...
2017-08-15 (first published: 2017-07-26)
1,760 reads
Performance is bad. Did you change anything recently? No. Are you sure?
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,211 reads
Speaking at TechMentor – Redmond
I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides you with in-depth, immediately usable training that will keep...
2017-07-26
15 reads
Speaking at TechMentor – Redmond
I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides...
2017-07-26
323 reads
Automatically restarting Docker containers
One of the problems that I’ve encountered since moving my Dev/QA departments to using SQL Server within containers is that...
2017-08-10 (first published: 2017-07-26)
2,504 reads
Power BI Custom Visuals Class (Module 61 – Power KPI)
In this module you will learn how to use the Power KPI Custom Visual. The Power KPI displays your KPI...
2017-08-08 (first published: 2017-07-25)
2,173 reads
SSoL: Where are my data and log files?
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-25
716 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