Need your input for TechEd EMEA sessions on troubleshooting .net applications
TechEd EMEA Developers is just around 2 weeks away now and the pre-conference nervousness is starting to get to me:) This will be my first time at TechEd (even as an attendee) so I am really excited. I was just chatting a little with one of the track-owners to figure out what the venue ......
Novermber's Toolbox Column Now Online
My Toolbox column in the November 2008 issue of MSDN Magazine is avaiable online. The November issue examines:
DayPilot - DayPilot is an AJAX-enabled calendar and scheduling ASP.NET Web control that offers functionality not unlike what you find in Outlook and other desktop-based calendar applica......
Script# Programming in the Large
Some large-scale Ajax apps and frameworks - the Live Framework and Office 14, both announced at PDC - built using Script#... Read More......(read more)...
SDS and Ruby
A couple of months ago my good buddy Ryan Dunn contacted me about writing some Ruby samples for the new SQL Data Services that is part of the recently announced Windows Azure. (at the time it was called SSDS). I completed the samples about a month or so ago but we had to wait to announce them until......
SQLAuthority News - Download SQL Server 2005 Service Pack 3 - CTP
The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:EnterpriseEnterprise EvaluationDeveloperStandardWorkgroupFor a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New d......
ASP.NET 4.0 Roadmap talk available online
Scott Hunter’s talk on the ASP.NET 4.0 roadmap (in which I’m doing a 10 minute demo) is available from Channel9: http://channel9.msdn.com/pdc2008/PC20/...
Hot New Presentation Tip
Before giving a presentation, I review Scott Hanselman’s top 11 presentation tips . Well I have a twelfth tip that Scott needs to add to his list, and he’ll vouch for this. A couple of hours before Jeff and I gave the ASP.NET MVC presentation, we played some RockBand in the Big Room (exhibition are......
Lack of practice makes imperfect
Apparently it's been too long since I've played with SQL Server databases. I say this because I made a boneheaded mistake today that obliged me to spend some quality time in the debugger. Someone asked me whether I could convert the good ol' cascading drop-down example from using an Access database......
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set with all the pieces available to make your working life easier....Did you know......
Silverlight Toolkit Overview and Samples
Controls are where it’s at these days in the programming world. By using them you maximize re-use, enhance productivity and avoid building custom functionality. Plus, when you need a control to do something different you can always extend it rather than writing everything from scratch. ......
Visual Studio's Property Window Not Refreshing in the Designer
Rick Strahl recently posted about some his frustrations with the Visual Studio 2008 Designer - HTML Mangling with Literal Controls in the <head>. While I've not had Visual Studio mangle my pages' markup when switching between the Design and Source views like Rich has, I have had one especiall......
Early Notes from the PDC 2008 KeyNote
Here are some random and early notes from the first half of the PDCs keynote this morning, mostly about Azure. Windows Azure Cloud service operating system Part of the new cloud computing services platform (Azure Services Platform) New blog for Cloud Computing ......
Telerik is Live from PDC
PDC is in full force at the LA Convention Center. The keynote was somewhat bland, but the big news of the day is Windows Azure. Microsoft's cloud services offering, Azure promises to allow developers to host and manage their applications in the cloud, scaling storage and computing resources on dema......
The Oslo Developer Center: Letter from the Editors
Welcome to the "Oslo" Developer Center, your one-stop shop for all things "Oslo." Do you need to learn how M works (or what the heck it is?)? Do you want to sprinkle some of that repository stuff into your SQL Server? Do you need a quick video tutorial on the "Oslo" SDK tools? Then you've come to t......
Constraint Yourself!
In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an intrinsic part of SQL and are a great way of ensuring that a business rule is done one way, one place, one time....Did you know that DotNetSlackers also publishes .net articles writt......
SQL SERVER - Simulate INNER JOIN using LEFT JOIN statement - Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any other JOINs will degrad......
Reasons to Deprecate
Tony is happy to see features and services of SQL Server deprecated by Microsoft if it is for a good reason. Good reasons include conformance with SQL Standards or rejection by the community of users; He doesn't consider Microsoft's commercial convenience to be a good reason....Did you know that Do......
Adding Style to Silverlight 2 Controls
Silverlight 2 provides a nice set of controls that can be used to capture and display data. While control properties can be set directly on the control in a XAML file using attributes, some properties will be duplicated between controls causing maintenance headaches. The following example demonstra......
October 22nd Links: ASP.NET, Visual Studio, WPF and Silverlight
Here is the latest in my link-listing series . Also check out my ASP.NET Tips, Tricks and Tutorials page and Silverlight Tutorials page for links to popular articles I've done myself in the past. ASP.NET Building a Great ASP.NET AJAX Application from Scratch : Brad Abrams has a nice end t......
Examining ASP.NET's Membership, Roles, and Profile - Part 13
ASP.NET's forms-based authentication system in tandem with the Membership API and Login Web controls make it a cinch to create a user store, create
user accounts, and allow visitors to log into the site. What's more, with little effort it's possible to define roles, associate user accounts wit......
Going to California
I’m flying to San Jose tonight for tomorrow’s OpenAjax Alliance face to face meeting, which Microsoft is hosting. On Friday, we are also hosting a new event that aims at establishing a dialogue between JavaScript library developers and Microsoft. We’ll have talks from the IE, Visual Studio and ASP.......
SQLAuthority News - Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundament......
The Weekly Source Code 35 - Zip Compressing ASP.NET Session and Cache State
Recently while talking to Jeff Atwood and his development team about StackOverflow he mentioned that he compresses the Cache or Session data in ASP.NET which enables him to store about 5-10x more data. They do it with some helper methods but I thought it'd be interesting to try it myself. There......
Troubleshooting ASP.NET issues with HTTPERR logs
I am doing some email cleanup and got a request to write a post about how to use the HTTPERR logs. I thought long and hard about what I could write that would add value. There is a really good KB article on the topic http://support.microsoft.com/default.aspx?scid=kb;en-us;820729 that goes thr......
.NET Debugging at TechED EMEA (10-14 November in Barcelona)
I hope you will join me for TechEd in Barcelona on the 10th-14th of November. I will be presenting 2 sessions, one breakout and one interactive session: WUX405 Common ASP.NET production issues and how to troubleshoot them with windbg “ This session presents the most common causes for hangs, perform......
Essential Visual Studio Tips & Tricks that Every Developer Should Know
In this blog entry, I list the essential tips and tricks that every developer who uses Visual Studio 2008 should know. I wanted to keep this list brief. I also wanted to focus on only those tips and tricks that I use on a daily basis. Almost all of these tips and tricks are just as useful regardles......
SQL SERVER - Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developer confused many times when they receive following error message.Msg 325, Level 15, State 1, Line 7Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptleve......
AjaxWorld Talk: Building a Great Ajax application from Scratch
I had a great time today at AjaxWorld during my talk on building a great Ajax Application from Scratch. It was fun to get out from behind the powerpoint and show some real code! For this demo, I only used freely available tools... In particular everything I show works in Vis......
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept
This article is inspired from two sources.1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT2) Discussion with SQL Server MVP - Jacob Sebastian - SQLAuthority News - Author Visit - SQL Hour at Patni Computer SystemsI usually summarize my ......
Hanselminutes Podcast 134 - StackOverflow uses ASP.NET MVC - Jeff Atwood and his technical team
My one-hundred-and-thirty-fourth podcast is up . Well, actually a few weeks ago, but I totally forgot to update my website with the details. You'd think somewhere around 100 shows I'd had automated this somehow. Hm. If I only I know a programmer and the data was available in some kind of un......
SQL SERVER - Introduction to CLR - Simple Example of CLR Stored Procedure
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are no......
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what sort of things can you do with GIS Data? We asked an expert!...Did you know that DotNetSlackers also publishes .net artic......
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2
A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have discussed two different methods of getting datepart from datetime.Method 1:SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))Method 2:SELECT CONVERT(VARCHAR(10),GETDATE(),111)I have s......
Using the power of binding to animate changes
In a recent post, I showed how the binding component can be instantiated independently of the {binding} markup extension. But there’s a whole lot more it can do. For instance, it has two very interesting callback properties, convert and convertBack that get called any time the binding sees a chang......
Deploying changes to SQL Server with SQL Packager is now a lot more powerful
With the latest version of Red Gate SQL Packager v6, the user can specify any script to package. It is even possible to mix and match scripts generated by SQL Compare, SQL Data Compare, SQL Refactor and SQL Packager to create a deployment script. Suddenly, Database deployment has got a whole lot ea......
SQL SERVER - Get Common Records From Two Tables Without Using Join
I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly.Sachin Asked:Following is my scenario,Suppose Table 1 and Table 2 has ......
SQL Server 2005 Driver for PHP Cumulative Update
Microsoft has released an updated SQL Server 2005 Driver for PHP. The SQL Server
2005 Driver for PHP download is available to all SQL Server users at no additional
charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the
reading and writing of SQL Server data from within ......
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - October 2008
Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian ......
And now ASP.NET MVC Beta is here!
What a week just before Microsoft PDC 2008! After Silverlight 2 release it is the turn of ASP.NET Framework to be released in Beta. The ASP.NET MVC Beta release provides a new Model-View-Controller (MVC) framework on top of the existing ASP.NET 3.5 runtime. This means that developers can take a......
ASP.NET MVC Beta Released
Microsoft has released the official beta for ASP.NET MVC. You can download the Beta version from here. The Beta installer installs the ASP.NET MVC assemblies (System.Web.Mvc.dll, System.Web.Routing.dll, and System.Web.Abstractions.dll) into the GAC. In previous previews, these were not instal......
ASP.NET MVC Beta Released
Today we released a beta of the new ASP.NET MVC framework. Click here to download it. You can also visit www.asp.net/mvc to explore tutorials, quickstarts, and videos to learn more. The ASP.NET MVC Beta works with both .NET 3.5 and .NET 3.5 SP1, and supports both VS 2008 and Visu......
ASP.NET MVC Framework Status: BETA
Although I haven`t noticed any announced from the big names yet, ASP.NET MVC BETA release is already online and available for download. ASP.NET official MVC page and CodePlex site are not yet updated. Will keep you updated when the announcements come. Udpate 1: You can find screenshots ......
ASP.NET MVC has reached beta stage
Last night I reviewed Twitter, as usual, and one tweet take my attention. Kevin Dente posted this status: I jumped immediately on this link and downloaded readme and binaries of ASP.NET MVC beta release. What was strange, MSFT-ies are completely silent regarding this, although I tried to tw......
Microsoft ASP.NET MVC Beta
After 5 previews finally Microsoft released beta version of ASP.NET MVC. You can download ASP.NET MVC Beta "The ASP.NET MVC Beta release provides a new Model-View-Controller (MVC) framework on top of the existing ASP.NET 3.5 runtime." Learn more about ASP.NET MVC Microsoft ASP.NET team also working......
Microsoft ASP.NET MVC Beta Released!
Another release I thought would come during the PDC has been released:
Microsoft ASP.NET MVC Beta
Click the link above to go to the Microsoft download page.
Some points about the release (Headings taken from the What's New section):
MvcFutures.dll is not included in the bet......
SQL SERVER - Downgrade Database to Previous Version
Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts. Recently I got email from two different DBA where they upgraded to SQL Server 2005 trial version on their production server and now as their trial version was expire they wanted......
New Date Data Types in Microsoft SQL Server 2008
In August 2008 Microsoft released
the latest version of the database server software, SQL Server 2008. SQL
Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new
MERGE statement; new data types and functions; enhanced encryption
and X......
New Date Data Types in Microsoft SQL Server 2008
In August 2008 Microsoft released
the latest version of the database server software, SQL Server 2008. SQL
Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new
MERGE statement; new data types and functions; enhanced encryption
......
Open Source apps on Windows - made easy!
Today we launched the new Microsoft.com/Web website for web developers and web professionals. This new site not only aggregates the latest news and advances in the web development community, but it also provides a home for the new Microsoft Web Platform Installer Beta (Web PI) and the Microsoft Web......
SQL SERVER - Introduction and Example of UNION and UNION ALL
It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request to rewrite my article SQL SERVER - Union vs. Union All - Which is better for performance? with examples. I request you to read my previous article first to understand what i......