Reading the Results

Feb 28 Reading the Results The following story was contributed to ficlets.com last week. It’s a follow-up to my story “Judicial Execution“. I’m putting it here so that you can check it out! Let me know —– “That’s the end of it.” Joseph turned to look his colleague in the...

dev

sql server 2000 + How to display date time

Over on Experts Exchange I saw a question that I get all the time, "How do I format this DATETIME like x?" If they're asking to learn, I point them over 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

microsoft sql

sql db record number

Over on Experts Exchange someone asked, once I insert a record into the table, how can I retrieve the primary key that was just inserted. This is a topic I

microsoft sql

Advice regarding on-line storage versus terabyte drives

Over at Experts Exchange, a user asked for some advice on using online (or off-site storage) for a collection of video files.  This is something I have been

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

Certification

70-432: So…What’s Going to Break When We Upgrade?

So you're in a shiny new position and you're building plans for your migration from SQL 2005 to 2008 when the question hits you. What features are we currently

career development

SQL Session – The 64-bit Question

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

SQL102

SQL 201 – Contstraints

Constraints... helpful in making sure you get the data you want out of your database! Constraints allow you to define rules that the data must follow in order

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

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