DotNetShoutout

patelkhyati82

Name:	patelkhyati82
Score:	3,110.25
Last Seen:	354 days, 22 hours, 45 minutes ago
Member Since:	22 April, 2010

9
Shouts

Shout it

SQL SERVER – Quiz and Video – Introduction to SQL Server Security « SQL Server Journey with SQL Authority

published 379 days, 13 hours, 1 minute ago posted by

pinaldave 383 days, 7 hours, 13 minutes ago

This blog post is inspired from Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners – SQL Exam Prep Series 70-433 – Volume 1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to SQL Server Security – A Primer. In the article we discussed various basics terminology of the security. The article further covers following important concepts of security.Granting PermissionsDenying PermissionsRevokin... (more)

category: Data | clicked: 42 | comment | | source: blog.sqlauthority.com

4
Shouts

Shout it

SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL

published 393 days, 12 hours, 14 minutes ago posted by

dhara 401 days, 16 hours, 32 minutes ago

Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is (more)

category: Data | clicked: 50 | comment | | source: beyondrelational.com

tags:

7
Shouts

Shout it

SQL SERVER – Cheatsheet – Released for SQL Server 2012 Edition « SQL Server Journey with SQL Authority

published 396 days, 10 hours, 51 minutes ago posted by

pinaldave 403 days, 7 hours, 5 minutes ago

SQL Server Cheatsheet has been extremely popular download from my blog. There are plenty of request for me to update it with SQL Server 2012 features. I have finally upgraded the cheatsheet with SQL Server 2012 features. The new cheatsheet has following updatesSSMS ShortcutsColumnstore IndexSQL Server 2012 Datetime FunctionsSQL Server Ranking FunctionsSQL Server 2012 Analytic functionsIt has been excellent experience to upgrade the cheatsheet. However, as the new cheatsheet contains way more information ... (more)

category: Data | clicked: 52 | comment | | source: blog.sqlauthority.com

12
Shouts

Shout it

SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video « SQL Server Journey with SQL Authority

published 404 days, 3 hours, 52 minutes ago posted by

pinaldave 409 days, 8 hours, 24 minutes ago

SQL Server has so many enhancements and features that quite often I feel like playing with various features and try out new things. I often come across situation where I want to try something new but I do not have sample data to experiment with. Also just like any sane developer I do not try any of my new experiments on production server. Additionally, when it is about new version of the SQL Server, there are cases when there is no relevant sample data even available on development server. In this kind o... (more)

category: Data | clicked: 59 | comment | | source: blog.sqlauthority.com

6
Shouts

Shout it

Using BackgroundWorker with WPF

published 404 days, 3 hours, 52 minutes ago posted by

kinj312 410 days, 16 hours, 22 minutes ago

When one process take so much long time and UI thread needs to stay responsive while process is running, the most common method to place a long running process on a separate thread.In WPF there are mostly use technique is Backgroundworker. (more)

category: Web Dev | clicked: 63 | comment | | source: beyondrelational.com

tags:

5
Shouts

Shout it

Getting Started with Windows Phone 7 programming - Getting Started with Windows Phone 7 - Part 1 - Overview and System Requirements for Windows Phone 7

published 432 days, 16 hours, 29 minutes ago posted by

dhara 438 days, 6 hours, 18 minutes ago

In this series of articles, we are going to see how to develop a Windows Phone 7 application from the scratch and deploy it into the market place. This article is the first part of the series. Here we are going to see what Windows Phone 7 (more)

category: Data | clicked: 96 | comment | | source: beyondrelational.com

tags: SQL Server, Windows Phone 7

7
Shouts

Shout it

Getting Started with Windows Phone 7 programming - Getting Started with Windows Phone 7 - Part 2 - Creating a Hello World Silverlight Application in Windows Phone 7

published 426 days, 21 hours, 54 minutes ago posted by

kinj312 436 days, 5 hours, 49 minutes ago

In this article, we are going to see how to create a simple 'Hello World' Silverlight Windows Phone 7 Application with the development environment, which we discussed in the first part of this series. Developing Windows Application for the developers who have exposure to Visual Studio IDE is pretty simple (more)

category: Data | clicked: 194 | 4 comments | | source: beyondrelational.com

tags: SQL Server, Windows Phone 7

6
Shouts

Shout it

ASP.NET - Decoding viewstate is very simple by using LosFormatter class

published 438 days, 17 hours, 5 minutes ago posted by

dhara 446 days, 10 hours, 5 minutes ago

Though I know viewstate is vulnerable to security as it reveals sensitive information, I always thought that its reasonably difficult to decode. But i found that decoding viewstate is very much simpler. ASP.NET has a class "LosFormatter", by using which we can decode viewstate (more)

category: Web Dev | clicked: 105 | comment | | source: beyondrelational.com

tags: .NET, ASP .NET

5
Shouts

Shout it

Get random row from the table

published 443 days, 3 hours, 1 minute ago posted by

dhara 446 days, 10 hours, 8 minutes ago

Sometimes it happens that we need random row (or set of randoms rows) from table. Itzik Ben-Gan shows us, in one of his book, the efficient way to do this: (more)

category: Data | clicked: 29 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Exploring SSMS - Inserting Code snippets for Objects

published 438 days, 17 hours, 5 minutes ago posted by

dhara 446 days, 10 hours, 8 minutes ago

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to insert code template for creating... (more)

category: Data | clicked: 65 | 2 comments | | source: beyondrelational.com

tags: SQL Server, ssms

4
Shouts

Shout it

CREATE SCHEMA statement must be the only statement in the batch

published 443 days, 3 hours, 1 minute ago posted by

dhara 448 days, 16 hours, 14 minutes ago

Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help my friends in the same boat :) I am creating this tip. (more)

category: Data | clicked: 110 | comment | | source: beyondrelational.com

tags: SQL Server

4
Shouts

Shout it

Change location of database file + correct logical file name of the database file

published 443 days, 3 hours, 1 minute ago posted by

dhara 448 days, 16 hours, 16 minutes ago

I was verifying a server setup and found that the tempdb files were residing in the root location created during initial sql server installation. As a part of good practices I always separate out the tempdb files to a separate drive. To achieve this I had to use to the below sql. (more)

category: Data | clicked: 101 | comment | | source: beyondrelational.com

tags: SQL Server

5
Shouts

Shout it

Exploring SSMS - Hiding System databases

published 443 days, 3 hours, 1 minute ago posted by

dhara 448 days, 16 hours, 18 minutes ago

category: Data | clicked: 57 | comment | | source: beyondrelational.com

tags: SQL Server

7
Shouts

Shout it

SQL Server - Split Database Full Backup to Multiple files

published 443 days, 3 hours, 1 minute ago posted by

dhara 450 days, 5 hours, 47 minutes ago

As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size of the databases it is require more time and IO to maintain it. You can read my earlier posts Automated All Databases Backups Script and Full Backup database from SSMS. (more)

category: Data | clicked: 73 | comment | | source: beyondrelational.com

tags: SQL Server

7
Shouts

Shout it

#0138 - SQL Server – Performance – Best Practice – Create Index Before or After a data insert – I/O, Fragmentation, CPU and Elapsed time comparison - Test results

published 443 days, 3 hours, 1 minute ago posted by

dhara 450 days, 5 hours, 48 minutes ago

In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert? . The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-insert... (more)

category: Data | clicked: 111 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Getting started with SSIS - Part 9: Debugging SSIS packages

published 443 days, 3 hours, 1 minute ago posted by

dhara 450 days, 5 hours, 48 minutes ago

Our package is ready we have made it dynamic (partly) and we are ready to go. What if there are any errors in the package execution? How to troubleshoot or debug the SSIS Package? (more)

category: Data | clicked: 40 | comment | | source: beyondrelational.com

tags: SQL Server, SSIS

4
Shouts

Shout it

Trick to Supress Division by zero error

published 443 days, 3 hours, 1 minute ago posted by

dhara 451 days, 5 hours, 31 minutes ago

Set ARITHABOBRT and ANSI_WARNINGS as OFF to handle division by Zero error (more)

category: Data | clicked: 39 | comment | | source: beyondrelational.com

tags: SQL Server

6
Shouts

Shout it

Review: OfficeWriter v8

published 443 days, 13 hours, 43 minutes ago posted by

dhara 451 days, 5 hours, 32 minutes ago

As a BI consultant specializing in SSRS, I have had lots of frustrations and hard times because of Excel. Every now and then, I have some or other business user coming up to me and asking for some feature which is there in Excel but not in SSRS. If you... (more)

category: Data | clicked: 20 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, BI

5
Shouts

Shout it

#0137 - SQL Server – Review - Pluralsight course - SQL Server Questions & Answers - by Pinal Dave & Vinod Kumar

published 443 days, 13 hours, 43 minutes ago posted by

dhara 451 days, 5 hours, 32 minutes ago

I recently had the opportunity to view some of the newest courses from Pluralsight , an organization that offers online training courses for developers. One of the courses that I viewed was the SQL Server Questions & Answers ( http://www.pluralsight... (more)

category: Data | clicked: 57 | comment | | source: beyondrelational.com

tags: SQL Server

6
Shouts

Shout it

WCF # 13 – WCF Behaviors and it's types [How WCF runtime is initialized?]

published 443 days, 13 hours, 43 minutes ago posted by

dhara 453 days, 5 hours, 44 minutes ago

Hi Geeks, In general Behavior or behaviour refers to the actions and mannerisms made by System in conjunction with its environment, which includes the other systems around . It is the response of the system to various stimuli or inputs. * WCF Behaviors... (more)

category: Web Dev | clicked: 156 | comment | | source: beyondrelational.com

tags: .NET, WCF, ASP.NET

Welcome!

patelkhyati82

SQL SERVER – Quiz and Video – Introduction to SQL Server Security « SQL Server Journey with SQL Authority

SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL

SQL SERVER – Cheatsheet – Released for SQL Server 2012 Edition « SQL Server Journey with SQL Authority

SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video « SQL Server Journey with SQL Authority

Using BackgroundWorker with WPF

Getting Started with Windows Phone 7 programming - Getting Started with Windows Phone 7 - Part 1 - Overview and System Requirements for Windows Phone 7

Getting Started with Windows Phone 7 programming - Getting Started with Windows Phone 7 - Part 2 - Creating a Hello World Silverlight Application in Windows Phone 7

ASP.NET - Decoding viewstate is very simple by using LosFormatter class

Get random row from the table

Exploring SSMS - Inserting Code snippets for Objects

CREATE SCHEMA statement must be the only statement in the batch

Change location of database file + correct logical file name of the database file

Exploring SSMS - Hiding System databases

SQL Server - Split Database Full Backup to Multiple files

#0138 - SQL Server – Performance – Best Practice – Create Index Before or After a data insert – I/O, Fragmentation, CPU and Elapsed time comparison - Test results

Getting started with SSIS - Part 9: Debugging SSIS packages

Trick to Supress Division by zero error

Review: OfficeWriter v8

#0137 - SQL Server – Review - Pluralsight course - SQL Server Questions & Answers - by Pinal Dave & Vinod Kumar

WCF # 13 – WCF Behaviors and it's types [How WCF runtime is initialized?]

Open ID Login

Standard Login

Forgot Password?

Sign up