Browse by Tags

• FAQ

• SQLProgrammer.org

  Just wanted to let everyone know here that I just put up a new website dedicated to SQL Server and .NET called SQLProgrammer.org . Currently on this website I have a list of Frequently Asked Questions, Links to external resources, and forums. Share this Read More... Posted Sunday, January 23, 2005 11:51 AM by aweiker | 51 Comments Filed under: SQL

• Transaction Log 101 (What you don't want to know, but should)

  If you haven't had a chance to dig into the transaction log yet, allow me to get your feet wet. The following is a basic regurgitation of what I feel is important to know when dealing with the transaction log. Feel free to point out things that you feel Read More... Posted Wednesday, March 31, 2004 10:34 AM by aweiker | 67 Comments Filed under: SQL

• Reporting Services Question

  I was recently asked a few questions on how to do aggregate functions using Reporting Services ( Reporting Services Documentation ). While answering these questions I have had a chance to really dig into the report designer and am much more comfortable Read More... Posted Wednesday, March 31, 2004 10:24 AM by aweiker | 0 Comments Filed under: SQL

• Running AntiVirus software on SQL Server

  I've seen this asked a few dozen times so I thougth I would put a link here so that I remember where I put it. INF: Consideration for a Virus Scanner on a Computer That Is Running SQL Server Share this post: email it! | bookmark it! | digg it! | reddit! Read More... Posted Friday, March 19, 2004 10:18 AM by aweiker | 1 Comments Filed under: SQL, FAQ

• Links for working with the Transaction Log

  Here are some good references on how to take care of your Transaction Log INF: How to Shrink the SQL Server 7.0 Transaction Log INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE INF: Transaction Log Grows Unexpectedly or Becomes Read More... Posted Wednesday, March 17, 2004 8:12 PM by aweiker | 0 Comments Filed under: SQL, FAQ

• Email notification for failed jobs

  As you may or may not know, you can set up SQL Server Agent to email you whenever a job fails. This however requires SQL Mail to be properly working. Again, as you have probably experience this is a lot easier said than done. What I have ended up doing Read More... Posted Tuesday, March 16, 2004 10:42 AM by aweiker | 49 Comments Filed under: SQL

• Subquery Phobia

  I have this habit of never using Sub-Queries in any of my SQL Statements. I'm not sure why I started this, but it is one of those things I avoid at all costs. Is this fear justified? Or do you think I'm making a big deal out of something that I don't Read More... Posted Friday, March 12, 2004 11:46 AM by aweiker | 73 Comments Filed under: SQL

• How do you learn?

  I enjoy learning new things and as such I constantly become aware of how much I don't know. The more I learn the dumber I feel. (OK, maybe that's a slight exaggeration, but you get the point). Typically the way I learn is through reading books and some Read More... Posted Thursday, March 11, 2004 11:16 PM by aweiker | 0 Comments Filed under: SQL

• Am I secure enough?

  It is my firm belief that any server needs to be properly secured. But how do you check to see if you have done all of the right things? You shouldn't just hope that you have done everything, instead you need to be proactive. First of all, get the Microsoft Read More... Posted Sunday, March 07, 2004 6:57 PM by aweiker | 161 Comments Filed under: SQL

• Setting up Least Privileges in SQL Server

  This has been moved to sqlprogrammer.org . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor Read More... Posted Sunday, March 07, 2004 6:44 PM by aweiker | 51 Comments Filed under: SQL, FAQ