MySQL supports stored procedures for your business logic. Here is how to create a stored procedure in MySQL and execute it, with a simple sales example.
SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
I was once corrected on Page Life Expectancy. Here my friend Tim Radney explains in simple words what a good value for Page Life Expectancy really is.
SQL SERVER – Synchronize Data Exclusively with T-SQL
Many tools sync data between databases. Here I build the functionality to synchronize data exclusively with T-SQL, step by step, from structure to triggers.
SQL SERVER – Faster Application Performance with In-Memory OLTP
How in-memory OLTP engines give faster application performance and better scalability for SQL Server databases, with a focus on SQL Server 2014.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.
SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner
There are few feelings which are hard to describe in words as this note is about an amazing event on the C Sharp Corner.
When In-Memory OLTP Helps and When It Does Not
Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.