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 SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
Killer Feature Reporting Services 2008
Reporting Services in SQL server 2005 does amazing things. But it has one drawback. To make it fly you have to be using Visual Studio. That’s fine for us, the IT Professionals, but what about the rest of your staff, the non-IT Professionals? They get report builder which is very easy to use but is…
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 eyes. “What was served by his death? He didn’t know…
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 SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
New Photos at DeviantArt!
I’ve added a few photos from my trip to Raleigh, NC last December. I took the backroads to get there. I wasn’t interested in making good time. I was more interested in seeing what had changed in the last decade. You see, back in 1995 I was a up and coming freshman at NCSU. I…
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 SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server….
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 CAST and CONVERT article on msdn. If you wish to change a Microsoft SQL DATETIME column from the standard format 2008-01-28 12:43:13.210…
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 covered back in 2005 in my post SQL 101 – System Functions. In this post I introduced you to @@IDENTITY. If you are unfamiliar with…
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 originally took the approach of putting a query at the top of the queries run by the job that would query the table of failure…
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 discussing with my friends and co-workers for some time. I thought I’d try to help out. Looking at the amount of storage, 2 terabytes, I had to…