patelkhyati82

patelkhyati82
Name: patelkhyati82
Score: 3,110.25
Last Seen: 351 days, 8 hours, 57 minutes ago
Member Since: 22 April, 2010
DotNetShoutout
atom rss
5
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 3: First SSIS Package - Sudeep Raj
published 465 days, 17 hours, 40 minutes ago posted by kinj312kinj312 467 days, 16 hours, 3 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Thursday, February 09, 2012 6:26:43 PM GMT
Hope that you have a basic understanding of ETL, SSIS and BIDS. So without much delay, let us start getting our package to move data from a flat file to a database table. The table does not exist and needs to be created while development. (more)
category: Data | clicked: 44 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
6
Shouts
spam Shout it Mute it

Add SSRS 2008 named instance tutorial
published 465 days, 17 hours, 40 minutes ago posted by kinj312kinj312 468 days, 15 hours, 3 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:26:50 PM GMT
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installation... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, SSRS
5
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit BOM
published 465 days, 17 hours, 40 minutes ago posted by kinj312kinj312 468 days, 15 hours, 3 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:27:15 PM GMT
The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki. The wiki, which is based on the SQL Server 2012... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL, sql server 2012
7
Shouts
spam Shout it Mute it

Data Profiling Task to Validate data before load to EDW
published 466 days, 17 hours, 30 minutes ago posted by kinj312kinj312 469 days, 17 hours, 1 minute ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:29:03 PM GMT
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server
7
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 2: BIDS Overview - Sudeep Raj
published 467 days, 12 hours, 14 minutes ago posted by kinj312kinj312 469 days, 17 hours, 2 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Tuesday, February 07, 2012 5:28:05 PM GMT
What is BIDS? Why do I need it? Where can I find it? 3 questions are asked here. Therefore, I will provide the 3 answers to you. (more)
category: Data | clicked: 23 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
5
Shouts
spam Shout it Mute it

Set the Slice on your SSAS Cube Partitions now!
published 466 days, 17 hours, 30 minutes ago posted by kinj312kinj312 469 days, 17 hours, 1 minute ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:28:32 PM GMT
I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
7
Shouts
spam Shout it Mute it

Identity column with decimal datatype
published 467 days, 12 hours, 14 minutes ago posted by dharadhara 470 days, 14 hours, 18 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 467 days, 12 hours, 14 minutes ago posted by dharadhara 470 days, 14 hours, 18 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 467 days, 12 hours, 14 minutes ago posted by dharadhara 470 days, 14 hours, 18 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 467 days, 12 hours, 14 minutes ago posted by dharadhara 472 days, 15 hours, 12 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 470 days, 16 hours, 7 minutes ago posted by dharadhara 472 days, 15 hours, 13 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
7
Shouts
spam Shout it Mute it

Email-New Html5 input element
published 467 days, 12 hours, 14 minutes ago posted by dharadhara 472 days, 15 hours, 13 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Saturday, February 04, 2012 7:16:54 PM GMT
In most of the websites we have contact forms and other forms where we have some standard inputs like Phone,Email and Website URL and those are widely used in any site and has specific features. Email is one of the most standard used input elements which... (more)
category: Web Dev | clicked: 53 | 1 comment | | source: beyondrelational.com
tags: .NET, ASP.NET
7
Shouts
spam Shout it Mute it

Getting Started with SQL Azure - Getting started with SQL Azure - Part 9: Developing SQL Azure applications - Paras Doshi
published 474 days, 17 hours, 23 minutes ago posted by dharadhara 475 days, 15 hours, 17 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Wednesday, February 01, 2012 7:12:53 PM GMT
Now, in this module, we are going to discuss about developing SQL Azure applications. If you come from a SQL Server world, then there are only few differences in developing SQL Azure applications that you need to know. In this module, we would discuss them primarily from a Database Developer perspective. Let us discuss them one by one: (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Azure, Azure
7
Shouts
spam Shout it Mute it

Working with Application Role - SQL Server
published 474 days, 17 hours, 23 minutes ago posted by dharadhara 475 days, 15 hours, 18 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Wednesday, February 01, 2012 7:12:21 PM GMT
In last post we have seen custom database roles as how can we create it and assign required access to users. We also noticed that we can add multiple members with same role. That was the security with database roles and members comes into the picture... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

#0127 - SQL Server – SSMS – Tutorial – Part 02 – Introduction to the Object Explorer and Object Explorer Details window (L100)
published 474 days, 17 hours, 23 minutes ago posted by dharadhara 475 days, 15 hours, 18 minutes ago
Thursday, February 02, 2012 5:06:51 PM GMT Wednesday, February 01, 2012 7:12:02 PM GMT
As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio... (more)
category: Data | clicked: 2 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Stored Procedure to Get Expensive Queries
published 470 days, 16 hours, 7 minutes ago posted by dharadhara 473 days, 15 hours, 16 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:13:41 PM GMT
As a DBA we often need to get information on various Queries, One of them is how expensive it is. A query can be judged as expensive on various criteria’s like Long Running, Memory Utilization, CPU utilization etc. I came up with this Stored Procedure... (more)
category: Data | clicked: 21 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Using TraceEvent for MDX Debugging
published 470 days, 16 hours, 7 minutes ago posted by dharadhara 473 days, 15 hours, 17 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:12:43 PM GMT
Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today. I was doing my weekly reading and going through a brilliant post by Microsoft MVP - Greg... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Stored Procedure to Purge MSDB Job History
published 470 days, 16 hours, 7 minutes ago posted by dharadhara 473 days, 15 hours, 17 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Friday, February 03, 2012 7:13:21 PM GMT
Purging your MSDB Job History is sometime very important which helps you read the Jos history in GUI very easily and keeps which only required number of days. You can add this in your Maintenance Plan or using a SSIS Package. I found one of the way a... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

#0128 - SQL Server – SSMS – Tutorial – Part 03 – The T-SQL Debugger (L200)
published 470 days, 16 hours, 7 minutes ago posted by dharadhara 474 days, 15 hours, 14 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Thursday, February 02, 2012 7:16:21 PM GMT
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. Starting Microsoft SQL Server 2005, the... (more)
category: Data | clicked: 28 | comment | | source: beyondrelational.com
tags: SQL Server, ssms
6
Shouts
spam Shout it Mute it

#0129 - SQL Server – SSMS – Tutorial – Part 04 – Introduction to Database Diagramming (L100)
published 470 days, 16 hours, 7 minutes ago posted by dharadhara 474 days, 15 hours, 13 minutes ago
Monday, February 06, 2012 6:22:29 PM GMT Thursday, February 02, 2012 7:17:11 PM GMT
For those who have worked in Enterprise environments, documentation is of utmost importance. Documentation can be in the form of a text-based document, or a graphical document (in the form of a diagram). A data dictionary is a centralized repository of... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL, BI
Previous 1 2 3 4 5 6 7 8 9 10 ... 52 53 Next