Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
Use Access 2007 to Get Started in Data Mining
Learn how you can use Microsoft Access 2007 as a basic data mining tool for exploring your valuable data. This article illustrates how data filters, pivot graphs, queries in graphs and filters in reports can help this cause.
Generating Random Results - SQL School Video
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
Managing many SQL Servers?
Here's an article from Rudy Panigas on how to more effectively manage multiple servers.
The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
Extending the REVERT statement using the WITH COOKIE clause in SQL Server 2005
In a previous tip on Switching Execution Context using the REVERT clause, you have seen how to switch execution context to a more privileged user and revert back to the original context of the caller within a programmable object. The REVERT clause accepts a parameter WITH COOKIE to provide an even more granular option. How do we use it?
Obtaining Index Usage Information
This article shows how the sys.dm_db_index_usage_stats DMV can be used to tune your indexes, and maximize the performance of your database
Checkpoints in SSIS
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
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