Tips for Upgrading a Cluster to SQL 2008 - Part 1
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
TSQL Challenge 69 - Find the most relevant advertisement based on keyw
Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.
Webinar: Whatever your source control system - seamlessly link it to SQL Server
In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.
We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.
Window Functions in SQL Server
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
First Impressions
Today we have a guest editorial from Andy Warren that examines the first impressions that you create when you meet someone.
Organizational Approaches to Master Data Management
This series of technical articles describes organizational approaches to master data management.
Using and Creating Mount Points in SQL Server
This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.
Resource Governor
If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you need to ensure that workloads get the memory or CPU they need according to certain priorities, then you need Resource Governer, and you need Roy Ernest's clear explanation of the technology.
License By Core
Microsoft recently announced changes in the licensing for SQL Server 2012 and Steve Jones has a few thoughts on the topic.
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers