SQL Server – Finding TCP Port Number SQL Instance is Listening on
By default SQL Server listens on TCP port number 1433, and for named instances TCP port is dynamically configured. There...
2013-05-07 (first published: 2013-05-01)
4,843 reads
Colorado SQL Events : May 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-05-01
620 reads
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.
We came across a scenario where database bak files being created from long time which are no more in use...
2013-04-30
1,111 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,614 reads
Enhance your career by blogging!
When I started my blog two years ago, I never would have thought how much it would help my career. I...
2013-04-30
2,849 reads
SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,571 reads
Looking Forward
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,413 reads
Five Ways to Improve Your Productivity with SSMS
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,719 reads
My First White Paper – Top 10 Tips for Optimizing SQL Server Performance
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...
2013-04-30
1,432 reads
SQLDiva reviews the First PASS Business Analytics Conference
Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at...
2013-04-29
1,311 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers