kinj312

kinj312
Name: kinj312
Score: 2,488.52
Last Seen: 410 days, 4 hours, 30 minutes ago
Member Since: 26 October, 2010
DotNetShoutout
atom rss
6
Shouts
spam Shout it Mute it

Day 61: PL/SQL - 9 (Writing user define functions in PL/SQL)
published 547 days, 21 hours, 16 minutes ago posted by kinj312kinj312 550 days, 5 hours, 29 minutes ago
Thursday, November 24, 2011 3:12:23 PM GMT Tuesday, November 22, 2011 6:58:52 AM GMT
What is a function? A function is an entity that accepts inputs and returns output. Syntax CREATE OR REPLACE FUNCTION (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl
6
Shouts
spam Shout it Mute it

Day 60: PL/SQL - 8 (SubTypes in PL/SQL)
published 547 days, 21 hours, 16 minutes ago posted by kinj312kinj312 550 days, 5 hours, 30 minutes ago
Thursday, November 24, 2011 3:12:23 PM GMT Tuesday, November 22, 2011 6:58:22 AM GMT
SubTypes in PL/SQL Purpose: These are user defined types based on other data types.It gives an alternate name to the existing type Syntax: SUBTYPE (more)
category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl
6
Shouts
spam Shout it Mute it

Analyzing a DB2 trap file
published 547 days, 21 hours, 16 minutes ago posted by kinj312kinj312 550 days, 5 hours, 30 minutes ago
Thursday, November 24, 2011 3:12:23 PM GMT Tuesday, November 22, 2011 6:57:59 AM GMT
Usually when the DB2 instance ends unexpectedly, trap files are created. There is usually one trap file capturing the root cause. A number of other files are created, supporting data about DB2 processes. The dbdiag.log file indicates which files to analyze... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

Different Properties of SQL Server Database
published 550 days, 20 hours, 49 minutes ago posted by kinj312kinj312 551 days, 19 hours, 18 minutes ago
Monday, November 21, 2011 3:39:39 PM GMT Sunday, November 20, 2011 5:10:30 PM GMT
Hi all, You all are thinking, what I will write here on “Database properties”. Right, it’s a big question in all’s mind. However, I am writing here for each and every property of SQL Database and will discuss in details in future articles. Let’s start... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

DIAGLEVEL db2
published 550 days, 20 hours, 49 minutes ago posted by kinj312kinj312 551 days, 19 hours, 18 minutes ago
Monday, November 21, 2011 3:39:39 PM GMT Sunday, November 20, 2011 5:09:55 PM GMT
Diaglevel refers to the Diagnostic error capture level configuration parameter. There are 5 levels: 0 - No diagnostic data captured 1 - Severe errors only 2 - All errors 3 - All errors and warnings 4 - All errors, warnings and informational messages The... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, Database
8
Shouts
spam Shout it Mute it

SQL Interview Q #1 – What is First Normal Form (1NF)?
published 547 days, 21 hours, 16 minutes ago posted by kinj312kinj312 551 days, 19 hours, 19 minutes ago
Thursday, November 24, 2011 3:12:23 PM GMT Sunday, November 20, 2011 5:08:56 PM GMT
My blog has many practical tips and best pratices for SQL/BI developers,but I haven’t focused on interview questions for SQL/BI developers so far. This might change in the future. It’s been a challenge for many people to break into or stay... (more)
category: Data | clicked: 51 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Prefixing procedure names with sp_ is bad practice. Is this true?
published 609 days, 21 hours, 6 minutes ago posted by kinj312kinj312 618 days, 5 hours, 35 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:53:36 AM GMT
Yes but partly. Let us explore this with examples We have a system procedure spwho that returns the informations about the current connections, users, sessions etc. Let us create a new database named test and create spwho inside it. Case 1 Create database... (more)
category: Data | clicked: 29 | 15 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

SQL Server Myth - Table Name cannot be same as Database Name
published 609 days, 21 hours, 6 minutes ago posted by kinj312kinj312 618 days, 5 hours, 35 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:53:04 AM GMT
Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such myth... (more)
category: Data | clicked: 7 | 13 comments | | source: beyondrelational.com
tags: SQL Server, Database
8
Shouts
spam Shout it Mute it

TSQL Challenge 64 - A Payroll calculation Challenge
published 609 days, 21 hours, 6 minutes ago posted by kinj312kinj312 618 days, 5 hours, 35 minutes ago
Friday, September 23, 2011 3:22:14 PM GMT Thursday, September 15, 2011 6:52:43 AM GMT
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays. (more)
category: Data | clicked: 16 | 13 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
5
Shouts
spam Shout it Mute it

Over clause enhancement in Sql 11 Denali CTP 3
published 625 days, 5 hours, 17 minutes ago posted by kinj312kinj312 627 days, 2 hours, 5 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:23:30 AM GMT
In Denali CTP 3, the Over clause has been enhanced a lot. Let us look into them as below a.Rows and Range These keywords specifies that the function will be applied for every row a window use for calculating the function result. The Rows specifies the... (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
7
Shouts
spam Shout it Mute it

Steps to write a plugin based application with MEF
published 625 days, 5 hours, 17 minutes ago posted by kinj312kinj312 627 days, 2 hours, 5 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:22:47 AM GMT
I have already written a blog on Managed Extensibility Framework few days ago, and you must wonder why I am writing again. Well actually today I have been creating an application that could be easily plugged into a host application. In this blog lets... (more)
category: Web Dev | clicked: 30 | 1 comment | | source: beyondrelational.com
tags: .NET, C#
6
Shouts
spam Shout it Mute it

SSIS #100 – An SSIS package without Sequence Container?
published 625 days, 5 hours, 17 minutes ago posted by kinj312kinj312 627 days, 2 hours, 6 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:22:23 AM GMT
I recently needed to modify an SSIS package to add a few new columns to a table. But I turned out that I had more than just adding columns to do. I did three things prior to adding the columns: I added three Sequence Containers as part of the Control... (more)
category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
7
Shouts
spam Shout it Mute it

SQL Server 2008 Service Pack 3 CTP is available for testing!
published 627 days, 6 hours, 2 minutes ago posted by kinj312kinj312 630 days, 3 hours, 27 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:53 AM GMT
There is no doubt that Microsoft is keeping the DBAs busy with the frequent releases of Cumulative Update packages and CTP releases on existing (2008, 2008 R2 and Denali) versions! Now here is the news about SQL Server 2008 Service Pack 3 CTP release... (more)
category: Data | clicked: 8 | 3 comments | | source: beyondrelational.com
tags: SQL Server, CTP
7
Shouts
spam Shout it Mute it

Correctness and stress test
published 627 days, 6 hours, 2 minutes ago posted by kinj312kinj312 630 days, 3 hours, 28 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:17 AM GMT
Stress test SQL Server for new hardware. Download SQLIOSim from http://download.microsoft.com and install on server. When detailing the file location, use the same as the SQL Server files. SQLIOSim will attempt to simulate the SQL Server database IO path... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

SQL Server Configuration Manager - Hide your SQL Server Instance
published 627 days, 6 hours, 2 minutes ago posted by kinj312kinj312 630 days, 3 hours, 28 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 8:59:50 AM GMT
Data is one of the most critical and valuable components for any industry and it’s protection is every individual’s responsibility. Data lives within Microsoft SQL Server, and therefore, it is the duty of DBAs to ensure that their SQL Server is safe from... (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

MSBI # 23 – SSIS # 10 – Control Flow Tasks # 5 – For Each Loop Container Task
published 630 days, 2 hours, 7 minutes ago posted by kinj312kinj312 633 days, 4 hours, 31 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:56:46 AM GMT
Continuing from my last post on SSIS Control flow task in which we talk lot about For Loop Container: MSBI # 22 – SSIS # 9 – Control Flow Tasks # 4 – For Loop Container Task « (B)usiness (I)ntelligence Mentalist We are covering following points in this... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, MSBI, BI
7
Shouts
spam Shout it Mute it

Data centre management for database servers
published 630 days, 2 hours, 7 minutes ago posted by kinj312kinj312 633 days, 4 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:54:35 AM GMT
Setting up a new database server environment in a new data centre requires testing. It’s a mix of benchmarking and stress testing. Unless you can recreate the underlying traffic and recreate a “realistic” production environment, then... (more)
category: Data | clicked: 11 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
7
Shouts
spam Shout it Mute it

SQL Server – "Denali" – PERCENT_RANK() Analytic Function
published 630 days, 2 hours, 7 minutes ago posted by kinj312kinj312 633 days, 4 hours, 34 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:54:12 AM GMT
PERCENTRANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENTRANK() ranks rows between 0 and 1, both inclusive. Computation formula used by PERCENT_RANK(): (RANK() – 1) / (Number of Rows – 1)... (more)
category: Data | clicked: 28 | comment | | source: beyondrelational.com
tags: SQL Server, denali
8
Shouts
spam Shout it Mute it

Database Tuning overview – Buffer Tuning
published 637 days, 8 hours, 54 minutes ago posted by kinj312kinj312 639 days, 2 hours, 45 minutes ago
Saturday, August 27, 2011 3:33:58 AM GMT Thursday, August 25, 2011 9:42:51 AM GMT
As part of the Performance Tuning series – Performance Stack , this section looks at Buffer Managment tuning. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large proportion... (more)
category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
10
Shouts
spam Shout it Mute it

Visual Studio 2010 Color Theme Editor- Customize look of visual studio
published 635 days, 15 hours, 42 minutes ago posted by kinj312kinj312 639 days, 2 hours, 46 minutes ago
Sunday, August 28, 2011 8:46:16 PM GMT Thursday, August 25, 2011 9:42:27 AM GMT
We have all love Visual Studio 2010 and I am sure you all want to change color for menus, toolbars and title etc. Today I have found one of the most interesting Extension for Visual studio 2010 from which you can manage all this things. Don’t believe... (more)
category: Web Dev | clicked: 45 | 1 comment | | source: beyondrelational.com
tags: Visual Studio 2010, ASP.NET
Previous 1 2 3 4 5 6 7 8 9 10 11 Next