Steps to Configure SQL Server to Listen On A Specific TCP Port
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,271 reads
Time to find a new place to live
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
276 reads
Linguistics Crisis In Microsoft Technology
With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product...
2018-01-24 (first published: 2018-01-15)
1,715 reads
Object Explorer Drag-N-Drop (Day 14)
Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...
2018-01-14
315 reads
The SSMS Super Clipboard (Day 13)
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
400 reads
tsqlt Tests for Advent of Code 2017 Day 2
This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-13
887 reads
When it’s cold outside, perhaps Power BI heat maps can warm you up
(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...
2018-01-23 (first published: 2018-01-13)
1,843 reads
Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
318 reads
Alwayson Availability Groups vs Alwayson Failover Cluster Instances
SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...
2018-01-22 (first published: 2018-01-13)
51,452 reads
Changing Case (Day 12)
In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...
2018-01-12
294 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
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...
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