The Afternoon Whistle
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
2010-02-18
114 reads
Editorial
The R2 Penalty
An interesting point was made by a reader about the price of SQL Server licenses when R2 is released. Steve Jones comments about a penalty that some of you may find if you look to build a SQL Server 2008 server later this year.
2010-02-17
259 reads
The Average Joe
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
2010-02-16
412 reads
President's Day 2010
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
2010-02-15
41 reads
The Community Has Been Heard
Steve Jones talked about the announcements of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 in this editorial.
2010-02-15
171 reads
Safety in Numbers
One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.
2010-02-12
123 reads
When is 8000 too small?
Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
390 reads
The Best Laptop
Steve Jones recently went on a search for a new laptop, looking for the "best" one for him. But what it the best? And is it worth pursuing?
2010-02-10
509 reads
An Administrative Security Hole?
Is it a problem for SQL Server to have a backdoor that lets a Windows Administrator connect as a sysadmin? Steve Jones thinks so and gives a reason why this might be a problem.
2010-02-09
206 reads
Measures and Rules
Today we have a guest editorial from Grant Fritchey that discusses the idea of rules based on certain types of measurements. Are they worth following? Or do we need to develop our own measures.
2010-02-08
369 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers