toveil

toveil
Name: toveil
Score: 19
Last Seen: 526 days, 3 hours, 19 minutes ago
Member Since: 7 December, 2011
DotNetShoutout
atom rss
10
Shouts
spam Shout it Mute it

Day 75: PL/SQL - 13 (How to make custom Aggregate Function in Oracle)
published 526 days, 20 hours, 7 minutes ago posted by dharadhara 528 days, 2 hours, 29 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Monday, December 12, 2011 8:17:57 AM GMT
In this article, we will look into creating our own Aggregate Function in Oracle. User-defined aggregates are a feature of the Extensibility Framework.It is possbile to make user define Aggregate function because of Oracle's Data Cartridge model which... (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl, TSQL
10
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 7: SQL Azure administration - I
published 526 days, 20 hours, 7 minutes ago posted by dharadhara 528 days, 2 hours, 30 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Monday, December 12, 2011 8:16:32 AM GMT
Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure. First summary... (more)
category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: SQL Azure, Azure
13
Shouts
spam Shout it Mute it

SQL Server – Profiler – Part 5 – Replaying a trace – from a file or a table – using breakpoints during trace replay
published 518 days, 10 hours, 41 minutes ago posted by dharadhara 528 days, 2 hours, 31 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Monday, December 12, 2011 8:15:59 AM GMT
Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. Four parts have been published till date, and for your kind reference, here are the links to them: What is a SQL... (more)
category: Data | clicked: 66 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 5 - Deploying a report to the Server
published 532 days, 6 hours, 20 minutes ago posted by kinj312kinj312 534 days, 2 hours, 58 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:48:38 AM GMT
In our earlier articles, we have seen how to design a report and connect to the database to pull out the values based on the requirement to be shown in the report. Also, we have seen the configuration section on how to configure the SQL Server Reporting Services manually by providing the Report Server name. (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
9
Shouts
spam Shout it Mute it

Day 71: Sequence in Oracle
published 532 days, 6 hours, 20 minutes ago posted by kinj312kinj312 534 days, 2 hours, 56 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Tuesday, December 06, 2011 7:50:18 AM GMT
Purpose: Generates auto number field in tables. Syntax CREATE SEQUENCE sequence_name MINVALUE value MAXVALUE value START WITH value INCREMENT BY value CACHE value; We can create a sequence as under SQL> CREATE SEQUENCE MySequence 2 MINVALUE 1 3 MAXVALUE... (more)
category: Data | clicked: 29 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Oracle
9
Shouts
spam Shout it Mute it

SQL Server 2012: Service Accounts Changes
published 532 days, 6 hours, 20 minutes ago posted by kinj312kinj312 535 days, 18 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:29:13 AM GMT
After SQL Server 2012 RC0 installation I noticed a few changes in SQL Server services account configuration. In previous versions (SQL Server 2005 and 2008/R2) during stand-alone SQL Server installation, local Windows group is created and service account... (more)
category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Aggregate functions always return at least a row although table is empty
published 532 days, 6 hours, 20 minutes ago posted by kinj312kinj312 535 days, 16 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:30:27 AM GMT
There are many aggregate functions available in SQL Server. One thing that most of the people forget is that Aggregate functions always return atleast a row no matter if there are rows in the table or where clause returns or does not return any resultset... (more)
category: Data | clicked: 15 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL