An Interview with Brad McGehee - Part 2
Continuing the interview with Brad McGehee, Robert Pearl asks about the new features in 2008 and his books.
2009-04-10
1,391 reads
Articles
Changing a Non-IDENTITY column to IDENTITY and vice versa
This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.
2009-04-10 (first published: 2008-02-21)
39,947 reads
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
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
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers