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,476 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
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,789 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
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
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...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers