sqln.blogspot.com
SQL 'N: July 2008
http://sqln.blogspot.com/2008_07_01_archive.html
General discussion of SQL Topics; aimed for the novice-intermediate level Microsoft SQL Server User. Currently focuses on using SQL Server 2005. Wednesday, July 2, 2008. Publication: Introduction to the Transaction Log. This article covers a very broad and general introduction; including how the log is filled by SQL Server, easy to follow analogies to help grasp how transaction logs work with SQL Server, and some Good Practices to use when Transaction Logs are in use by SQL Server. Links to this post.
sqln.blogspot.com
SQL 'N: TSQL Code: Compare Tables of Databases on Separate Servers
http://sqln.blogspot.com/2008/10/tsql-code-compare-tables-of-databases.html
General discussion of SQL Topics; aimed for the novice-intermediate level Microsoft SQL Server User. Currently focuses on using SQL Server 2005. Thursday, October 23, 2008. TSQL Code: Compare Tables of Databases on Separate Servers. Figure 1 (results of running sp CompareTables All). At the end of the script I'll also provide a quick comment that will allow you to change the results from displaying all tables and their row counts to display only the tables with mismatched row counts (which may be useful ...
sqln.blogspot.com
SQL 'N: May 2008
http://sqln.blogspot.com/2008_05_01_archive.html
General discussion of SQL Topics; aimed for the novice-intermediate level Microsoft SQL Server User. Currently focuses on using SQL Server 2005. Thursday, May 22, 2008. The first step is NOT to just rebuild all indexes, or to defrag them all. There are some people that believe that rebuilding all indexes is the way to solve this; don't listen to them! Any decent DBA is always concerned with using system resources, remember that system resources is always a precious commodity and should never be wasted.
sqln.blogspot.com
SQL 'N: March 2009
http://sqln.blogspot.com/2009_03_01_archive.html
General discussion of SQL Topics; aimed for the novice-intermediate level Microsoft SQL Server User. Currently focuses on using SQL Server 2005. Tuesday, March 24, 2009. What are Tables in SQL Server? The following is a general overview of tables within a SQL Server database; it is by no means a thorough discussion of this subject. This is intended to be a primer for future discussions and covers only the basics, in no particular order. A table must include the following (at a minimum):. 160; . See the ...
sqln.blogspot.com
SQL 'N: January 2009
http://sqln.blogspot.com/2009_01_01_archive.html
General discussion of SQL Topics; aimed for the novice-intermediate level Microsoft SQL Server User. Currently focuses on using SQL Server 2005. Tuesday, January 6, 2009. New Article: Transaction Log Growth, do you need it? Yesterday, SQL Server Central. Had published another article of mine: Transaction Log Growth, do you need it? It got some good reviews. And just over 8,000 views before 9 AM; I've been told anything over 4,000 views (total) is pretty good. Until next time, Happy Coding!
csharphelper.blogspot.com
C# Helper: April 2007
http://csharphelper.blogspot.com/2007_04_01_archive.html
Thursday, April 19, 2007. A brief look at "Abstract Classes" and how to use them. What are abstract classes? An “ abstract class. Rdquo; is a class that is created with the intention of never being instantiated by an object. Basically this means that the created class will define what properties, methods, and/or events are contained within the class. The methods and/or events may also contain required arguments, as well as expected return data types. How do you use abstract classes? Creates an painting o...
visualbasichelper.blogspot.com
Visual Basic Helper Blog: Variables…what are they? How do I use them?
http://visualbasichelper.blogspot.com/2007/06/variableswhat-are-they-how-do-i-use.html
Visual Basic Helper Blog. This blog is targeted at beginning / novice programmers for the Visual Basic (VB) language. Friday, June 1, 2007. Variables…what are they? How do I use them? This is quite a broad area of topic; I will do my best to keep this blog concise and cover the essential basics for the beginning programmer. Intermediate programmers will most likely find this to be a refresher course, if anything at all. I think the best thing to start with is Microsoft. Since you know have a grasp on wha...
visualbasichelper.blogspot.com
Visual Basic Helper Blog: June 2007
http://visualbasichelper.blogspot.com/2007_06_01_archive.html
Visual Basic Helper Blog. This blog is targeted at beginning / novice programmers for the Visual Basic (VB) language. Friday, June 1, 2007. Variables…what are they? How do I use them? This is quite a broad area of topic; I will do my best to keep this blog concise and cover the essential basics for the beginning programmer. Intermediate programmers will most likely find this to be a refresher course, if anything at all. I think the best thing to start with is Microsoft. Since you know have a grasp on wha...
visualbasichelper.blogspot.com
Visual Basic Helper Blog: Introduction to LINQ in VB
http://visualbasichelper.blogspot.com/2008/03/introduction-to-linq-in-vb.html
Visual Basic Helper Blog. This blog is targeted at beginning / novice programmers for the Visual Basic (VB) language. Friday, March 21, 2008. Introduction to LINQ in VB. How do I use it? Example of enabling at the class level would be:. Insert your LINQ code here. As you can see, enabling LINQ at the class level is quite simple to perform. What can I do with LINQ? Why you might ask would someone want to do this? How cool is that? What is different in LINQ for VB than in LINQ for C#? As you can see, this ...