Ten Ways To Lose Your DBA Job
We often see ways to improve your career, but there's a flip side as well. In the spirit of our "worst practices" series, Steve Jones takes a look at ten skills that could cost you your job if you can't perform them.
The Weekly Update for Dec 2, 2007
A few notes and comments on the database news from the previous week.
Toward Integrity - Part 1
An exploration of the process of translating a conceptual model to a logical model, and ultimately, a faithful implementation using T-SQL.
Business Analysis: A Guide to Better Business Requirements
This article presents ten business analysis guidelines, representing best practices from successful projects.
SQL Server 2005 Bug Alert: Merge Replication Could Mean Data Loss
The SQL Server 2005 merge replication engine introduced breaking changes that can cause data loss for both MSDE and SQL Server Express subscribers. Find out how this bug manifests itself in a real-world scenario.
SQLonCall: Mock Interview, Part I
The first part of a great video series from Chris Shaw of SQL Oncall that walks you through a mock interview and gives advice on how you can present yourself in the best light.
Altering a column on a Replicated Table
SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.
Source Control in SQL Server
One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.
Accessing and Updating Data in ASP.NET 2.0: Handling Database NULL Values
Dealing with NULL database values in ASP.NET.
Custom check-in policies with VSTS
In this column, I'll dig into check-in notes and policies. You'll learn how check-in notes work and how to write your own custom policy implementations.
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers