Hearing Responsibility
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
706 reads
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,972 reads
Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-11 (first published: 2016-06-29)
88,735 reads
If You Need to Think, You’re Doing It Wrong
A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...
2016-06-29
660 reads
Introducing SQL Server Reporting Services
In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up...
2016-07-12 (first published: 2016-06-29)
3,148 reads
Automatic Seeding Very Large Databases in SQL Server 2016
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new...
2016-07-12 (first published: 2016-06-29)
3,708 reads
Speaking at PASS Summit 2016
I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of...
2016-06-29
410 reads
Summit Submission Feedback Response
I’m It Survival Tips for the Lone DBA – Level 100
(Not Accepted: Higher rated session selected)
Track: Professional Development
As others have done I...
2016-06-28
224 reads
Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,518 reads
Better ReadyRoll Script Naming
One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are...
2016-06-28
633 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