DotNetShoutout

Madhivanan

Name:	Madhivanan
Score:	2,606.18
Last Seen:	352 days, 14 hours, 4 minutes ago
Member Since:	31 May, 2010

9
Shouts

Shout it

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

published 377 days, 3 hours, 42 minutes ago posted by

pinaldave 380 days, 21 hours, 54 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 391 days, 2 hours, 55 minutes ago posted by

dhara 399 days, 7 hours, 13 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 394 days, 1 hour, 31 minutes ago posted by

pinaldave 400 days, 21 hours, 46 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 401 days, 18 hours, 32 minutes ago posted by

pinaldave 406 days, 23 hours, 5 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 401 days, 18 hours, 32 minutes ago posted by

kinj312 408 days, 7 hours, 3 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:

6
Shouts

Shout it

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

published 436 days, 7 hours, 46 minutes ago posted by

dhara 444 days, 46 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 440 days, 17 hours, 42 minutes ago posted by

dhara 444 days, 48 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: 28 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Exploring SSMS - Inserting Code snippets for Objects

published 436 days, 7 hours, 46 minutes ago posted by

dhara 444 days, 49 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 440 days, 17 hours, 42 minutes ago posted by

dhara 446 days, 6 hours, 55 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

5
Shouts

Shout it

Exploring SSMS - Hiding System databases

published 440 days, 17 hours, 42 minutes ago posted by

dhara 446 days, 6 hours, 59 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 440 days, 17 hours, 42 minutes ago posted by

dhara 447 days, 20 hours, 28 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 440 days, 17 hours, 42 minutes ago posted by

dhara 447 days, 20 hours, 28 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 440 days, 17 hours, 42 minutes ago posted by

dhara 447 days, 20 hours, 29 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

5
Shouts

Shout it

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

published 441 days, 4 hours, 24 minutes ago posted by

dhara 448 days, 20 hours, 13 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

7
Shouts

Shout it

You can drop multiple tables using single DROP statement

published 441 days, 4 hours, 24 minutes ago posted by

dhara 449 days, 21 hours, 17 minutes ago

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement (more)

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

tags: SQL Server, TSQL

7
Shouts

Shout it

Read contents of a file to variable – SSIS

published 440 days, 17 hours, 42 minutes ago posted by

dhara 449 days, 21 hours, 17 minutes ago

Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script Task to read contents of a flat file into a variable. (more)

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

tags: SQL Server, TSQL, SSIS, BI

7
Shouts

Shout it

SSIS Tutorial - Getting started with SSIS - Part 8: Creating parameterized SSIS packages - Sudeep Raj

published 441 days, 11 hours, 24 minutes ago posted by

dhara 449 days, 21 hours, 18 minutes ago

Now that we have learnt how to create a simple SSIS Package, let us see how we can make it adaptive. What I mean by adaptive is, how we can maintain the package with minimal changes in the future. Before we talk about how we handle this, let us talk about the scenarios where we might want to change the package. (more)

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

tags: SQL Server, SSIS, BI

4
Shouts

Shout it

Fun with Square braces

published 441 days, 4 hours, 24 minutes ago posted by

dhara 450 days, 20 hours, 25 minutes ago

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

5
Shouts

Shout it

TSQL Challenge 76 - Identify the sequence of accounting transactions

published 441 days, 11 hours, 24 minutes ago posted by

dhara 450 days, 20 hours, 24 minutes ago

The challenge is to identify the sequence of accounting transactions. The table has data which is ordered. You need to follow the order of the data, and detect a certain condition which lasts for a sequence of data rows, you need to give these data points an ID which uniquely identifies the sequence. T (more)

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

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

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

published 441 days, 4 hours, 24 minutes ago posted by

dhara 450 days, 20 hours, 25 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!

Madhivanan

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

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

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

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

You can drop multiple tables using single DROP statement

Read contents of a file to variable – SSIS

SSIS Tutorial - Getting started with SSIS - Part 8: Creating parameterized SSIS packages - Sudeep Raj

Fun with Square braces

TSQL Challenge 76 - Identify the sequence of accounting transactions

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

Open ID Login

Standard Login

Forgot Password?

Sign up