Almost every DBA will be asked to change data in production at some point. Too often we don't have the tools to allow users to correct errors, but when you make changes, Steve Jones reminds you that you need to be careful and still have a process.
2011-05-31
235 reads
2011-05-30
74 reads
Today Steve Jones asks how you handle those passwords across time for backups in this week's Friday poll.
2011-05-27
182 reads
Can greedy executives be good for IT? Steve Jones thinks so and gives us a few reasons today.
2011-05-26
199 reads
Steve Jones thinks that the Millennials have the right approach to work. There are many things that are more important than money.
2011-05-25
289 reads
IT is too slow. That was a quote that inspired this piece from Steve Jones that talks about the need for IT to be more flexible and agile in their efforts. That includes the data professional in their modeling.
2015-10-27 (first published: 2011-05-24)
259 reads
This week Steve Jones reminds us that improving performance in T-SQL is not always obvious. Those little nuggets of knowledge can be very handy, which is why you should be regularly looking to acquire more of them.
2011-05-23
180 reads
Today we have a guest editorial from Andy Warren. Andy talks about your annual review and how you might want to think about negotiating for a raise in advance.
2011-05-23
194 reads
This Friday Steve Jones wonders what types of bugs you find in software. Are there more prevalent because of design or coding?
2011-05-20
136 reads
Today we have a guest editorial from Andy Warren. Most people get an annual review that determines what their salary change might be for the next year. Does 3% make a difference? Andy Warren asks the question today.
2011-05-19
269 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item 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