Tuesday, January 31, 2006

Enjoy reading up the insights of Visual Studio 2005 from the release team.

Related link: http://blogs.msdn.com/release%5Fteam/

Cheers,

~Danish Sami

1/31/2006 12:21:04 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Monday, January 30, 2006

This question is in every developers mind about where I use what.


T-SQL is meant for writing up SQL Server queries where you want to perform only database related operations, while SQL CLR Stored Procedures are applicable when you want to write more then database related operations like writing up complex formulas, connecting with some other database and much more. To add more SQL CLR Stored Procedures can be written any .Net language and publishable as a WebService.


Cheers,
~Danish Sami

1/30/2006 5:45:59 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Sunday, January 29, 2006

Welcome to OJ.X Online, where you can watch select presentations from the Compuware OJ.X learning festival that took place Oct 6th at Compuware Headquarters in Detroit. This online experience includes keynotes and technical presentations on Agile software development in Java and .NET, code quality on large scale projects, security, model driven design, and other timely technical topics.

http://www.compuware.com/events/forms/ojxreview.asp?cid=30DEX5&focus=DevPartner&source=Web+%2D+Registration&desc=OptimalJ+%2D+OJ%2EX+online+hub&offering=DevPartner&sf=1&p=0

1/29/2006 7:39:50 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Saturday, January 28, 2006

Course 2936: Installing and Securing Microsoft® SQL Server™ 2005
Course 2936: Installing and Securing Microsoft® SQL Server™ 2005
Course 2938: Data Availability Features in Microsoft® SQL Server™ 2005
Course 2939: Programming Microsoft® SQL Server™ 2005
Course 2940: Building Services and Notifications Using Microsoft® SQL Server™ 2005
Course 2941: Creating the Data Access Tier Using Microsoft® SQL Server™ 2005
Course 2942: New Features of Microsoft® SQL Server™ 2005 Analysis Services
Course 2943: Updating Your Data ETL Skills to Microsoft® SQL Server™ 2005 Integration Services
Course 2944: Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services

Related link:

https://www.microsoftelearning.com/catalog/ITProDev.aspx#sqlServer

1/28/2006 6:56:44 PM UTC  #    Disclaimer  |  Comments [0]  | 

His life was gentle; and the elements
So mixed in him, that Nature might stand up,
And say to all the world, THIS WAS A MAN!

1/28/2006 6:28:33 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Monday, January 23, 2006

June 30, 2006 will bring a close to Extended Support for Windows 98, Windows 98 Second Edition, and Windows Me as part of the Microsoft Lifecycle Policy. Microsoft will retire public and technical support, including security updates, by this date.

Read more http://www.microsoft.com/windows/support/endofsupport.mspx

Cheers,

~Danish Sami

1/23/2006 6:29:16 PM UTC  #    Disclaimer  |  Comments [0]  | 
 Thursday, January 19, 2006

Frequently Encountered HRESULTS from OLE

This list was compiled from the Winerror.h file, which ships with the Win32 SDK. This list is actually a subset of a much more complete set of OLE errors. However, this is the set most likely to be raised by OLE or OLE-DB to ADO.

Cheers,

~Danish Sami

 

 OLEandOLEDBProviderErrorswithADO.txt (21.67 KB)
1/19/2006 1:52:43 PM UTC  #    Disclaimer  |  Comments [3]  | 
 Monday, January 16, 2006

Never mess with orignal data.

1/16/2006 6:52:13 AM UTC  #    Disclaimer  |  Comments [0]  | 
 Sunday, January 15, 2006

Security has been enhanced in SQL Server 2005. You can not only ENABLE/DISABLE login but can do more then that.

One of my colleague was on vacation so for security reasons I tried to DISABLE his login during the whole vacation, I issued the statement

ALTER LOGIN <login_name> DISABLE
GO

And when he came back, I issued this statemetn to ENABLE again

ALTER LOGIN <login_name> ENABLE
GO

Try doing it, a nice feature.

1/15/2006 6:25:57 PM UTC  #    Disclaimer  |  Comments [0]  |