More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren't always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.
2019-04-18
323 reads
Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so […]
2019-04-17
212 reads
Most of us work with the time in a variety of ways in our applications. Temporal tables use the time on the server,but Steve notes today that we might want to capture other types of time.
2019-04-16
332 reads
Someone tried to build a database engine from scratch. While not something Steve wants to do, it's an interesting exercise.
2019-04-15
1,470 reads
2019-04-13
200 reads
Building software for the cloud often requires some changes. This week Steve wonders how many of you are making the effort.
2019-04-12
182 reads
I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I'm gone. As my kids have gotten older, I'm have less commitments at home and an extra night during a […]
2019-04-11
227 reads
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
2019-04-10
563 reads
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,824 reads
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
692 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers