A New World Record
SQL Server 2008 sets a TPC record. And it hasn't even been released. This editorial was originally published on Mar 4, 2008. It is being rerun as Steve is on vacation.
2008-03-04
164 reads
Editorials
How to lay out SQL Code
Anyone who inherits a database application dreads poorly laid-out SQL code. Development teams loathe it. Putting it right would be easier, if there was a common, agreed, standard in place, so why the difficulty?
2008-03-03
225 reads
Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know. This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday.
2008-02-29
123 reads
The February Energy Update
Steve Jones takes a look at the world of energy news and a few projects out at the ranch.
2008-02-28
61 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-27
72 reads
2008-02-25
25 reads
Not Connected
Do you know how to suggest improvements or features for SQL Server? Or report bugs? You use Connect, but it needs some work before it will really help the product.
2008-02-25
71 reads
Give and Take
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-22
39 reads
2008-02-21
176 reads
2008-02-20
90 reads
Blogs
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
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