Using the DATE data type in SQL Server 2008
In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
Toward Integrity Part 3
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
RAID Scaling Charts, Part 1
Most enthusiast and mainstream users would consider setting up a RAID array mainly for performance reasons - few really care about data safety. For this reason, the majority of arrays installed consists of only two drives, which run a simple RAID 0 stripe set. Haven't you ever asked yourself how these RAID arrays scale as you increase the number of hard drives?
Speed up SQL Server database queries with these tips
If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Learn how you may be able to improve performance by knowing what to look for in your query designs.
An Introduction to the Service Broker
One of the more interesting new features in SQL Server 2005 is the Service Broker. It's not something to help you manage your financial future, nor is it some new program that handles all the instances and their accounts. It's a message queue and SQL Server MVP Srinivas Sampath brings us a look at this new feature with some code to get you going.
Exception handling in DTS
While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers