Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some changes, then begin writing the book.
It's Your Ship
I saw this book ( It's Your Ship ) in a Barnes and Noble and the title and cover attracted me. So I picked it up and read the back, thought it was interesting, and later grabbed it for the Kindle.
SQL Server security settings using the Surface Area Configuration tool (SAC)
Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?
Celebrating A Million
SQLServerCentral crossed the 1 million member mark yesterday and we have a few things in mind for a celebration.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Configuring Replication for Partitioned Tables Using T-SQL
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
Using the Timestamp Data Type - SQL School Video
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
Notes from SQLSaturday #10 in Tampa
SQLSaturday #10 was held January 24, 2008 in Tampa at the Kforce Building. Attendance was about 175, down slightly from the year before. Overall the event turned out well; 36 sessions, everyone got fed, no major logistical challenges.
SQL Server Interview Questions for a Network Administrator
We are looking to grow our team and we are interested in finding out what a reasonable set of questions would be for Network Administrator candidates that also state that they can support SQL Server. Do you have any suggestions?
The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
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
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
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...
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