And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
Custom Log Shipping
This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.
The T-SQL Quiz
Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.
Configure SQL Server Service Broker for Sending Stored Procedures
Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
Managing Disk Space
How often do you worry about your database size and free space? Steve Jones asks how you administer your SQL Server database space this Friday.
SQL Server 2008’s Management Data Warehouse
This article looks at the new Management Data Warehouse (MDW) that is incorporated into SQL Server 2008. This warehouse is performance analysis and capacity planning tool for DBAs. This article will discuss the basic architecture of the MDW and how to set it up using a wizard.
Should I Buy a Kindle?
Steve Jones still thinks there is a lot of value in books, both fiction and non-fiction, but he's looking at e-Readers, specifically the Kindle from Amazon.
And You Thought You Had a Big Database
Steve Jones examines what big is these days and a few examples of what the largest database people in the world deal with.
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