Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,031 reads
Blog Posts
[SQL Snacks Video] Importance of COPY_ONLY Backups
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
695 reads
Forcing Results To Conform For Exports
This one is a bit off for me. I've had to make SSIS exports kick out in specific ways such...
2014-01-29 (first published: 2014-01-27)
1,534 reads
Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,504 reads
Master Data Services for the Beginner Part 02
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,246 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,121 reads
New SSIS Training Class from Andy Leonard
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...
2014-01-29
1,411 reads
Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
553 reads
SQL Server Data Compression
SQL Server Data Compression Overview
I have been reviewing the options for data compression in SQL Server and believe it can...
2014-01-29
1,299 reads
SQL Server Quickie #10 – Forwarding Records
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-29
782 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
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