DevPinoy.org
A Filipino Developers Community
Attention: Site upgrade failed last night. Will resume updates this weekend. Thanks!- Keith

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • Some useful date processing SQL Snippets

    Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of current month SELECT DATEADD (mm, DATEDIFF (m, 0,...
    Posted to Keith Rull (Weblog) by keithrull on 07-24-2008
  • “SQL Server and .NET Training and Career Development” by Douglas Reilly

    [This 3-part series was written by Douglas Reilly who died early 2007. The articles were written in February to June of 2006.] This is the Part I of the series: The Value of Conferences And here is the Part II : The Benefit of Foru m Finally, Part III : Importance of Books and the Constant Change Author...
    Posted to αρχάριος (Weblog) by marl on 05-10-2008
  • SQL versions

    Its been months since i have'nt posted anything haha. I was addicted to photography indeed. Http://HumpreyCogay.BlogSpot.Com Any way i want to share one of my problems then. I've been coding SQL Querries for SQL Server for several years now, but working for the bank we use AS400 DB2 as a main...
    Posted to Humprey Evangelista Cogay (Weblog) by Comgen on 04-22-2008
  • RML Utilities For SQL Server

    [Description from website:] The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft...
    Posted to αρχάριος (Weblog) by marl on 01-17-2008
  • HOWTO: INSERT RECORD SET FROM STORED PROC (SQL SERVER)

    Suppose that you need to populate record set from a stored procedure. This is how it's being done: CREATE PROC NameList AS SET NOCOUNT ON SELECT Emp_FNAME, Emp_LNAME From Emp_Table SELECT FName, LName From Table_of_Names RETURN When you execute this Stored Proc, it gives you something like this:...
    Posted to αρχάριος (Weblog) by marl on 01-11-2008
  • Job Seekers

    Here's a contact just in case you're looking for jobs (Pampanga Area). Michael "Mike" Hotek is a Microsoft Book Author and Technology Practitioner. I was just glad he has a company in the Philippines: Mike Hotek President FilAm Software Technology, Inc. mike.hotek@filamsoftware.com...
    Posted to Jobs (Forum) by marl on 01-03-2008
  • New Year's Resolution

    My New Year's Resolution List: 1. Prepare For The MCTS-SQL Server 2005 Certification (70-431) 1.a Self-Paced Training (Training Kit + Videos Lessons) 2. Prepare For The OCA Exam (1Z0-042) 2.a Review Oracle 10g Architecture and Administration 2.b Attend Class For the Oracle 10g Backup and Recovery...
    Posted to αρχάριος (Weblog) by marl on 01-02-2008
  • List SQL Servers using SqlDataSourceEnumerator

    I wrote an article a few years ago using SQL SMO and just realized today that I can also list SQL Severs without importing an additional assembly to my project ( Microsoft.SqlServer.Management.Smo ) by using the SqlDataSourceEnumerator class . SqlDataSourceEnumerator is a class that provides a mechanism...
    Posted to Keith Rull (Weblog) by keithrull on 12-11-2007
  • Re: what's the difference bet. SQL Server Express and SQL Server Standard??

    Hi Raphael, You can get a breakdown about the featureset of each SQL 2005 release here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Basically, SQL Server Express is file based and much similar to how you use MS Access. SQL 2005 on the other hand is an entry level database server...
    Posted to SQL Server (Forum) by keithrull on 12-06-2007
  • Re: Reporting Services Error

    [quote user="blink_1106"] For more information about this error navigate to the report server on the local server machine, or enable remote errors SQL Server Reporting Services Hello there guys, need some help regarding this matter and comments/ idea how this error can be solve? This is the...
    Posted to ASP .NET (Forum) by keithrull on 11-07-2007
Page 1 of 5 (41 items) 1 2 3 4 5 Next >

Copyright DevPinoy 2005-2008
Powered by Community Server (Commercial Edition), by Telligent Systems