ramireddy

ramireddy
Name: ramireddy
Score: 922.07
Last Seen: 394 days, 8 hours, 24 minutes ago
Member Since: 8 June, 2011
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

Study of WAITSTATS(Part 5) - ASYNC_NETWORK_IO
published 516 days, 19 hours, 30 minutes ago posted by kinj312kinj312 523 days, 5 hours, 45 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Wednesday, December 14, 2011 9:16:45 AM GMT
ASYNCNETWORKIO, as the name suggests it is a wait type associated with the network. Infact it deals with the network buffers. Does it mean it is completely a network issue? - Never, it might be a network issue or not. However we need to check our end... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server
published 516 days, 19 hours, 30 minutes ago posted by dharadhara 524 days, 5 hours, 23 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:39:19 AM GMT
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
9
Shouts
spam Shout it Mute it

Day 76: PL/SQL - 14 (Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS))
published 516 days, 19 hours, 30 minutes ago posted by dharadhara 524 days, 5 hours, 20 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:41:34 AM GMT
Sign in | JoinHomeBlogsAskJust LearnedPostswhat.isnew.inPuzzlesToolsQuizModules (beta) Getting Started with SSRS - Part 6 : Creating Deleting and Moving a folder in SSRS Server First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. niladri.biswasHomeRSS for PostsRecent Blog PostsDay 12: Math functions and operators in PostgreSQL...Day 11: Math functions and op... (more)
category: Data | clicked: 17 | 1 comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl, TSQL
9
Shouts
spam Shout it Mute it

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2
published 516 days, 19 hours, 30 minutes ago posted by dharadhara 524 days, 5 hours, 22 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:40:04 AM GMT
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
10
Shouts
spam Shout it Mute it

Day 75: PL/SQL - 13 (How to make custom Aggregate Function in Oracle)
published 524 days, 22 minutes ago posted by dharadhara 525 days, 6 hours, 44 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 524 days, 22 minutes ago posted by dharadhara 525 days, 6 hours, 46 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 515 days, 14 hours, 57 minutes ago posted by dharadhara 525 days, 6 hours, 46 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
10
Shouts
spam Shout it Mute it

WCF # 10 – WCF channel shapes and communication patterns (Message exchange patterns)
published 524 days, 22 minutes ago posted by kinj312kinj312 527 days, 6 hours, 27 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:35:31 AM GMT
Hi Geek, In our last post Channels , we see how messages are exchange in WCF using channels , In this post we will see the types of message exchange patterns in WCF . WCF supports three distinct message-exchange patterns: 1) One Way 2) Duplex 3) Request... (more)
category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
10
Shouts
spam Shout it Mute it

Data Loading Performance Guide
published 524 days, 22 minutes ago posted by kinj312kinj312 527 days, 6 hours, 26 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:35:50 AM GMT
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document. Highlights Understanding Minimally Logged Operations Trace Flag 610 (sql server 2008) Summarizing... (more)
category: Data | clicked: 28 | 1 comment | | source: beyondrelational.com
tags: SQL Server, Database
9
Shouts
spam Shout it Mute it

Day 74: ROW_NUMBER, RANK, DENSE_RANK, NTILE in Oracle
published 524 days, 22 minutes ago posted by kinj312kinj312 527 days, 6 hours, 26 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:36:13 AM GMT
RowNumber() - Assigns sequential numbers to the records of a result-set or to the records within groups of a result-set Rank() - Returns the rank of each row within the partition of a result set. DenseRank() - Returns the rank of rows within the partition... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Oracle
8
Shouts
spam Shout it Mute it

Day 73: Merge Statement in Oracle
published 526 days, 2 hours, 50 minutes ago posted by dharadhara 528 days, 6 hours, 21 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 8:41:15 AM GMT
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
spam Shout it Mute it

A new feature of SQL Server Denali - Multi Monitor Support of SSMS
published 526 days, 2 hours, 50 minutes ago posted by dharadhara 528 days, 6 hours, 21 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 8:40:49 AM GMT
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
spam Shout it Mute it

Adding a Target line to a Horizontal Bar Chart in SSRS
published 526 days, 2 hours, 50 minutes ago posted by dharadhara 528 days, 6 hours, 22 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 8:40:26 AM GMT
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
9
Shouts
spam Shout it Mute it

Choosing binding for WCF service
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 530 days, 6 hours, 8 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:58 AM GMT
There are different types of bindings supported by WCF. Now question is which binding is suitable for your service.Following is list of frequently used bindings in WCF: BasicHttpBinding : If clients can be non-WCF. This exposes service to the outside... (more)
category: Web Dev | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
8
Shouts
spam Shout it Mute it

SQL Server – Profiler – Part 4 – Review T-SQL code to identify objects no longer supported by Microsoft - Deprecation Event
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 530 days, 6 hours, 9 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:04 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. Three 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: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Difference between TcpBinding and HttpDualBinding for Callback in WCF
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 530 days, 6 hours, 9 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Wednesday, December 07, 2011 8:53:32 AM GMT
The Http bindings serialized messages into XML and send them via HTTP. HTTP is request response protocol, which is one way communication at a time. Caller sends requests to the server and server responds and sends response messages. Once the response... (more)
category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com
tags: .NET, WCF, ASP.NET
7
Shouts
spam Shout it Mute it

Day 70: Dual table in Oracle
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 532 days, 4 hours, 31 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Monday, December 05, 2011 10:31:08 AM GMT
Purpose: It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1. It's structure looks as under SQL> Desc Dual; Name Null? Type ----------------------------------------- -------- ------------- DUMMY VARCHAR2(1) The... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, Oracle
9
Shouts
spam Shout it Mute it

Aggregate functions always return at least a row although table is empty
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 532 days, 4 hours, 32 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
9
Shouts
spam Shout it Mute it

SQL Server 2012: Service Accounts Changes
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 532 days, 4 hours, 33 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
8
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 4 - Configuring SQL Server Reporting Services in Windows Server 2008
published 529 days, 10 hours, 36 minutes ago posted by kinj312kinj312 535 days, 5 hours, 3 minutes ago
Thursday, December 08, 2011 4:26:26 AM GMT Friday, December 02, 2011 9:58:48 AM GMT
In our previous articles, we have seen how to install SQL Server Reporting Services and to create a new report using the Report Wizard and Report Designer Window. Now, in this article we are going to see how to configure SQL Server Reporting Services in Windows Server 2008 environment. (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
Previous 1 2 3 4 5 6 7 8 9 10 11 12 ... 15 16 Next