Free Online SQL Server Training for the Week of November 10, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
362 reads
Blog Posts
My 5 pieces of advice for new DBAs
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
811 reads
Recording of SQL Injection Webcast Now Available
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
1,695 reads
Recording of SQL Injection Webcast Now Available
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
366 reads
Removing HTML formatting tag - BR - from XML using XQuery
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,980 reads
Restore Script from Backup Directory – Modified
As a DBA your job is to protect the data, whether that be from corruption, attack, developers or any other...
2013-11-07
543 reads
Tabular model: Not ready for prime time?
While the tabular model in SSAS makes it much easier to build cubes than the multidimensional model, I am not...
2013-11-07
22,756 reads
The Powershell Challenge
I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve...
2013-11-07
1,417 reads
Transparent Data Encryption’s Dirty Little Secret
Remember when you were eight years old, how exciting it was to order some of those amazing products that were...
2013-11-07
939 reads
hacked
ugggh.
My Drupal site in AWS EC2 was hijacked and is being used by the hijackers to do port scans.
Who said...
2013-11-06
609 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