Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
Try To Be More Inefficient
Steve Jones is recommending that you don't work the most efficient way at your job. Sometimes.
Why Read-only Table Parameters is Not Enough
In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.
April Bloopers
Steve takes a day off from the editorials with this blooper reel from the podcasts. Be sure to watch the video.
Database Wars Coming for the XBOX 360
A new XBOX 360 title is being released today for the DBA in you.
A Scary Comparison
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
A Scary Comparison
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
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
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
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