January 2008 - αρχάριος

Southern California Code Camp 2008 - Day 2 - Final

The first Code Camp that I ever attended has been concluded. Although I did not get the XBox 360 on the raffle draw, I was very happy for the 2 books I got for free a day prior . And how much can you tag on all the knowledge I learned from the sessions...

Published 01-28-2008 9:13 PM by marl

Filed under: sql server 2005, keith rull, SoCal Code Camp 2008, Service Brokers, Data Controls in ASP.NET 3.5, Best sessions

HOWTO: MULTIPLEX ORACLE CONTROL FILE

One of the basic tasks of a DBA is to multiplex the Control Files. One of the biggest reasons why we multiplex control files is to create backups of the primary control file, which “records the physical structure of the database.” When the control file...

Published 01-15-2008 9:20 PM by marl

Filed under: oracle, multiplex, dba

Windows VS Mac OS X: You won't Believe This

Windows XP, Vista, and Mac OS X vulnerability stats for 2007 XP Vista XP + Vista Mac OS X Total extremely critical 3 1 4 0 Total highly critical 19 12 23 234 Total moderately critical 2 1 3 2 Total less critical 3 1 4 7 Total flaws 34 20 44 243 Average...

Published 01-22-2008 1:25 AM by marl

Filed under: mac os x, vulnerability, windows

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...

Published 01-11-2008 1:40 PM by marl

Filed under: sql server, record set, stored procedure, insert from sp

What is an effective way to accumulate knowledge and credential if you are into BI and Database field?

One of the biggest, if not the biggest, obstacle of entry-level job seekers, specially in the area of Database and Business Intelligence, is their lack of experience. I have posted a question in my network in LinkedIN.com about how to accumulate knowledge...

Published 01-10-2008 9:59 PM by marl

Filed under: database, career development, Accumulate Knowledge, career, Business Intelligence, entry-level

Southern California Code Camp - Day 1 - DevPinoy Was There!

California State University - Fullerton, CA - January 26, 2008 Day # 1 The registration to the event started at around 8:00 AM. I really intended to go to the registration way ahead of most of the attendees (about 700 people according to Keith). So I...

Published 01-26-2008 6:27 PM by marl

Filed under: sql server 2005, Sharepoint 2007, ASP.NET 3.5, Data Controls, keith rull, SoCal Code Camp 2008, Analysis Services, Testing .NET, Data Mining, Reporting Services

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...

Published 01-17-2008 1:23 PM by marl

Filed under: sql server, rml, utilities

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...

Published 01-02-2008 10:46 PM by marl

Filed under: oracle, newbie, sql server, programming

Feature Pack for Microsoft SQL Server 2005

Author: Microsoft Download: Feature Pack for Microsoft SQL Server 2005 Product Type: Feature pack Target User: Network administrator IT Problem: Require updates for SQL Server 2005 DOWNLOAD NOW About this Download: Download the November 2005 Feature Pack...

Published 01-31-2008 12:13 AM by marl

Filed under: sql server 2005, ADOMD.NET, Management Pack for MOM 2005, SQL Server 2000 PivotTable Services, sql server feature pack, OLEDB Provider for DB2, MSXML

Hey Keith, Look at What I got!

I know I wasn't as lucky as Keith on the SoCal Code Camp. Well, he got lots of goodies! But look at what I got: http://blogs.msdn.com/zainnab/archive/2008/01/27/link-luv-contest-winners.aspx Visual Studio 2008 Backpack & 3 Visual Studio Shirt...

Published 01-27-2008 9:01 PM by marl

Filed under: Visual Studio 2008 Backpack, visual studio shirt, swag

HOWTO: SQL SERVER 2005 BACKUP

Most of the people, if not all, who work around the SQL Server know how to backup their databases by heart. They can even do the task in their sleep. Some may find this article useful, though. What we're going to do here is do the 3 backup types:...

Published 01-21-2008 9:11 PM by marl

Filed under: differential backup, sql server backups, transaction log backup, full backup

Regular Expressions

Are you finding a hard time "finding text patterns" in your programming? Here's a set of Regular Expression Videos! Here's the Link to the videos/webcasts and descriptions.

Published 01-22-2008 11:35 PM by marl

Filed under: RegEx, regular expressions

Cool Tool To Help You Learn LINQ Query!

Description: "LINQPad is also a terrific tool for learning LINQ: it comes preloaded with 200 examples from the recently released C# 3.0 in a Nutshell . There's no better way to experience the coolness of LINQ and functional programming ."...

Published 01-09-2008 4:45 PM by marl

Filed under: LINQing, LINQ, C# 3.0, Learn Linq

SQL Server 2005 Compliance Assessment

If the popular US Compliance Laws affect you, you might be interested to read this post: http://dbalink.wordpress.com/2008/01/25/sql-server-2005-compliance-assessments/ marl/dbalink

Published 01-24-2008 11:19 PM by marl

Filed under: compliance, SOX, sql server 2005, HIPPA

Online SQL and PL/SQL Formatter

Convert those SQL and PL/SQL Statements into C#, VB, Java, Delphi, etc! Sample: Microsoft SQL Server SQL : Select FName, LName From Employees Output to Delphi var1 := 'SELECT FNAME,' ; var1 := var1 + ' LNAME' ; var1 := var1 + ' FROM...

Published 01-18-2008 7:20 PM by marl

Filed under: sql to vb, sql formatter, sql to c#, sql to delphi