SQL 2000 Replication Architecture
New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.
XML Workshop VIII - Custom Types and Inheritance
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
A New (and Hopefully Better) Approach to Constants
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
The College Experience
We published an article about how one DBA goes about hiring new DBAs and in the discussion that followed there was something that caught my eye. There were a few comment talked about how college degrees don't necessarily mean anything.
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Charlotte's SQL Server User Group
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
The Pay Jump
Workers Rarely Jump Ship Over Pay Alone is an article that I saw awhile back and saved. It is 100% true and should be required reading by every C-level knucklehead and MBA student.
Who wants to be a SQL Server DBA?
A look at how one of our longtime members goes about hiring new DBAs.
Restore your SQL Server database using transaction logs
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers