(Pinal Dave) Locking is a mechanism used by the SQL Server Database Engine to synchronize access by multiple users to the same piece of data, at the same time. In simpler words, it maintains the integrity of data by protecting (or preventing) access to the database object.
Other News
Hardware Based Failover
Last Day to Register for SQL Server – Microsoft Management Console Stephen Wynkoop’s Webinar begins tomorrow morning. Today is your last chance to register to attend this presentation on more fully utilizing Microsoft Management Console to maintain and document your databases. Learn how to learn from the tools shipping with SQL Server. $$SWYNK$$ Featured Article(s) Top Ten Database Blunders (Part […]
One True Lookup Table
Free MMC Webcast This Wednesday, March 9th Do you use Source Control for your database objects? If you are just starting, or looking for tips on how to optimize your source control, this webcast will provide you insight on how to accomplish this non-intuitive task for relational databases. There will be lots of other topics covered as well, centered on […]
The DB2Night Show #44: DB2’S GOT TALENT! Top 10 Seek YOUR Votes!
(Scott Hayes) This was another great show for learning DB2 tips and techniques! 100% of today’s studio audience indicated that they learned something that would be helpful to their jobs!!! Our Top 10 DB2’s GOT TALENT Finalists need your votes!
DB2 10 for z/OS: The Most Secure DB2 Yet
(Willie Favero) Do you hear that silence? It’s how your data sounds as it slips out the door. More companies are facing the unpleasant task of reporting the loss of their data to the government and their customers.
Plan stability through Upgrade to 11G-Why is my plan changed?-extra nested loop
(Coskan Gundogar) After you upgrade to 11G from lower versions you might realize that some of your plans involving nested loops are changed and you started to see extra nested loops.
Dynamically naming the constraint
(Venkatesan Jayakantham) Constraint is nothing but a condition placed on the column or object. Let’s see a small example to create a Primary Key constraint.
MSDN UK Screencasts: Using HTTP, XML and JSON in WCF V3.5
Windows Communication Foundation V3.5 makes it easy to offer services which are addressed with a simple URI, accessed over the HTTP protocol and return simple XML or JSON serialized data.
VirtualBox and Shared Folders
(chet justice) I have had problems with Shared Folders in the past, read here and here, for just 2 examples.
Visual Basic Development 101: VS 2010 Part 2: Menus and Tools
(Paul Ferrill) In the last installment of Visual Basic .NET Development 101 we looked at a few basic steps to start programming with Visual Basic 2010 Express Edition.