sp_SrvPermissions
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...
2013-08-19
1,487 reads
CDC changes column-by-column instead of row-by-row, can you improve it???
I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...
2013-08-19
661 reads
Fixing Page Life Expectancy (PLE)
What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...
2013-08-20 (first published: 2013-08-19)
4,799 reads
Why the MS Power Query (PQ) for Excel is an invaluable Business Intelligence tool
Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...
2013-08-22 (first published: 2013-08-19)
4,963 reads
Introducing Python in Hadoop World
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...
2013-08-18
55 reads
Reblog: August 9 to August 15
This reblog post should have come out last Friday, but I was on vacation and I didn’t want any new...
2013-08-18
463 reads
Introducing Python in Hadoop World
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data...
2013-08-18
588 reads
SQL Saturday #235 New York City Wrapup
Today I had the pleasure of speaking at the SQL Saturday #235 in New York City. Talk about an absolutely...
2013-08-17
705 reads
24 Hours of PASS Q & A: Why are Bit’s Flipped?
http://bit.ly/16UyEPHHello Dear Reader. Almost two weeks ago I delivered a presentation for the 24 Hours of PASS on SQL Server...
2013-08-16
946 reads
Restore SQL Server databases remotely using my SQL CLR
Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...
2013-08-21 (first published: 2013-08-16)
4,844 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers