Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases
Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...
2007-11-07
791 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
SQL Server: Showing permissions for a given database user
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
616 reads
Becoming a DBA, Part II
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
921 reads
The Impact of Architecture/Design Choices
I try my best to get things right the first time. So often, correcting a mistake or bad choice is...
2007-11-05
689 reads
Online Resource: Safari Tech Books Online
I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...
2007-11-02
866 reads
Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs
As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...
2007-11-01
2,195 reads
Tool: KeePass Password Safe password manager/vault
Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...
2007-10-31
2,619 reads
SQL Server: Listing all the database roles for a given database user
SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...
2007-10-30
2,573 reads
Becoming a DBA, Part I
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,680 reads
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,468 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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