Using Microsoft Hyper-V for SQL Server consolidation
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...
The 10 Essential Rules of Dimensional Modeling
Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
Barriers to Virtualization
Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?
Best of SQLServerCentral, Volume 6
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
SQL Server Profiler Part 2: Custom Templates and Saving Data
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
Determining the source of full transaction logs
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week! Some quick observations: The build quality is outstanding. Nothing cheap at all about this card. The engineering that has gone into this shows in every way. It is made up of modules that...
Blogs
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,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Forums
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...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
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