DotNetShoutout

dhara

Name:	dhara
Score:	12,446.92
Last Seen:	422 days, 11 hours, 49 minutes ago
Member Since:	12 August, 2010

9
Shouts

Shout it

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

published 545 days, 21 hours, 46 minutes ago posted by

dhara 553 days, 7 hours, 38 minutes ago

This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence. (more)

category: Data | clicked: 15 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

9
Shouts

Shout it

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server

published 545 days, 21 hours, 46 minutes ago posted by

dhara 553 days, 7 hours, 39 minutes ago

In this article, we will see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. (more)

category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, SSRS

10
Shouts

Shout it

Day 75: PL/SQL - 13 (How to make custom Aggregate Function in Oracle)

published 553 days, 2 hours, 39 minutes ago posted by

dhara 554 days, 9 hours ago

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

Shout it

Getting started with SQL Azure - Part 7: SQL Azure administration - I

published 553 days, 2 hours, 39 minutes ago posted by

dhara 554 days, 9 hours, 2 minutes ago

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

Shout it

SQL Server – Profiler – Part 5 – Replaying a trace – from a file or a table – using breakpoints during trace replay

published 544 days, 17 hours, 13 minutes ago posted by

dhara 554 days, 9 hours, 2 minutes ago

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

Shout it

Day 73: Merge Statement in Oracle

published 555 days, 5 hours, 6 minutes ago posted by

dhara 557 days, 8 hours, 37 minutes ago

Purpose: It is a DML statement that is use for performing the Insert / Update or Delete statement to the target table based on the conditions supplied. It is introduce from Oracle 9i Let us see an example to understand this one First let us create a source... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

7
Shouts

Shout it

A new feature of SQL Server Denali - Multi Monitor Support of SSMS

published 555 days, 5 hours, 6 minutes ago posted by

dhara 557 days, 8 hours, 38 minutes ago

I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3 . Multi Monitor Support is the new feature among them. We can do with this feature : 1. Using this feature we can use multi screen of query analyzer or... (more)

category: Data | clicked: 36 | 1 comment | | source: beyondrelational.com

tags: SQL Server, ssms, TSQL

7
Shouts

Shout it

Adding a Target line to a Horizontal Bar Chart in SSRS

published 555 days, 5 hours, 6 minutes ago posted by

dhara 557 days, 8 hours, 38 minutes ago

This is usually the time of the year when I get to my laziest best. The cold weather and the approaching holiday season brings out the sloth in me and I have a huge backlog of articles I need to read as well as tend to. But somehow I have pulled... (more)

category: Data | clicked: 20 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, SSRS

8
Shouts

Shout it

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY « Journey to SQLAuthority

published 583 days, 10 hours, 52 minutes ago posted by

pinaldave 585 days, 10 hours, 33 minutes ago

Some time an interesting feature and smart audience makes total difference at places. From last two days, I have been writing on SQL Server 2012 feature FIRSTVALUE and LASTVALUE. Please read following post before I continue today as this question is based on the same.Introduction to FIRSTVALUE and LASTVALUEIntroduction to FIRSTVALUE and LASTVALUE with OVER clause As a comment of the second post I received excellent question from Nilesh Molankar. He asks what will happen if we change few things in... (more)

category: Data | clicked: 61 | 1 comment | | source: blog.sqlauthority.com

5
Shouts

Shout it

XEvent Session - System_health

published 583 days, 10 hours, 52 minutes ago posted by

dhara 585 days, 11 hours, 10 minutes ago

Today Am going to explain something about the ring buffer which is an internal structure in SQL server that captures various information like security errors, any kind of exceptions, scheduler information, resource monitor information etc. How did I reach... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

Day 49: UserEnv function of Oracle

published 583 days, 10 hours, 52 minutes ago posted by

dhara 585 days, 11 hours, 11 minutes ago

Let Us Learn Oracle - Part 49 of N [ UserEnv Function of Oracle 10g ] Purpose: This function retrives information about current Oracle Session. Syntax: UserEnv(Parameter) Where, Parameter = > It is value return from the current Oracle Session Examp;le... (more)

category: Data | clicked: 7 | comment | | source: beyondrelational.com

tags: SQL Server, Oracle

5
Shouts

Shout it

SQL Server – SSMS – Table Designer v/s ALTER TABLE – Best Practices - Msg 1701 - Creating or altering table failed….This exceeds the maximum allowable table row size of 8060 bytes

published 583 days, 10 hours, 52 minutes ago posted by

dhara 585 days, 11 hours, 11 minutes ago

A few months ago, I wrote about how one might end up with a Message #1701 error when attempting to execute an ALTER TABLE…ALTER COLUMN statement. You can refer the original post here . Vishal Gajjar ( blog ) recently wrote about the Table Designer component. (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Backup/restore/checkdb/shrinkfile progress

published 583 days, 10 hours, 52 minutes ago posted by

dhara 586 days, 9 hours, 13 minutes ago

Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you perform the backup or restore from the gui in management studio, it shows you the progres for every 10%. But what to do if you issuet the backup or restore... (more)

category: Data | clicked: 28 | 3 comments | | source: beyondrelational.com

tags: SQL Server, Database

6
Shouts

Shout it

Day 48: Bin_To_Num function of Oracle

published 583 days, 10 hours, 52 minutes ago posted by

dhara 586 days, 9 hours, 13 minutes ago

Let Us Learn Oracle - Part 48 of N [ BinToNum Function of Oracle 10g ] Purpose: This function converts a bit vector to it's corresponding numeric value Syntax: BinToNum(value1,value2,value3...,valueN) Where, value1,...valueN => are the bit... (more)

category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

6
Shouts

Shout it

Auditing in SQL server

published 583 days, 10 hours, 52 minutes ago posted by

dhara 586 days, 9 hours, 14 minutes ago

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Audit... (more)

category: Data | clicked: 18 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

SQL Server: Simple Parameterization

published 584 days, 13 hours, 56 minutes ago posted by

dhara 587 days, 9 hours, 1 minute ago

Simple parameterization is SQL Server feature which allow the optimizer to parameterize submitted queries. If submitted query has no parameters and has constant values plugged in, the optimizer can choose to treat constant values as parameters and automatically... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

Study of WAITSTATS(Part 3) - WRITELOG

published 584 days, 13 hours, 56 minutes ago posted by

dhara 587 days, 9 hours, 2 minutes ago

When a transaction happens, say for an example data is bening inserted, there are mainly two things happens: 1. data page in the buffer cache is updated. 2. Data is written to the log cache.(This is to ensure the ACID property incase of any rollback.... (more)

category: Data | clicked: 4 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

5
Shouts

Shout it

SQL Server – SSMS - Profiler - Extracting Deadlock Event Data to XDL files

published 584 days, 13 hours, 56 minutes ago posted by

dhara 587 days, 9 hours, 3 minutes ago

A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. We can use the SQL Server Profiler to capture deadlock information. Today, we will see how to use the SQL Server... (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

tags: SQL Server, ssms, TSQL

5
Shouts

Shout it

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

published 584 days, 13 hours, 56 minutes ago posted by

dhara 587 days, 9 hours, 3 minutes ago

This challenge invites you to Generate kaprekar kernel or series from numbers.Kaprekar Series and Kaprekar Constants are numbers generated by applying the Kaprekar Routine on a number! (more)

category: Data | clicked: 3 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

7
Shouts

Shout it

Day 44: First and Last function of Oracle

published 585 days, 15 hours, 5 minutes ago posted by

dhara 588 days, 7 hours, 29 minutes ago

Let Us Learn Oracle - Part 44 of N [ First and Last function of Oracle ] Purpose: Both of these acts as analytical and aggregate function. They atc on a set of rows that act as First or Last as per the given sorting specification. They accepts any numeric... (more)

category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Oracle

Welcome!

dhara

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server

Day 75: PL/SQL - 13 (How to make custom Aggregate Function in Oracle)

Getting started with SQL Azure - Part 7: SQL Azure administration - I

SQL Server – Profiler – Part 5 – Replaying a trace – from a file or a table – using breakpoints during trace replay

Day 73: Merge Statement in Oracle

A new feature of SQL Server Denali - Multi Monitor Support of SSMS

Adding a Target line to a Horizontal Bar Chart in SSRS

SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY « Journey to SQLAuthority

XEvent Session - System_health

Day 49: UserEnv function of Oracle

SQL Server – SSMS – Table Designer v/s ALTER TABLE – Best Practices - Msg 1701 - Creating or altering table failed….This exceeds the maximum allowable table row size of 8060 bytes

Backup/restore/checkdb/shrinkfile progress

Day 48: Bin_To_Num function of Oracle

Auditing in SQL server

SQL Server: Simple Parameterization

Study of WAITSTATS(Part 3) - WRITELOG

SQL Server – SSMS - Profiler - Extracting Deadlock Event Data to XDL files

TSQL Challenge 68 - Generate kaprekar kernel or series from numbers

Day 44: First and Last function of Oracle

Open ID Login

Standard Login

Forgot Password?

Sign up