SQL Saturday Advice - PhotoJournalism
I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a...
2010-09-02
373 reads
Blog Posts
Thanks for supporting this blog and make it successful
Hi friends
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge...
2010-09-02
772 reads
Whats best SQL Server or Oracle ?
Im often asked the question – whats best SQL or Oracle ?
The Oracle guys will tell you that SQL Server does not...
2010-09-02
608 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
2010-09-01
32 reads
A Stored Procedure to Move SSIS Packages Between Servers
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the...
2010-09-01
992 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
6 reads
As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections
I just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to...
2010-09-01
597 reads
Book Review: Crunch Time
About a month ago I went to Barnes & Noble to pick up a copy of Seth Godin’s book, Tribes: We...
2010-09-01
583 reads
Common SQL Server Mistakes - SELECT *
I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I...
2010-09-01
4,402 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
905 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers