Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4
How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
2009-04-10
3,074 reads
Articles
Using Check Constraints to Validate Data in SQL Server
A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.
2009-04-10
2,542 reads
An Interview with Brad McGehee - Part 1
MVP Brad McGehee, director of DBA Education for Red Gate Software, sat down recently with longtime author, Robert Pearl. In this interview, learn a bit about how Brad got started in the SQL Server world.
2009-04-09
3,368 reads
Using OpenDataSource - SQL School Video
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,673 reads
Collecting performance counters and using SQL Server to analyze the data
Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.
2009-04-09
3,720 reads
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
2009-04-09
895 reads
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
2009-04-09
593 reads
Encrypting SQL Code
This Friday's poll looks at the encryption options for your code in SQL Server. Steve Jones asks if there is a benefit for these routines.
2009-04-09
770 reads
Measuring the Impact of Task Switching/Multitasking
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non uncommon cases also keeping up with Facebook, Twitter, and more. Often it's multiple tasks, and we get better at plate spinning.
2009-04-09
1,664 reads
Testing a SQL Server environment before an upgrade
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
2009-04-09
2,403 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers