Give and Take
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
36 reads
Articles
Storing Images and BLOB files in SQL Server Part 2
Part two of this article focuses on using the SQL Server Binary data type to store small image files.
2008-02-21
3,478 reads
The Stewardship Approach to Data Governance: Ch. 6
This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.
2008-02-21
1,328 reads
Securing the SA Account in SQL Server 2005
SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks
you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account.
2008-02-20 (first published: 2007-03-14)
16,629 reads
New Data Types in SQL Server 2008 Part 2
In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.
2008-02-20
4,301 reads
Add Custom XML Documentation Capability To Your SQL Code
By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.
2008-02-20
2,980 reads
2008-02-20
29 reads
2008-02-20
37 reads
2008-02-20
47 reads
5 Tips for Becoming a Better Data Modeler
5 quick tips to help you become a better data modeler and increase your value to your team and organization.
2008-02-19
12,079 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers