The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
Happy President's Day 2009
Steve Jones takes a break today and gives you a fun reel of mistakes and bloopers.
SQLBits IV and a Day of Training
SQLBits IV is taking place this March in Manchester. Read on about where to register and how to get some training the day before as well.
State Models - Database Weekly (Feb 16, 2009)
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
Securing SQL with access control and login monitoring
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
SQL Server 2008 Installation Process
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
Things I Wish I Had Known
I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question. This one asks, “What do you wish you had known when you started?” I could go on for hours about the things I wish I hadn’t had to learn the hard way, but..
Things You Know Now…
Someone tagged me, and I’ve lost the email in all the pile up from vacation where I was very, very unwired from work, despite being wired to the world. Actually I’ll make that one my first thing: Know When to Walk Away Not quit, not stop progressing on...
Conservative or Risky?
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
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