SQL People PASS Board interview is online–Please Comment!
Hey folks,
Welcome back to the PASS election process. The process moves forward with all of us candidates awaiting our ranking...
2011-11-10
872 reads
My Playbook For Putting On a SQLSaturday Part 3: Food
Feed Me Seymour!
Welcome to your number one cost. Every budget I’ve looked at so far food is the top expense...
2011-11-10
1,179 reads
Creating a Transaction Log Full Alert
When I was a kid, my mom had an old cookie-tin in which she kept her sewing supplies. On the...
2011-11-10
1,272 reads
Tentative Meetings
A lot of my work right now involves going to meetings. A few of them are ones I host, a...
2011-11-10
622 reads
#SSRS error – An item with the same key has already been added
Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I...
2011-11-10
2,209 reads
Notes from SQLSaturday #86 in Tampa
Quick notes as it is already Thursday!
The speaker party went well. Well attended, I spent a lot of time chatting...
2011-11-10
555 reads
SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-10
1,262 reads
Stored Procedure Checklist
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate...
2011-11-10
3,003 reads
Top 5 Third Party Quotes
Unless you’ve worked in a vacuum the likelyhood is that you either are a third company or you have many...
2011-11-09
513 reads
Eighty Logical Cores of Goodness!
I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will...
2011-11-09
1,837 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
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