Losing Data
As data professionals, we want to avoid losing data. We won't always be successful, but we can avoid making the easy mistakes.
2013-06-17
104 reads
Editorials
Trust
Why does the IT industry seem to act and run so differently than many other industries? Steve Jones takes a stab at explaining this.
2013-06-17
130 reads
Do You Want a Meritocracy at Work?
The best at their crafts are usually the most rewarded in sports, but not necessarily in other fields. This week Steve Jones asks if you would like it to be different?
2013-06-14
185 reads
Data Vision
Computer vision has been something that researchers have worked on for years. We have no shortage of cameras, and we are starting to see the computing systems behind these devices starting to actually understand what is being seen. That understanding is very valuable. Will we see something similar happening in our SQL Server technologies?
2013-06-12
98 reads
The Watson Service
IBM's Watson project continues to grow and the latest implementation might be one that affects many of us in our daily lives.
2013-06-11
114 reads
No R2
The next version of SQL Server was announced last week and Steve Jones is pleased with the name.
2013-06-10
304 reads
When Windows don’t provide illumination
Microsoft through its various GUIs tries hard to "protect" users from SQL, but Phil Factor argues that we don't need protection from code. We just need a better way to "document" the syntax.
2013-06-10
146 reads
The Decision to Fail
When a disaster occurs, the response from your organization isn't always pre-determined. There are times when you might not want to failover to secondary systems, especially if you don't expect the disaster to last long. How do you decide when to fail over?
2013-06-07
119 reads
Quickly Copy Data
Moving data around can be a challenge as the sizes of our databases grow. Steve Jones talks about some of the challenges and some creative ways you might consider moving data.
2013-06-06
278 reads
Fear Fear
Do you let your fear drive you in how you work with technology? Steve Jones thinks you should be cautious, but not paralyzed.
2013-06-05
136 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