Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
Column-Store Databases and DW Appliances
With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.
Dynamic Search Conditions
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2007 Tech Salary Survey Results
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
Name value pair (EAV) model
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
Ready Made Code Snippet Tool Box Courtesy of SCOM
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
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