Dodge, Dip, Dive, Duck, and Dodge
Laptop issues have Steve Jones upset with Toshiba. Today he talks about the obligations companies have to stand behind their support agreements and not try to dodge them.
2010-01-14
2,724 reads
Editorial - MP3
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
2010-01-13
2,500 reads
Goal Tuesday
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
2010-01-11
4,017 reads
Do You Want to Learn a Thing or Two?
A list of books to read in any area from an expert can be invaluable in growing your skills. Steve Jones talks about one list from Paul Randal, former SQL Server developer.
2010-01-11
4,103 reads
Balancing the Message
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
2010-01-08
4,408 reads
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
2010-01-07
2,498 reads
Be Prepared
Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
2010-01-04
2,707 reads
A New Beginning
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
2009-12-31
2,359 reads
The Year in Review - 2009
Steve Jones looks back at 2009 and examines some of the predictions he made at the beginning of the year.
2009-12-30
2,385 reads
Crash and Burn
A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.
2009-12-29
2,388 reads
Blogs
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
Forums
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Email change does not work
I changed my email address in Edit Profile page, but it has no effect...
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Question of the Day
Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers