Who Has The Monitor?
A Friday distraction from work when you have time. Can you figure out who has the dual 19" LCD monitors?
2006-04-28
9,449 reads
Articles
Review: Red Gate SQL Bundle 5
When architects speak with database administrators, it is important they come forearmed. Tools can help. While Microsoft's own database management tools cover the most common database administration scenarios, they don't do anything about some of the most common pain points faced when you need to maintain and deploy SQL Server databases for projects under active development. That's where Red Gate comes in.
2006-04-28
1,984 reads
SQL 2000 DBA Toolkit Part 3
Phonetic matching, working on finding terms that are misspelled, is an art and there are a number of ways to handle it. In SQL Server 2000 the tools are limited, but Michael Coles brings us part 3 of his toolkit with some handy functions that can help you with text searching.
2006-04-27
16,930 reads
The Writing on the Wall
There is a world of difference between the business processes that really take place in a company and the management's understanding of those processes…
2006-04-27
2,351 reads
Business Continuity for SQL Servers With a Standby Approach
Ensuring the availability of your database servers is becoming more important all the time. Fortunately you have more choices than ever. Bilal Ahmed looks at some of the possible solutions available for SQL Server.
2006-04-26
5,436 reads
OUTPUT clause in SQL Server 2005
A SQL Server 2005 feature that I appreciate and want to demonstrate is the OUTPUT clause. The OUTPUT clause helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or the default value generated by the default constraint.
2006-04-26
2,966 reads
Data Extraction Methods Part 1
The third part of a great data warehousing series from Vincent Rainardi looks different methods of extracting data from the source system along with the advantages and disadvantages of each.
2006-04-25
17,018 reads
Making Complex Data Simple: Transforming Your Data Transformation
This article examines the problem of complex data in integration projects and presents solutions for handling this data to create seamless integration throughout the enterprise.
2006-04-25
2,460 reads
Spotlight on SQL Server
After a bit of a hiatus, the interviews are back. This time we take a few minutes with Dan Jones of the SQL Server development team.
2006-04-24
5,718 reads
Testing SQL Server restores
Testing is key to ensuring a process actually works when it comes time to implement, rather than finding out when time may be of the essence. This holds true for testing SQL Server restores as well.
2006-04-24
2,625 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers