Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,404 reads
Blog Posts
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,379 reads
New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
630 reads
SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,663 reads
Book Review - The Checklist Manifesto
Andy Warren recommended The Checklist Manifesto to me and after seeing his review, I decided to grab it. It’s written...
2010-11-26
1,855 reads
Do You Protect Your Passwords?
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
681 reads
What Am I Thankful For
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
980 reads
Leading the Albanian PASS Chapter
Yesterday, I have received the official email from the PASS HQ, and the confirmation that now I'm the leader of...
2010-11-25
825 reads
Are You Ready to Move to SharePoint for Microsoft BI?
I’m interested in hearing your response to this question. Microsoft is investing
aggressively in delivering Business Intelligence as a holistic platform...
2010-11-24
539 reads
Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
932 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
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