Loginless Database Users and Dynamic SQL
Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.
What does certification achieve?
Part 2 of a set of thoughts from Steve Jones on certification in technology areas.
A Variety of Tracks at DevConnections
It's less than a month until DevConnections in Las Vegas. With tracks that cover SQL Server, Windows, Exchange, SharePoint, Dev and more, this is a great place to learn about a variety of technologies. Register today
Compare Big Data Platforms vs SQL Server
SQL is derided by modern developers as 'Scarcely Qualifies as a Language'. But just how efficient are the new wave of NoSQL languages touted by bleeding-edge skunk works? This tip is a defense of SQL and of the relational model, and argues for the efficiency and suitability of relational technology. Check out this tip to learn more.
No More MCM
With the discontinuing of the MCM And MCA programs, Steve Jones has a few thoughts. This is the first of a three part series on certifications.
The Loss of Trust
The news about NSA spying keeps coming out, and apparently includes corporate communications as well.
SQL Saturday #250 Pittsburgh
September 14, 2013 Pittsburgh will be hosting a SQL Saturday. Join them for a free day of SQL Server training and networking. There will also be a paid pre-con session the day before on Performance Tuning in SQL Server 2012 presented by John Sterrett and Konstantin Melamud.
Using DAX to create SSRS reports: The Basics
You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.
Developer Pressure
As we ask developers to deliver software quicker, are we helping improve the quality of software? Steve Jones asks the question today.
SQL Server Error Log Scanning
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
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