Exploring LINQ

I just got some time to look into newer things, and one of the most intriguing is LINQ (Language INtegrated Query). I’m just sharing some useful links I came across over a night of browsing for information: http://msdn2.microsoft.com/hi-in/library/bb308959(en-us).aspx (an introductory article by Don Box and Anders Hejlsberg) http://introducinglinq.com/ (you can get a free e-book from here) And some…

0

Connectivity related questions

Some time back there were some connectivity related questions thrown at me: Q1. We know about the Dedicated Admin Connection (DAC) and how it is useful for troubleshooting service hang issues. We also know that DAC should only be used when necessary. Can we find out if someone is misusing the DAC and staying connected…

0

The role of STOPAT in RESTORE DATABASE

Previously in SQL Server 2000, the STOPAT clause was provided for RESTORE LOG wherein you can “halt” the recovery process at a particular point in time. This feature is very useful for recovering from accidental user errors and such. Now in SQL Server 2005, there is a STOPAT clause provided in the RESTORE DATABASE command…

1

Enforcing password policy for all SQL Authentication Logins

One of my customers recently asked me how we can enforce the CHECK_POLICY option for all logins created on the SQL 2005 instance. Since by default this is enforced on a per-login basis, we cannot by default have it at a server level. But by using DDL triggers in SQL Server 2005, here is one…

0