What Is Using The Most Space In Your Database ?
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database...
2009-10-14
799 reads
Glenn Berry
New Dell PowerEdge R710 Database Server
My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and...
2009-10-09
1,788 reads
SQL Server Announcements From Microsoft
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for...
2009-10-09
890 reads
What a backed up Database Mirror looks like
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t...
2009-10-09
1,314 reads
A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,392 reads
Very Useful SQL Server 2008 High Availability White Paper On MSDN
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
775 reads
Updated SQL Server 2008 Diagnostic Information Queries
Here is the October 2009 version of my SQL Server 2008 Diagnostic Information Queries. They are very useful for gathering...
2009-10-07
1,792 reads
More SQL Server Benchmarks From AnandTech
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist...
2009-10-06
804 reads
A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
608 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,559 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