Data Points: Data Binding in WPF
With WPF, you can perform data manipulation using Microsoft® .NET Framework code, XAML, or a combination of both.
Too Simple, Too Soon
The author explains an application development approach advocated by many proponents of agile application development that can cause future problems for developers, while potentially sacrificing the integrity and reusability of the data.
How to handle lost LF/CR when copying [code]
A quick workaround from a longtime community member that helps you prevent the LF/CR from being lost if you copy scripts from the code tags in your posts.
New T-SQL Features in SQL Server 2005 Part 1
SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the first part in a series looking at what these changes do and how to use them.
Changing Career Gears
How can you get started as a DBA? One of our authors takes a look back at her career and how it has evolved into a DBA role with SQL Server.
Database Snapshots in SQL Server 2005
One of the brand new features in SQL Server 2005 is the database snapshot. New authors Arvinder Singh Khosla and S.Srivathsani Murthy bring us a look at how these static view databases can be setup and used in your environment.
Every DBA's nightmare
When a copy of all 25 million of the UK’s child benefit records, including bank details, went missing in the post, whilst being sent to the NAO (National Audit Office) on 18th October, the UK government must have known that a cover-up was impossible. This sort of incident is every DBA’s nightmare.
Enterprise Architecture – Connect-the-Dots for Adults, Part 3
This article, the third in a series on enterprise architecture, discusses the approaches to developing an enterprise architecture, describing the methods, benefits and pitfalls of each.
SQL Server Connection Strings
Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Prompt Requests
Comments posted to this topic are about the item Prompt Requests
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers