dev
SQL Session – Migrating From DTS to SSIS
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Latest
SQL301
Extract, Transform, and Load
What is ETL? ETL stands for Extract, Transform and Load, a process used to collect data from various sources, transform the data depending on business rules and
t-sql
Triggers
Triggers are one of the most misunderstood features in Microsoft SQL server. Most of that misunderstanding comes from people implementing triggers with little
t-sql
SQL Session – What’s new in Katmai (SQL Server 2008)
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
examples
Exception Handling
Learning to handle errors better can be one of the skills that will really set you apart from other SQL Developers. You can do constant unit testing after each
sql
New Sample Databases for 2005!
Back when we were all using SQL 2000, I shared a link to download SQL 2000 demo databases. Now, most of us are on SQL 2005, we need a new database to work with.
dev
Default Values
When you start creating tables and setting them so they can't have NULL values, you'll eventually need a way to define a default value for the column. A default
sql
SQL Session – How to Hire a DBA
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
microsoft sql
Identity Columns
An IDENTITY column is a column that automatically gets it's value set by the database engine when a new record is added. This is one of the oldest ways
t-sql
Computed Columns
What is a Computed Column A computed column is a column that users will not enter data for, but the SQL Server will compute and store a value in. The expression
Posted in: Microsoft SQL
Schema
In previous versions of SQL Server we had what we called "owners" of objects. Nearly every time you talked about an object "owner" you were talking about dbo.
microsoft sql
NULL Values, Blank Values, and Table Design
Have you dealt with NULL yet? A field is referred to as NULL if it has not received a value. To specify the NULL-ability of a column using T-SQL, just add