Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
2010-11-17
307 reads
Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.
2010-11-16
229 reads
We have to provide security for our data, and to some extent that means verifying who has access. SQL Server has limited means for doing this other than relying on the OS, but Steve Jones has some ideas on how to make this more secure.
2010-11-15
136 reads
This past week saw the next version of SQL Server, code named Denali, released as a public CTP. Steve Jones comments on the new version.
2010-11-15
324 reads
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
2010-11-12
885 reads
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
2010-11-11
350 reads
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
2010-11-10
118 reads
A number of companies came together to develop a code of conduct recently for software vendors. Steve Jones thinks this is a good idea.
2010-11-09
218 reads
Today we have an older editorial by Steve Jones being republished. This piece talks about security and why it might be a good idea to write down those passwords.
2010-11-08
276 reads
This Friday Steve Jones asks the question about how you manage large numbers of SQL Server instances.
2010-11-05
215 reads
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers