Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-22
542 reads
Editorials
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-21
88 reads
The Skill Set of the Exceptional DBA
In my previous editorial on this topic, I stated that the An Exceptional DBA is defined more by what they do than what they know. Judging by the responses, there is little disputing this fact among DBW readers. However, before we accept technical knowledge as a "given", and move on, I'd like to consider the […]
2008-04-21
1,342 reads
Up or Down?
How does the job market look this year for DBAs? Steve Jones asks the SQL Server community for their thoughts on the current employment outlook.
2008-04-18
243 reads
Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-16
252 reads
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
2008-04-14
94 reads
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
2008-04-14
206 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-11
129 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-10
72 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-09
124 reads
Blogs
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...
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
Forums
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...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
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