The Reading Poll
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
T-SQL Best Practices
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Foreign Keys, Part 2 - SQL School Video
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When you factor in the complexities of Active Directory and SQL Server’s interaction with it fixing SSPI errors can be down right baffling...
Checksum Problems, Choosing the Correct Recovery Model and More
Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
Creating a table with horizontal partitioning in SQL Server
During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Blogs
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....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
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