Introduction to Integrity: Chain Linkage Problems
We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...
2013-09-17
1,150 reads
Blog Posts
Manage your SQL Server databases with SQL DMVs
Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use to manage their SQL Server environment....
2013-09-17
827 reads
Planning for Recovery
A database server is generally a mission critical component. Having a recovery plan is essential to ensure the business can...
2013-09-17
436 reads
SQL 2014 SSMS is Killing my C:
I could hear SQL saying to my C: Drive "Why You Little...." Hello Dear Reader!
The Blog about SQL Saturday 232 coming...
2013-09-17
1,103 reads
SQL Server – How to Add More Than One Column as a Primary Key
Sometimes you might want to add more than one column as primary key. For example, if you have three columns...
2013-09-17
617 reads
SQL Server Data Tools (SSDT) – August 2013 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: August 2013 version: 10.3.30822.0, June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0,...
2013-09-17
1,246 reads
Understanding SQL Query Optimization – (Part 1)
Most of the activity of the database server is related to queries. Because of this, query optimization is often a...
2013-09-17
998 reads
Understanding SQL Server Full-text Indexing – (Part 1)
SQL Server allows applications and users to execute full- text search queries against character based data in SQL Server tables....
2013-09-17
646 reads
Understanding SQL Server Full-text Indexing – (Part 2)
Checkout the final part of this two part article series here, in which I discussed how to create full-text index...
2013-09-17
557 reads
Understanding SSIS Package Configurations
Managing changes to environment dependent variables is common and critical in any ETL application, especially during deployment of SSIS packages....
2013-09-17
772 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: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers