David’s SQLBITS Day 1–The Travel Day
Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its...
2011-09-28
733 reads
SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,639 reads
RTO in Disaster Recovery
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,279 reads
Change Database Owner
This is post is going to be very simple but it is something I come across ever so often and...
2011-09-28
5,029 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,334 reads
Consultants: 1099 or W-2?
As a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether...
2011-09-28
1,904 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…! It’s time for another SQL Saturday at the beautiful University of Iowa campus. The speaker lineup looks great....
2011-09-28
33 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!
It’s time for another SQL Saturday at the beautiful University...
2011-09-28
732 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
551 reads
Format Disk for SQL Server
Managing large SQL Server inventories requires standardisation. Do your research , create the scripts , and apply.
Occasionally, custom changes are required . This...
2011-09-28
4,127 reads
Blogs
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...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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