dhara

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

SQL Table Columns Disappear in Access
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 584 days, 9 hours, 25 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Saturday, October 15, 2011 10:01:24 AM GMT
A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns. There were no permissions issues and the columns all showed up properly if they looked... (more)
category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips – Editing, exporting & importing
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 585 days, 12 hours, 15 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Friday, October 14, 2011 7:11:33 AM GMT
The debugger in the SQL Server Management Studio (SSMS) for the upcoming SQL 11 (“Denali”) is packed with exciting features.The new SSMS is a derivative of the VS2010 shell and therefore extends the same debugging experience (with the obvious differences... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, denali
6
Shouts
spam Shout it Mute it

SQL Server Denali: New warnings in Actual Execution Plan
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 585 days, 12 hours, 16 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Friday, October 14, 2011 7:11:13 AM GMT
I’ve played with SQL Server Denali and found some new features and improvements in Query Execution plan. My intention was to test Extended Events and new events: sortwarning and hashwarnig. In SQL Server 2008R2, we can create SQL Trace to capture... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, denali
7
Shouts
spam Shout it Mute it

HTML Encoded Expressions in ASP.NET4
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 585 days, 12 hours, 16 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Friday, October 14, 2011 7:10:55 AM GMT
Today I would like to discuss an interesting feature that is available only in ASP.NET4. It is primarily used in MVC3 applications. ASP.NET 4.0 comes with a Encoded Expressions <%: expression %> that will automatically convert string into html encoded... (more)
category: Web Dev | clicked: 13 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
8
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 3
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 586 days, 9 hours, 49 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Thursday, October 13, 2011 9:37:25 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. In this blog... (more)
category: Data | clicked: 9 | 5 comments | | source: beyondrelational.com
tags: SQL Server, SQL Azure
6
Shouts
spam Shout it Mute it

THROW - New Addition for Error Handler in SQL Server Denali
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 586 days, 9 hours, 52 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Thursday, October 13, 2011 9:34:55 AM GMT
Now we have so many options and ways to handle errors in SQL Server. And It is very easy today because of addition or enhancement of error handling in SQL Server. You can read all features of SQL Server Denali. (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, denali
8
Shouts
spam Shout it Mute it

Internals of .NET Objects and Use of SOS
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 586 days, 9 hours, 52 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Thursday, October 13, 2011 9:34:32 AM GMT
Well, now getting deeper into the facts, lets talk about how objects are created in .NET and how type system is laid out in memory for this post in my Internals Series . As this is going to be very deep dive post, I would recommend to read this only if... (more)
category: Web Dev | clicked: 42 | 5 comments | | source: beyondrelational.com
tags: .NET, ASP.NET
6
Shouts
spam Shout it Mute it

Day 11: Width_Bucket function in Oracle
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 587 days, 12 hours, 13 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Wednesday, October 12, 2011 7:14:14 AM GMT
Let Us Learn Oracle - Part 11 of N [ WidthBucket function in Oracle ] Source table: tblPlayers Syntax: WidthBucket(Expression, Minimum,Maximum,Number) Purpose: This function divides a given data set into buckets with an equal interval size. e.g. Marks... (more)
category: Data | clicked: 5 | 5 comments | | source: beyondrelational.com
tags: SQL Server, Oracle
6
Shouts
spam Shout it Mute it

Day 12: NVL function in Oracle
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 587 days, 12 hours, 14 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Wednesday, October 12, 2011 7:12:32 AM GMT
Let Us Learn Oracle - Part 12 of N [ NVL function in Oracle ] Source table: tblPlayers Purpose: It substitute a value when a null value is encountered. Syntax: NVL( ColumnName, ReplaceValue ) Where, ColumnName => It is the column that is use for null... (more)
category: Data | clicked: 5 | 4 comments | | source: beyondrelational.com
tags: SQL Server, Oracle
6
Shouts
spam Shout it Mute it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Data Tips
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 587 days, 12 hours, 15 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Wednesday, October 12, 2011 7:12:12 AM GMT
The debugger of any IDE is a very powerful tool because it gives developers the insight on how their program or script is functioning. I have throughout been a SQL person, and have always felt that at some stage, Microsoft SQL Server did not deliver at... (more)
category: Data | clicked: 9 | 6 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, denali
8
Shouts
spam Shout it Mute it

Internals of Interface and its Implementation
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 588 days, 12 hours, 1 minute ago
Thursday, October 13, 2011 8:30:22 PM GMT Tuesday, October 11, 2011 7:25:40 AM GMT
As many of my followers requested me to write few things that I missed out from the Internals Series , I should continue with it. In this post, I will cover the internals of Interface implementation and mostly talk about explicit interface implementation... (more)
category: Web Dev | clicked: 42 | 4 comments | | source: beyondrelational.com
tags: .NET, ASP.NET
11
Shouts
spam Shout it Mute it

Day 10: BitAnd function in Oracle
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 588 days, 12 hours, 2 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 11, 2011 7:24:21 AM GMT
Let Us Learn Oracle - Part 10 of N [ BitAnd function in Oracle ] Syntax: BitAnd(X,Y) Purpose: Computes bitwise logical AND operation of 'X' and 'Y' where 'X' and 'Y' are positive integers Example: SQL> Select BitAnd... (more)
category: Data | clicked: 29 | 13 comments | | source: beyondrelational.com
tags: SQL Server, Oracle
8
Shouts
spam Shout it Mute it

How to change/reset SQL login password
published 578 days, 13 hours, 34 minutes ago posted by dharadhara 588 days, 12 hours, 3 minutes ago
Friday, October 21, 2011 5:53:06 AM GMT Tuesday, October 11, 2011 7:23:57 AM GMT
Yesterday I saw a question about required permission for changing SQL Server login password and I decided to write a blog post about it. Question was: I have a SQL logins: Login1 and Login2. I gave ALTER LOGIN permission on Login1 to Login2 so that Login2... (more)
category: Data | clicked: 64 | 9 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

MSBI # 40 - SSIS # 17 - Data Flow Task # 3 - All Source and Destination Overview {Part - II} - Vishal Pawar's Blog
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 589 days, 12 hours, 19 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Monday, October 10, 2011 7:07:58 AM GMT
Hi folks, I just apologize to my reader for not posting from last week !! Rather than throwing lots of reason I will just say I am lazy . So here onwards I will try to be regular !! Continuing from my last post on SSIS Data Flow Task MSBI # 38 – SSIS... (more)
category: Data | clicked: 7 | 2 comments | | source: beyondrelational.com
tags: SQL Server, MSBI, TSQL, BI
6
Shouts
spam Shout it Mute it

Parsing @@Version to get SQL Server edition
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 589 days, 12 hours, 20 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Monday, October 10, 2011 7:07:00 AM GMT
One of my friends asked me if it is possible to get SQL Server version number and edition name by parsing the result returned from @@VERSION. The system function @@VERSION gives information about the version and operatiing system information of the Server... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Breakpoints - “When Hit” do something
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 589 days, 12 hours, 20 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Monday, October 10, 2011 7:06:21 AM GMT
During Tech-Ed (read my 3 part series here – Part 01 , Part 02 , Part 03 ), I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL 11 (Code Named: “Denali”). I am currently summarizing... (more)
category: Data | clicked: 4 | 5 comments | | source: beyondrelational.com
tags: SQL Server, denali
4
Shouts
spam Shout it Mute it

Day 7: CHR function in Oracle
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 592 days, 11 hours, 49 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Friday, October 07, 2011 7:38:10 AM GMT
Let Us Learn Oracle - Part 7 of N [ CHR function in Oracle ] Source table: tblPlayers Purpose: Return the ASCII character of the number specified SQL> Select CHR(65) From Dual; C - A It does not return the ASCII of any character SQL> select chr... (more)
category: Data | clicked: 3 | 5 comments | | source: beyondrelational.com
tags: SQL Server, Oracle
4
Shouts
spam Shout it Mute it

Create Label Printing Report in SSRS
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 592 days, 11 hours, 49 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Friday, October 07, 2011 7:37:46 AM GMT
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Builder... (more)
category: Data | clicked: 12 | 3 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
5
Shouts
spam Shout it Mute it

How to monitor number of VLF’s in your database
published 585 days, 22 hours, 56 minutes ago posted by dharadhara 592 days, 11 hours, 50 minutes ago
Thursday, October 13, 2011 8:30:22 PM GMT Friday, October 07, 2011 7:37:15 AM GMT
A few weeks back we did a blog post about a file grow bug that has been fixed with SQL Server Denali ( Autogrow bug – fixed with Denali ). The same blog posted explained why it is important not to have millions of VLF’s (Virtual Log Files... (more)
category: Data | clicked: 5 | 6 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
5
Shouts
spam Shout it Mute it

SQL 11 (Code Name: “Denali”) – Debugging enhancements – Export/Import Breakpoints
published 592 days, 21 hours, 45 minutes ago posted by dharadhara 594 days, 8 hours, 49 minutes ago
Thursday, October 06, 2011 9:41:22 PM GMT Wednesday, October 05, 2011 10:37:40 AM GMT
During Tech-Ed (read my 3 part series here – Part 01 , Part 02 , Part 03 ), I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL 11 (Code Named: “Denali”). I am currently summarizing... (more)
category: Data | clicked: 7 | 4 comments | | source: beyondrelational.com
tags: SQL Server, denali
Previous 1 2 ... 5 6 7 8 9 10 11 12 13 14 ... 42 43 Next