αρχάριος

FrancisM - The Man From Manila

I remember when Rap, as a music genre, was not totally accepted in the Philippine Society. Rap music was associated with street gangs and violence. But everything has changed when Francis Magalona came in the picture. Not only has he brought Rap in the...

Published 03-09-2009 8:14 AM by marl

Filed under: Francis Magalona, Master Rapper, 3 stars and a sun, Man From Manila, FrancisM

How To: Report Authoring in SSRS 2005 - Part I (The Database)

*NOTE - This is a Cross-Post from my other blog http://dbalink.wordpress.com - Marlon Ribunal : -) H This is an introduction to SQL Server Reporting Services 2005 . I am not going to explain the architecture and concepts around the Reporting Services...

Published 01-18-2009 3:02 PM by marl

Filed under: Reporting Services, SQL Server 2000 PivotTable Services, tutorial series on sql server reporting services, ssrs 2005 basics, how-to

Creating SQL Server Login From A Domain Account To Access System Directory

Posted by MarlonRibunal I was having a problem accessing a folder via an extended procedure. The extended procedure accepts a DirectoryInfo variable (File Path) and it returns the File Size and File Count within the folder (much like right-clicking a...

Published 11-15-2008 12:00 AM by marl

Filed under: Create SQL Server Login, Msg 0 Level 20 State 0 Line 0, A severe error occurred on the current command, EXCEPTION_ACCESS_VIOLATION, Access Violation on Operating System, DirectoryInfo Access Violation on SQL Server, troubleshooting Access Violation in SQL Server, Msg 0 Level 11 State 0 Line 0

How To: Moving Data Files

Posted by MarlonRibunal In this post let’s move a data file from its default location to another location. I have created a database I called “Test” for the demo. First let’s just check where the data file is currently stored:...

Published 11-06-2008 3:10 PM by marl

Filed under: moving sql server data file

How To: Summarize Aggregated Data Using Pivot in TSQL

This question posted on StackOverflow.com caught my attention. This is a common data requirement specially in Data Analysis. It goes like this: I have a table like as follows: SoftwareName Count Country Project 15 Canada Visio 12 Canada Project 10 USA...

Published 10-29-2008 10:00 PM by marl

Filed under: SQL Server Aggregated Data, Pivot in SQL Server, TSQL Pivot, Summarize data using pivot, How To Pivot in TSQL

Querying the Object Catalog and Information Schema Views

Okay, these are at least the two ways you can query the Metadata in SQL Server (TSQL). The first one is like what I’ve already shown here , which has the following TSQL code: SELECT T . NAME AS [TABLE NAME] , C . NAME AS [COLUMN NAME] , P . NAME...

Published 10-24-2008 12:49 AM by marl

Filed under: SQL Server Information Schema Views, sql server metadata query, Sql Server Object Catalog Views

The “ALL” Parameter In SQL Server Reporting Services 2005

One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can...

Published 10-18-2008 6:58 PM by marl

Filed under: SQL Server Reporting Services, TSQL, ALL Parameter in SSRS 2005

How To: Create Dynamic File System Directory Inside TSQL

I have created a Backup Script to backup all the databases in our SQL Server 2005. I want to keep old backups for sometime for some reason; so I want to create subdirectory with the run date as the name of the folder to separate the set of backups by...

Published 07-14-2008 9:24 AM by marl

Filed under: Execute DOS Command in TSQL, how to enable dos command execution in sql server 2005, shell command in sql server 2005, xp_cmdshell

How To: Rename SQL Server 2005 Database Using TSQL

For some reasons, DBA's need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named "Bad_Ass_DB" into "Best_Practice_DB". This is how Database...

Published 07-10-2008 1:26 AM by marl

Filed under: SQL Server 2005 Rename Database, how to rename a SQL Server Database

SCREENCAST: SQL SERVER 2005 TRIGGER 101

This is my first screencast ever. I don't know where to post this so I just archived and upload it to Sky Drive. You can find the dowload link below: http://cid-7db5650814ac4824.skydrive.live.com/self.aspx/Public/DevPinoySQLServerTriggerDemo.rar Password...

Published 06-19-2008 11:21 PM by marl

Filed under: SQL server trigger 101 screencast

Finding All User Tables and Their Columns & Data Types In SQL Server Using Object Catalog Views

Here's a quick TSQL solution that you can use to find all the User Tables and their Columns, inluding Data Types, and Column size. This is useful when you need a quick way of finding info on creating your Database's documentation. Whenever I am...

Published 06-16-2008 12:09 AM by marl

Filed under: Find User Tables and Columns in SQL Server, SQL Servererver Object Catalog Views

Isolation Levels and Locks in SQL Server 2005

One of the most popular trick questions in most DBA interviews is about Isolation Level/Locks. The same is true with any jobs related to BI and Data Warehouse. It is a common thing that sometimes we come across errors that came out of anomalous data caused...

Published 05-28-2008 2:18 AM by marl

Filed under: SQL Server 2005 failover clustering, Database locks, SQL Servererver 2005 Isolation Levels

TDD is Gaining Some Ground

Here's what Steven Harman has found out in a recent trip: TDD is Gaining Some Ground somewhere... [Taken by Steven Harman at Crowne Plaza front desk in West Michigan]

Published 05-13-2008 9:15 PM by marl

Filed under: Test-Driven, TDD

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

Published 05-10-2008 2:52 AM by marl

Filed under: sql server, career development, .NET Training

System.Net.Mail - Everything That You Need To { know }

All the possible things you need to know about System.Net.Mail http://www.systemnetmail.com/default.aspx

Published 05-09-2008 10:56 PM by marl

Filed under: System.Net.Mail, mail in your program, how to send mail in vb, how to send mail in c#, send mail

Syndication

Recent Posts

Tags

My Blog List

Archives