A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever to count all the rows in a table? I had this problem when I would sometimes run counts on a … Continue reading →
Category Archives: SQLServerPedia Syndication
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has a ton of IT jobs on it, and it is focused solely on IT. Monster is OK, but it does … Continue reading →
SSIS package runs fine until put in a job
I see this issue pop up every now and then: A developer creates an SSIS package in BIDS and gets it to run fine. Then the developer connects to Integration Services and uploads the package to the server, and then … Continue reading →
What to blog about?
As I mentioned in my first post, I thought it would be real difficult to think of things to blog about. Turns out to be real easy. It’s just a matter of always having a “blogging mindset”. In other words, … Continue reading →
Antivirus solutions that are free
So my sister called me the other day to tell me she has a message on her laptop that said she has a virus. Those of us working in the IT industry know we are the one’s all our friends … Continue reading →
What name should I call myself?
In creating this blog, I was thinking about using some catchy name for myself. Something with “DBA” in it. However, doing a quick Google search revealed there are so many already: Cranky DBA, Rambling DBA, Goal Keeping DBA, Mean Old … Continue reading →
Welcome To Machine
Hello World. Stardate 1513.1. After reading that, if you know what I am referring to, you are a tech-head and may continue to read this blog 🙂 So, the reasons that I am blogging: 1) I really enjoy helping others. … Continue reading →