New Product Discount: 15% on SQL Server Find
SQL Server Find, a product from Genius@Work, allows you to search your databases for objects based on a variety of criteria.
Which Databases are Being Backed Up - Another Look
Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.
Advanced Data Generator
Upscene Productions is happy to announce a new version of
the database developer tool: "Advanced Data Generator" (version 1.1.0)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versions:
- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition
More info, pricing and a 30-day trial version on www.upscene.com
Be Prepared - Part 2
Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.
Celebrate Our 1 year anniversary
Andwil, 06-Jun-2004: To celebrate the 1-year anniversary for their SASSI v2.0 professional SQL Development Environment application, Dynamic3 GmbH is offering a limited amount of SASSI license keys for FREE! To register for a free license key, visit the website now! http://www.sqlassi.net
Mini Disaster - AC Failure
Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.
Office System - Business Intelligence GTM/BI Accelerators Have Release
Today Microsoft announces the web release of the Microsoft Office Business Intelligence (BI) Accelerators. Both the Business Scorecards Accelerator and the Excel Add-In for Analysis Services empowers Information Workers and executives alike to increase the speed and quality of decisions aimed at improving business performance.
Case Sensitivity in Selects - Part 1
Your SQL Server has a case insensitive collation, but you need a case sensitive join? Do you know what happens? There are a couple options but do you know the performance implications of using each? Or a way to mitigate the performance degradation that can result?
SQLServerCentral.com - Featured Site!!
It's not often that we toot our horn, but SQLServerCentral.com was chosen as the feature site by GotDotNet.com, one of Microsoft's premier .Net sites. Check it out!
Blogs
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...
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...
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