dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 424 days, 12 hours, 52 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
7
Shouts
spam Shout it Mute it

Easy URL routing in ASP.NET 4.0 web forms
published 531 days, 2 hours, 31 minutes ago posted by dharadhara 539 days, 7 hours, 51 minutes ago
Friday, January 06, 2012 3:51:12 PM GMT Thursday, December 29, 2011 10:30:27 AM GMT
In this post I am going to explain URL routing in greater details. This post will contain basic of URL routing and will explain how we can do URL routing in fewer lines of code. Why we need URL routing? Let’s consider a simpler scenario we want to display... (more)
category: Web Dev | clicked: 21 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
7
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 2: Creating Azure account and a SQL Azure Database
published 535 days, 7 hours, 48 minutes ago posted by dharadhara 539 days, 7 hours, 52 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Thursday, December 29, 2011 10:29:59 AM GMT
In this article, we will first get you a Windows Azure account, if you don’t have one. Then, we will create a SQL Azure Database. And then, we will try connecting to it through SQL Server Management Studio running on our machine. (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, SQL Azure, Azure
9
Shouts
spam Shout it Mute it

Find out the referenced tables of a table that to be added as articles in replication
published 535 days, 7 hours, 48 minutes ago posted by dharadhara 541 days, 6 hours, 30 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Tuesday, December 27, 2011 11:52:08 AM GMT
In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider... (more)
category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

CAPTCHAs do not mitigate XSS worms
published 535 days, 7 hours, 48 minutes ago posted by dharadhara 541 days, 6 hours, 31 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Tuesday, December 27, 2011 11:51:01 AM GMT
One common misconception about web security is that protecting important actions with CAPTCHAs can prevent XSS attacks from doing real damage. By preventing malicious code from scripting critical tasks, the idea goes, XSS injections won’t... (more)
category: Web Dev | clicked: 33 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
8
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 1: What is SQL Azure?
published 535 days, 7 hours, 48 minutes ago posted by dharadhara 541 days, 6 hours, 32 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Tuesday, December 27, 2011 11:50:21 AM GMT
In this article, we are going to begin our journey of learning SQL Azure. We will first see where SQL Azure fits in the Windows Azure Platform offerings. We will then discuss about the ways in which we can define SQL Azure. (more)
category: Data | clicked: 20 | 1 comment | | source: beyondrelational.com
tags: SQL Azure, Azure
6
Shouts
spam Shout it Mute it

Day 6: Common Table Expressions using WITH clause in PostgreSQL
published 541 days, 9 hours, 16 minutes ago posted by dharadhara 544 days, 10 hours, 21 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:01:04 AM GMT
Common Table Expression(CTE) is particularly useful when subquery is executed multiple times. It is equally helpful in place of temporary tables.It computes the aggregation once, and allows us to reference it by its name (may be multiple times) in the... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Dynamic SQL for Optional Parameters
published 541 days, 9 hours, 16 minutes ago posted by dharadhara 544 days, 10 hours, 21 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:00:43 AM GMT
I often see screens or reports that take multiple parameters. Each of those parameters is optional. The code SQL behind those reports often looks like this SELECT COUNT(*) AS Orders SUM(TotalDue) as TotalDue FROM Sales.SalesOrderHeader SOH WHERE (CustomerID... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2
published 541 days, 9 hours, 16 minutes ago posted by dharadhara 544 days, 10 hours, 22 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:00:19 AM GMT
In my last post, SQL Server 2012: Detecting Sort Warnings with Extended Events (sortwarning event) I showed how to use sortwarning event with sql_text action to detect sort warnings in database with statements sent to SQL server instance. We also saw... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

SQL server 2012 Startup parameters
published 542 days, 10 hours, 6 minutes ago posted by dharadhara 545 days, 7 hours, 53 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Friday, December 23, 2011 10:29:12 AM GMT
I’m sure that I’m not the only one with nightmares about the startup parameters in older versions of SQL Server 200x – the design and UI is just bad, it is so easy to forget a semicolon or mess up the syntax – and to end up with SQL Server that is not... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 9: Developing SQL Azure applications
published 541 days, 9 hours, 16 minutes ago posted by dharadhara 545 days, 7 hours, 53 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Friday, December 23, 2011 10:28:43 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 of previous blog... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SQL Azure
8
Shouts
spam Shout it Mute it

Day 5: Generate Identity Column in PostgreSQL by using Serial Datatype
published 542 days, 10 hours, 6 minutes ago posted by dharadhara 545 days, 7 hours, 54 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Friday, December 23, 2011 10:28:16 AM GMT
In PostgreSQL we can use the Serial datatype for generating the identity column CREATE TABLE tblIndentity ( EmpID Serial NOT NULL, EmpName Character Varying(20) ); NOTICE: CREATE TABLE will create implicit sequence "tblindentityempidseq" for... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Day 3: Overlay function in PostgreSQL
published 546 days, 18 hours, 16 minutes ago posted by dharadhara 548 days, 5 hours, 2 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:20:10 PM GMT
Purpose: To replace substring from a specified position to a specified position. Syntax: Overlay(string placing string from int [for int]) Example Select Overlay('www.beyondnational.com' Placing 'relational' From 11 For 8) "Overlay... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Automated Trigger To Require a WHERE Clause
published 546 days, 18 hours, 16 minutes ago posted by dharadhara 548 days, 5 hours, 12 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:09:30 PM GMT
The Problem I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS
published 546 days, 18 hours, 16 minutes ago posted by dharadhara 548 days, 5 hours, 19 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:03:07 PM GMT
In this article we are going to see how to create a Matric Report with the help of the Report Wizard and Report Designer. In our earlier articles, we have covered how to design and deploy the report to the server with the option to design using the wizard and also with the report designer. However, in this article we are going to see how to make a matrix type report, since most of the business reports are developed based on the pivot format to analyze. (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
8
Shouts
spam Shout it Mute it

SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function « SQL Server Journey with SQLAuthority
published 546 days, 18 hours, 16 minutes ago posted by pinaldavepinaldave 548 days, 12 hours, 34 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 5:47:44 AM GMT
Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you. SELECT 'Current Time ' + GETDATE() I quickly modified script to following workaround and my script worked right away. SELECT 'Current Time ' + CAST(GETDATE() AS VARCHAR(20)) Current Time Dec 20 2011  7:00PM However... (more)
category: Data | clicked: 17 | 2 comments | | source: blog.sqlauthority.com
7
Shouts
spam Shout it Mute it

Multipart names and keyboard shortcuts
published 547 days, 22 hours, 49 minutes ago posted by dharadhara 553 days, 9 hours, 13 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Thursday, December 15, 2011 9:08:38 AM GMT
I had blogged about Different ways to know structure of the tables . One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc. Consider the following... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

DB2 Database code set
published 546 days, 18 hours, 16 minutes ago posted by dharadhara 553 days, 9 hours, 14 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Thursday, December 15, 2011 9:08:19 AM GMT
The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset To get the DB2 database code set value, use: db2 get db cfg for MY_DB --From a... (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 8 -Show SSRS Report in ASP.NET Web Page
published 546 days, 18 hours, 16 minutes ago posted by dharadhara 553 days, 9 hours, 14 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Thursday, December 15, 2011 9:07:49 AM GMT
In this article, we will cover how to use the deployed SSRS Report on to the ASP.NET Web application. In our earlier articles we have seen the steps to create and deploy the report to the Reporting Server and administer the deployed reports. In real time, we have seen requirements on accessing the reports from different clients. (more)
category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
10
Shouts
spam Shout it Mute it

SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book « SQL Server Journey with SQLAuthority
published 546 days, 18 hours, 16 minutes ago posted by pinaldavepinaldave 554 days, 13 hours, 47 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Wednesday, December 14, 2011 4:34:48 AM GMT
I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case scenario.Setup environment CREATE DATABASE TestDB GO USE TestDB GO CREATE TABLE TestTable (ID INT) GO CREATE PROCEDURE TestSP AS SELECT 1 Col GO Drop Table The drop table will works and gives ... (more)
category: Data | clicked: 29 | 1 comment | | source: blog.sqlauthority.com
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 547 days, 22 hours, 49 minutes ago posted by dharadhara 555 days, 8 hours, 40 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
Previous 1 2 3 4 5 6 7 8 9 10 ... 42 43 Next