One piece of advice that is often given to new SQL Server administrators is not to shrink their databases. But they seem to do it often enough anyway. For this Friday's poll, Steve Jones asks if we should do away with shrink.
2010-12-10
981 reads
Microsoft is working to certify vendors to build private clouds, which Steve Jones thinks is a great idea.
2010-12-09
171 reads
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
2010-12-08
112 reads
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
2010-12-07
105 reads
If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?
2010-12-06
513 reads
We are always looking for more speed from our computer systems, but are they getting faster? Steve Jones has a few comments on why this might not be the case.
2010-12-06
158 reads
Today Steve Jones has a poll that asks about your work environment, and specifically what type of noise works best for you.
2010-12-03
195 reads
Do we need new technologies to handle the large scales of complex data analysis? Steve Jones thinks SQL Server can handle the load.
2010-12-02
111 reads
Today Steve Jones talks about the reasons why you might change jobs, and the fact that you aren't alone. However be careful about changing jobs, and make an attempt to stay if you can.
2010-12-01
276 reads
Performance is always one of the most important things a DBA can learn to deal with. It's also one of the more nebulous arts to learn. Today Steve Jones shares some thoughts on how we might better help people learn.
2010-11-30
384 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