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
659 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,788 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,958 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
54 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
462 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
945 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,832 reads
Traveling and Talking to Wrap Up 2013
I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly...
2013-08-16
601 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers