t-sql
Code to Write Code
I've read "When you start writing code that writes code for you, you've moved up from a beginner to a professional." Today I'd like to walk you through an
sql
career development
Server 2008 Firestarter Event
The SQL Server 2008 Firestarter event is a 1/2 day, free event for SQL Server developers and administrators. You'll be able to learn about the newest features
t-sql
SQL 102 – CLUSTERED vs. NONCLUSTERED Indexes
Previously, I covered the basics of creating an index using CREATE INDEX. Today, I'm going to dig a little deeper. I'd like to teach you the difference in an
t-sql
SQL 301 – Views
At this point I'm sure you know how to CREATE and ALTER a VIEW. But today I'd like to go into a little more detail on views. I'd like to cover updatable views,
career development
SQL Session – Introducing Resource Governor
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
t-sql
Correlated Subqueries with Comparison Operators
If you haven't used a sub query yet, I'm surprised. They can be incredibly useful. They can also be a crutch...but like I say time and again, each tool has it's
t-sql
Insert Triggers
An insert trigger is a Data Manipulation Language (DML) trigger that acts when a new record is added to the table. CREATE TRIGGER t_tableName_insert ON
SSAS
Business Intelligence Concepts
The phrase business intelligence is pretty old, 1958. In the early 90's the term came to refer to the "concepts and methods to improve business decision making
career development
SQL Session – Transactional Replication for Beginners
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
career development
SQL Session – Performance Point Server Dashboards
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
transaction
Return a Success/Failure to a Job based on a SQL query?
Over on Experts Exchange, someone posted a question I felt I could answer. The user posted a question on how to return a failure and not run a job. I
career development
SQL Session – Performance Tuning in 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