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
Latest
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
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
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
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