Query to Recent Query on Server with Execution Plan Function(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 1 month ago

A quick script to get recently ran query. read more...

add a comment |category: Database |Views: 210

tags: SQLAuthority SQLServer SQL Database pinaldave another

Afterthought: a post-compilation code injection framework(blogs.app.vc3.com)

submitted by kr4ster(34) 1 year, 1 month ago

Afterthought allows developers to post-process .NET assemblies to add code that either cannot be added to the original source or is not convenient/efficient to do so. Examples include: Tweaking a compiled assembly for which you do not have the source code be must support/modify Adding instrumentation logic to an assembly for test purposes, which will not always be part of the release version So, what does Afterthought do? Quite simply, it allows you to: Create type amendments by subclassing Amendment<,> to describe what changes you want to make Add attributes to your types indicating which types to amend and what amendments to apply Amend properties by either adding new properties or modifying the logic of existing properties Amend methods by either adding new methods or modifying the logic of existing methods Amend constructors by either adding new constructors or modifying the logic of existing constructors Implement interfaces directly on a type leveraging existing properties/methods, adding new properties/methods, and allowing Afterthought to automatically implement everything else Configure your project to call Afterthought as a post-build step to apply the changes read more...

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

tags: C# another

Trigger and number of rows affected(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 1 month ago

One of my frieds told me that INSERT trigger will not fire if no data are added to the main table. It is a mistake that some people think that triggers will not fire if no row is affected. Note that trigger is event based and not data based. Here is a proof that trigger fires eventhough no row is affected... read more...

add a comment |category: Database |Views: 28

tags: Database another

The Limitations of the Views – Eleven and more…(blog.sqlauthority.com)

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

I am confident that you may know few and you may know many. I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject read more...

add a comment |category: Database |Views: 191

tags: SQLAuthority pinaldave SQLServer Database SQL another

Selenium Testing with FlexPilot(mariangemarcano.blogspot.com)

submitted by mariangemarcano(135) 1 year, 7 months ago

I continued my quest for a solution to create automated tests using seleniumRC and C# and this time I took a look at this new project called Flex Pilot. FlexPilot is a open source testing tool that integrates with selenium, it has a bootstrapper to make the application testable, it is able to use a selenium IDE recorder, and you can access elements using chain syntax (like accessing with xpath). Here is what I did to start building tests with flex pilot ... read more...

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

tags: C# another

Query Optimization - Interesting Observation of Compute Scalar before (dotnetkicks.com)

submitted by pinaldave(9662) 2 years, 3 months ago

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate February 5, 2010 by pinaldave | Edit I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by the query. Click more for further story. read more...

add a comment |category: Database |Views: 277

tags: SQLAuthority pinaldave SQLServer Database SQL another

Table Per Type Inheritance in Entity Framework(blogs.microsoft.co.il)

submitted by gilf(2139) 2 years, 4 months ago

The first inheritance mapping I’m going to show is called Table Per Type or TPT. Before I start with the example lets define what is TPT. read more...

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

tags: ADO.NET Database another

Azure Start Guide – Step by Step Installation Guide(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 5 months ago

One of the kind article about how to start right away with Azure read more...

3 comments |category: Database |Views: 441

tags: SQLAuthority Azure pinaldave Database SQL another

Error in ADO.NET Entities Framework 3.5 , please help!(team.sfi.vn)

submitted by lehoangdung(490) 2 years, 6 months ago

Error in ADO.NET Entities Framework 3.5, read more...

2 comments |category: ADO.NET |Views: 155

tags: ADO.NET Database another

Reading Code is Key to Writing Good Code(stevenharman.net)

submitted by ussherm(5285) 2 years, 6 months ago

Software product development is a creative activity taking place in the midst of that complex and adaptive world. So let's take a page from other creative professions (musicians, artists, etc.) and study the work of others, both within and outside our field, to help improve our own work. read more...

1 comment |category: Other |Views: 541

tags: another

Insert Data From One Table to Another Table(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 6 months ago

Following three questions are many time asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to anther table? How can I stop using cursor to move data from one table to another table? There are two different ways to implement inserting data from one table to another table. read more...

add a comment |category: Database |Views: 468

tags: SQLAuthority pinaldave Database SQLServer another

Sort the Items of an ASP.NET DropDownList using jQuery(dotnetcurry.com)

submitted by samsert(2159) 2 years, 6 months ago

Short and useful article that demonstrates how to sort the items of an ASP.NET DropDownList using jQuery. read more...

add a comment |category: ASP.NET |Views: 240

tags: ASP.NET another

SQL SERVER – An Interesting Observation Related to Datatypes(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 6 months ago

Recently, I have been working on Query Optimization project. While working on it, I found the following interesting observation. This entire concept may appear very simple, but if you are working in the area of query optimization and server tuning, you will find such useful hints. read more...

add a comment |category: Database |Views: 397

tags: SQLAuthority pinaldave SQLServer Database SQL another

Don Box - Perspectives on SOAP, Programming Data and M(blogs.msdn.com)

submitted by bobfamiliar(3648) 2 years, 6 months ago

Erik Meijer, programming language and library designer, chats with Don Box about the history of SOAP, model-based programming, data and M. read more...

add a comment |category: Architecture |Views: 117

tags: Architecture another

Difference Between Candidate Keys and Primary Key(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 7 months ago

Not long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys. Let us first try to grasp the definition of the two keys. read more...

add a comment |category: Database |Views: 248

tags: SQLAuthority pinaldave SQLServer Database SQL another

Authenticate a user against the Active Directory(c-sharpcorner.com)

submitted by saumya321(775) 2 years, 7 months ago

This article serves as a guide to using System.DirectoryServices (SDS) ADSI to access user and group in the Windows Active Directory. Authenticate a user against the Active Directory using the user ID and password. read more...

1 comment |category: Other |Views: 397

tags: another