Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
130 reads
Editorials
2022-05-06
75 reads
Project Zero for Better Security
Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.
2022-05-04
95 reads
2022-05-02
89 reads
What will convince you to upgrade?
You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]
2022-04-30
117 reads
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
2022-04-29
125 reads
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
1,045 reads
The Craziness of Code
Building software can seem like a crazy process, especially to a developer who joins a project.
2022-04-25
254 reads
Scripting Makes Mistakes Easier Than Ever
A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
181 reads
Using T-SQL over PoSh
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
2022-04-20
170 reads
Blogs
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Advice I Like: Tipping
By Steve Jones
When in doubt, overtip – from Excellent Advice for Living This is close to...
Forums
How Much AI Code Would You Use?
Comments posted to this topic are about the item How Much AI Code Would...
Browsing for Instances
Comments posted to this topic are about the item Browsing for Instances
Creating a Date Dimension (Calendar Table) in SQL Server
Comments posted to this topic are about the item Creating a Date Dimension (Calendar...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers