dhara

dhara
Name: dhara
Score: 12,446.92
Last Seen: 396 days, 9 hours, 50 minutes ago
Member Since: 12 August, 2010
DotNetShoutout
atom rss
4
Shouts
spam Shout it Mute it

Fun with Square braces
published 441 days, 4 hours, 45 minutes ago posted by dharadhara 450 days, 20 hours, 47 minutes ago
Thursday, March 08, 2012 10:35:16 AM GMT Monday, February 27, 2012 6:33:27 PM GMT
Square braces in SQL Server play a major role in T-SQL programming. When an object name contains a space, special character, etc, the only way to express them is to put them aroud squre braces. Consider that you want to create a table user master (with... (more)
category: Data | clicked: 31 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SSIS Tutorial - Getting started with SSIS - Part 5: Data Flow Task - Sudeep Raj
published 460 days, 18 hours, 47 minutes ago posted by dharadhara 461 days, 20 hours, 43 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Thursday, February 16, 2012 6:36:50 PM GMT
Now we come to the heart and soul of SSIS “DATA FLOW TASK” aka DFT. As the name suggests, it is a task. What kind of task? Data Flow Task that literally means a task where DATA flows. That’s exactly what ETL does, Extract Transform & Load of data. Most of the ETL is done in the Data Flow Task. (more)
category: Data | clicked: 29 | comment | | source: beyondrelational.com
tags: SQL Server, SSIS
7
Shouts
spam Shout it Mute it

Datta's Ramblings on Business Intelligence 'N' Life - Extracting Report URL from ReportServer database in SSRS
published 460 days, 18 hours, 47 minutes ago posted by dharadhara 462 days, 22 hours, 42 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Wednesday, February 15, 2012 4:38:25 PM GMT
I was working on a report for monitoring the usage of reports on a Report Server instance. As part of that, I wanted to display a list of reports with values for various metrics along with few additional links under each of the reports. (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, SSRS
5
Shouts
spam Shout it Mute it

#0134 - SQL Server – SSMS – Tutorial – 09 - Integrating with peripheral services & other SQL Server tools (L200)
published 460 days, 18 hours, 47 minutes ago posted by dharadhara 462 days, 22 hours, 45 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Wednesday, February 15, 2012 4:34:47 PM GMT
As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager – the interface that is used to manage & maintain the SQL Server instance configuration. In addition... (more)
category: Data | clicked: 32 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
6
Shouts
spam Shout it Mute it

SSIS - Delete files older than retention period from folder with parameter using Script Task in SQL Server
published 460 days, 18 hours, 47 minutes ago posted by dharadhara 462 days, 22 hours, 46 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Wednesday, February 15, 2012 4:34:20 PM GMT
After using some of the ways to delete the files from the particular folder like Delete file using Script Task and File System Task in SSIS. We have seen such methods and used logic to get the files from the loop container and process to delete them and... (more)
category: Data | clicked: 32 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Jeff Wharton's Blog - SQL Server Integration Services 2012 (RC0) Project Conversion Bugs
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 463 days, 22 hours, 4 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:15:37 PM GMT
UPDATE – 10th February 2012 Since writing this article I’ve discovered that the Int32 error discussed below occurs irrespective of whether the ServerPort value is greater than 32767 i.e. even a value of 21 (the default) causes the same error. I’ve also... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

#0133 - SQL Server – SSMS – Tutorial – 08 - How SSMS helps in reviewing and configuring your SQL Server Instance (L200)
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 463 days, 22 hours, 5 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:14:59 PM GMT
One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of... (more)
category: Data | clicked: 19 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SSIS Tutorial - Getting started with SSIS - Part 4: Control Flow - Sudeep Raj
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 463 days, 22 hours, 5 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:14:39 PM GMT
In Control Flow, we set up the flow of jobs in an ETL process, like fetching the files from ftp location to local and then make the file ready for ETL or at times, we clear the staging tables before the ETL process. All such tasks are done before ETL commences. (more)
category: Data | clicked: 27 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
5
Shouts
spam Shout it Mute it

Question of the month February 2012 - Find out problamatic query
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 464 days, 21 hours, 22 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Monday, February 13, 2012 5:57:52 PM GMT
Without running these queries can you find out the query that would throw an error? (more)
category: Data | clicked: 27 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Client side Model binding with ASP.NET MVC 3 and KnockoutJs
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 464 days, 21 hours, 23 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Monday, February 13, 2012 5:57:27 PM GMT
Client side Model binding with ASP.NET MVC 3 and KnockoutJs Knockoutjs is type safe client side library which provides declarative bindings of DOM with model data, Automatic UI refresh when view model changes etc. You can read more about KnockoutJS on... (more)
category: Web Dev | clicked: 92 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
5
Shouts
spam Shout it Mute it

#0132 - SQL Server – SSMS – Tutorial – Part 07 - Database Administration and maintenance - Productivity enhancing features (L200)
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 464 days, 21 hours, 23 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Monday, February 13, 2012 5:56:51 PM GMT
The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
3
Shouts
spam Shout it Mute it

SQL Server 2012 Virtual Labs
published 462 days, 8 hours, 49 minutes ago posted by dharadhara 467 days, 20 hours, 30 minutes ago
Thursday, February 16, 2012 6:31:00 AM GMT Friday, February 10, 2012 6:50:00 PM GMT
Want to play around with SQL Server 2012 but don’t have an environment to play around in? Check out the following SQL Server 2012 Virtual Labs: (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
4
Shouts
spam Shout it Mute it

Number- New HTML5 Input type
published 462 days, 1 hour, 6 minutes ago posted by dharadhara 467 days, 20 hours, 32 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Friday, February 10, 2012 6:48:10 PM GMT
I have been writing few series of new HTML5 input types and this is another post on same series. In this post I am going to explain Number input types. The number type is for numeric values. When you use number input type it will have spinner with up... (more)
category: Web Dev | clicked: 51 | 2 comments | | source: beyondrelational.com
tags: .NET, ASP .NET
3
Shouts
spam Shout it Mute it

URL–New HTML5 input element
published 462 days, 8 hours, 49 minutes ago posted by dharadhara 467 days, 20 hours, 32 minutes ago
Thursday, February 16, 2012 6:31:00 AM GMT Friday, February 10, 2012 6:47:41 PM GMT
In earlier post we have seen how the email input tag work in the browser. HTML5 comes with lots of new goodies and today we are going to see one of another new html5 input types URL. In most of the sites once you fill your contact and personal information... (more)
category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com
tags: .NET, ASP.NET
8
Shouts
spam Shout it Mute it

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
published 466 days, 22 hours, 30 minutes ago posted by pinaldavepinaldave 470 days, 8 hours, 22 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 6:57:54 AM GMT
SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to share SQL Tips which are small and easy to digest. (more)
category: Data | clicked: 26 | comment | | source: blog.sqlauthority.com
7
Shouts
spam Shout it Mute it

Identity column with decimal datatype
published 468 days, 17 hours, 4 minutes ago posted by dharadhara 471 days, 19 hours, 8 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:12:20 PM GMT
One of the members in the forum asked about using decimal datatype in identity column. The question was "Is decimal point allowed in the identity column?" Ok. The identity column can never have any decimal points. It is a whole number. The decimal... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

#0130 - SQL Server – SSMS – Tutorial – Part 05 – The Wizards of SSMS - Table Designer, Query designer & Template Explorer (L100)
published 468 days, 17 hours, 4 minutes ago posted by dharadhara 471 days, 19 hours, 8 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:11:51 PM GMT
The SQL Server Management Studio is truly an Integrated Development Environment. There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels. The graphical designers are a set of utilities... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, ssms
8
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 1: Introduction to SSIS - Sudeep Raj
published 468 days, 17 hours, 4 minutes ago posted by dharadhara 471 days, 19 hours, 9 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:11:25 PM GMT
SSIS is a tool used for ETL. Before we talk on SSIS, let me walk you through what is ETL. ETL stands for Extract Transform and Load. These are simple day-to-day words we use in our daily lives. The figure below depicts ETL in real world scenario. (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
6
Shouts
spam Shout it Mute it

Generate test data using DBGen
published 468 days, 17 hours, 4 minutes ago posted by dharadhara 473 days, 20 hours, 2 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Saturday, February 04, 2012 7:17:37 PM GMT
Over the last couple of months I have on several occasions found myself in need of test data for demos, blogposts etc. You all know AdventureWorks, which will work for a lot of demoing stuff. But the amount of data is limited, and if you are demoing stuff... (more)
category: Data | clicked: 33 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Error encountered in SQL Server - Alter failed for Login sa. Cannot set a credential for principal 'sa'.
published 471 days, 20 hours, 58 minutes ago posted by dharadhara 473 days, 20 hours, 3 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Saturday, February 04, 2012 7:17:15 PM GMT
Recently when i worked with SQL Server security, i encountered with one error while trying to modify 'SA' account properties. The exception details looks following, Alter failed for Login sa. Cannot set a credential for principal 'sa'... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
Previous 1 2 3 4 5 6 7 8 9 10 ... 42 43 Next