PASS Summit 2018 – Keynote Day 1 Live Blog
Today is the first full day of the PASS Summit in Seattle, Washington. This is the 20th year of the...
2018-11-07
309 reads
Tim Mitchell
Where Are Your Data Leaks?
It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis....
2018-10-02 (first published: 2018-09-25)
1,952 reads
Speaking at PASS Summit 2018
I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November....
2018-06-06
291 reads
Temp Tables in SSIS
Temp tables are very handy when you have the need to store and manipulate an interim result set during ETL...
2018-05-29
459 reads
Managing Business Logic
Encapsulating business logic into data movement and presentation is a critical part of a stable information management strategy. Too often,...
2018-05-17
299 reads
Trading Data For Convenience
If data is the new oil, then the web is the world’s biggest gas station. Every day a few billion people...
2018-05-08
268 reads
Using SQL Server Management Studio Projects
One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...
2017-12-22
544 reads
A Business Lesson from an Oil Change
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
383 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
344 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
396 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