Reality - Stored Procedure and Transactions(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 11 months ago

Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“. read more...

add a comment |category: Database |Views: 450

tags: SQLAuthority pinaldave SQLServer Database SQL another

SELECT * FROM XML(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 11 months ago

This post shows how to run a SELECT * kind of query on an XML document to see the elements, attributes, values and the XPath Expression of each element and attribute in the document. read more...

add a comment |category: Database |Views: 342

tags: Database another

SELECT * FROM XML(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 11 months ago

This post shows how to run a SELECT * kind of query on an XML document to see the elements, attributes, values and the XPath Expression of each element and attribute in the document. read more...

add a comment |category: Database |Views: 342

tags: Database another

RavenDB vs CouchDB - Basic Queries(codeofrob.com)

submitted by robashton(384) 1 year, 11 months ago

RavenDB and CouchDB are compared for their basic querying behaviour read more...

2 comments |category: Database |Views: 729

tags: Database another

Database Deadlock Mystery Resolved - Snapshot Isolation (blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Simple Solution to Resolve Database Deallocking and Blocking Issues read more...

add a comment |category: Database |Views: 370

tags: SQLAuthority pinaldave SQLServer Database SQL another

How to Use the Validation Application Block, Part 1(www.aaronstannard.com)

submitted by Aaronontheweb(1140) 2 years ago

Introduces the Microsoft Enterprise Library Validation Application Block and some of the basic validators, such as regular expression, string length, range, and so forth. read more...

add a comment |category: C# |Views: 13

tags: C# another

Tips and Tricks to prevent SQL Injection in .Net Code(beyondrelational.com)

submitted by DPalkar(228) 2 years ago

There are many detailed articles available on web on SQL Injection topic and hence I’ll just try to keep it short and simple in this post. SQL Injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. This can allow an attacker to steal the data as well as modify and delete it. Conventional security measures like use of SSL and IPSec, do not protect the application from SQL injection attacks. read more...

1 comment |category: ADO.NET |Views: 430

tags: .Net Tricks Prevent Database ADO.NET another

AddThis.NET v2 for Blogengine.NET released(www.code-in.net)

submitted by baldi(508) 2 years ago

AddThis.NET is a Blogengine.NET extensions which adds social bookmarking buttons to your posts based on AddThis. A seperate DotnetKicks and DotnetShoutout button will be displayed, which can also be removed if you are no .net developer. read more...

add a comment |category: Other |Views: 148

tags: another

SQL SERVER – Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. read more...

add a comment |category: Database |Views: 484

tags: SQLAuthority pinaldave SQLServer Database SQL another

Dropbox API and RestSharp for a C# developer(dkdevelopment.net)

submitted by johnsheehan(4785) 2 years ago

How to use the DropBox API with RestSharp read more...

add a comment |category: C# |Views: 747

tags: C# another

Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Mystery Resolved - One Query to Find Most Expensive Database Query - DMV read more...

add a comment |category: Database |Views: 12

tags: SQLAuthority pinaldave SQLServer Database SQL another

Derived Table - New approach to avoid SQL Injection(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years ago

This post demonstrates a new approach to avoid SQL injection by using derived tables. read more...

1 comment |category: Database |Views: 370

tags: Database another

Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Story of Disabled Index read more...

add a comment |category: Database |Views: 8

tags: SQLAuthority pinaldave SQLServer Database SQL another

Simplify, Shorten and Speed Up Your LINQ Statements with "Let"(blog.nitriq.com)

submitted by viggity(1124) 2 years ago

Details how using the "let" keyword can make your LINQ statements shorter and faster. read more...

add a comment |category: Tips & Tricks |Views: 675

tags: LINQ Tips another

Download Microsoft SQL Azure Frequently Asked Questions (FAQ)(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years ago

If you are struggling with a SQL Azure problem, one of the first resource to refer is the Microsoft SQL Azure FAQ document which presents a number of commonly asked SQL Azure questions along with a very detailed answer to each of them. read more...

add a comment |category: Database |Views: 135

tags: SQLInjection SQLServer Database SQL another

amCharts Quick Charts for WPF & Silverlight - Open Source Charts(wpf.amcharts.com)

submitted by ailon(1335) 2 years ago

amCharts has released a feature complete version of Quick Charts for WPF & Silverlight. Quick Charts support line, column, area and pie charts. It's easy to use, fast, small and absolutely free under Ms-PL license. read more...

add a comment |category: Silverlight |Views: 295

tags: Silverlight WPF OpenSource another