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.
How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
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.
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.
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
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.
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.
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.
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.
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.
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Not sure if this is really a relational theory question but it seems about...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
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