Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
The Multi-valued Parameters problem in Reporting Services
Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
Installing Data Protection Manager 2007 as a VM in a lab environment
This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
SCOME - Centralize Monitoring with ASP.NET - Part 1
New author Drew Salem brings us a series on how to centrally monitor your SQL Servers. He includes ASP.NET code and a framework that will check your servers and display a report for you. This article presents an overview of the dealing with the SCOME issue.
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
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