Browse by Tags

• FAQ
• Personal
• Programming
• SQL

• 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

• Making a .NET assembly always appear in Visual Studio.NET

  To display your assembly in the Add Reference dialog box, you can add a registry key, such as the following, which points to the location of the assembly [HKEY_CURRENT_USER\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders\MyAssemblies]@="C:\\MyAssemblies" Read More... Posted Wednesday, March 24, 2004 1:48 PM by aweiker | 50 Comments Filed under: FAQ, Programming

• Password Generator

  I came across this web page and find it extremely useful any time that I need to get a random password made. I also have some code that I use for generating random passwords as well which I have posted in this article . Share this post: email it! | bookmark Read More... Posted Monday, March 22, 2004 9:56 AM by aweiker | 58 Comments Filed under: FAQ

• New Category

  I just added a new category named “FAQ”. This is where I'm going to be puting things that I see asked over and over again. I'm also going to update the historical posts with this category where they apply. So for you people reading this in Read More... Posted Friday, March 19, 2004 10:46 AM by aweiker | 46 Comments

• 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

• Thought of the day

  Just finished reading a post that Dave sent to the aspnet-database list and I began pondering the following question. When was the last time you programmed to an interface instead of an object? So tell me, what's your answer? Share this post: email it! Read More... Posted Tuesday, March 09, 2004 6:37 PM by aweiker | 54 Comments Filed under: Programming

• Bugs, why won't they just go away!!

  One of the goals we have as programmers is to write code that does not have any bugs. However; since none of us are perfect, we are going to fail. Does this mean we should stop trying? Of course not. So how do we go about trying to reach this impossible Read More... Posted Monday, March 08, 2004 8:04 AM by aweiker | 48 Comments Filed under: Programming

• 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! Read More... Posted Sunday, March 07, 2004 6:44 PM by aweiker | 51 Comments Filed under: SQL, FAQ