2012-09-19
185 reads
Editorial
Compress Everything
Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.
2012-09-18
268 reads
Three Rules for Database Development
Today Steve Jones talks about a series of rules he found for database development.
2012-09-17
595 reads
A Quick Count
This Friday Steve Jones wants to know if your career is also helping your wardrobe. (This editorial was originally published on Aug 23, 2007. It is being re-run as Steve is on vacation.)
2012-09-14
178 reads
More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
2012-09-13
170 reads
Creativity
What if you could stop all work for a month and have people find ways to improve the business? Would you take the chance?
2012-09-12
155 reads
Mining and Algorithms
The algorithms that you use to query or mine data are very important. Amazon knows their recommendations algorithms are important. Do you know what's important in your job?
2012-09-11
272 reads
Document First, Code Later
Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.
2012-09-10
289 reads
A Cloudy Future
The future of employment in the technology industry means learning to do more with less.
2012-09-10
137 reads
The Dream Machine
This Friday Steve Jones has a fun poll. If your new boss told you to spec out a machine, what would you choose?
2012-09-07
140 reads
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