Reporting Services 2005 101 with a Smart Client
Are you interested in a raise? Asif Sayed got one from a well written report. This time he brings us a beginners' looks at Reporting Services 2005 using a smart client for testing.
Improving Data Security by Using SQL Server 2005
Microsoft IT developed strategies to reduce the duplication of sensitive data and improve the security of personally identifiable information in the Microsoft IT LOB application space. These strategies are based on the new security features and functionalities that Microsoft® SQL Server™ 2005 includes.
Top 10 Enhancements in SQL 2005 Notification Services
In this article, we examine some of the best new features and characteristics available in the 2005 version.
Save and Retrieve Datasheet Layout with the Windows Registry
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.
Spotlight on SQL Server with Slava Oks
The next installment of our series on the developers behind SQL Server takes a few minutes with SQL Server Storage Engine export Slava Oks.
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.
A Technique for Determining the I/O Hog in your Database
Performance Tuning can be as much an art as a science when working with SQL Server, but there are many fine techniques that can help you get started. New author Michael Morin brings a great new technique helping you get started on determining where the heavy I/O users are in your database.
Getting Warmer - How to Implement Hot Failover in .NET 1.1 with SQL 20
What happens if you try to specify a Failover Partner in .NET 1.1?
Looping Through and Loading Files with SSIS
In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.
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