Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,823 reads
Maximum number of rows per data page and minimal record size (SQL Server storage internals)
Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße
(DE)
In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch...
2014-10-29
1,472 reads
Add Database File on Database invloved in DB Mirroring
MSSQLFUN
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...
2014-10-29
698 reads
Add Database File on Database invloved in DB Mirroring
Add Database File on Database invloved in DB Mirroring.
2014-10-29
530 reads
Porto.Data
I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November...
2014-10-29
142 reads
SQL Server – Failed to bring availability group ‘[availability group name]’ online
I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON...
2014-10-28
2,006 reads
How to take differential backup ? TIP #67
Friends,
We were discussing backup from last few post. Now lets take a look one more feature of backup which is...
2014-10-28
542 reads
Ghosts – an eXtrasensory Experience
Really, at this point what is there that hasn't been done about the ghosts? Well, if you are well tuned to these apparitions, you may have received the urge...
2014-10-28
17 reads
Ghosts – an eXtrasensory Experience
This is the last article in a mini-series diving into the existence of ghosts and how to find them within...
2014-10-28
775 reads
Session: Introduction to Powershell Cmdlets for DBAs
I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged...
2014-10-28
886 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers