Reblog: May 24 to May 30
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-31
1,173 reads
TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,537 reads
SQL and Relational Theory
Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...
2013-05-31
1,008 reads
Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM
In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use...
2013-05-31
1,721 reads
Exploring a Database in Azure
After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied...
2013-05-30
1,658 reads
SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances
One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying...
2013-05-30
1,544 reads
Security Questions: TRUNCATE TABLE Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-30
1,713 reads
Ralph Kimball Books
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:
The Data Warehouse Lifecycle Toolkit: Practical...
2013-05-30
2,555 reads
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,385 reads
I am Speaking at 2013 PASS Member Summit!
Speaking at PASS Summit 2013
Every single year I look forward to the PASS Member Summit. In a nutshell it is...
2013-05-30
1,284 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