Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.
Learn to leverage the power of the cloud with your existing web applications.
Learn how to use SQL Modeling Services to hunt for interdependencies without having to access source code.
In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.
This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.
Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.
Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.
LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.
Learn how to make Visual Studio Team Suite Database Edition part of your development process.
Learn how to implement a Left Outer Join with LINQ.
You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.
Learn about a web service method to back up a database from a mobile device using the SQL Backup command and asynchronous method calls.
Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?
You can customize a SQL Server 2005 Integration Services (SSIS) package using VB.NET. One of the simplest ways is to use the SSIS Script Task. Learn the details.
Visual Studio 2005 ("Whidbey") has released. Get a first look at answers to some up-front questions you might have. Start by simply understanding the multitude of editions that entail the Visual Studio 2005 product line. After all, how many different editions can one product have?
Learn how to install, configure, and use the MS Search Engine with SQL Server. Once installed, MS Search permits you to perform fuzzy searches of small and large amounts of character-based data.
ADO.NET's SQL command builder reads a schema and generates SQL for you; this can be an excellent timesaver in the appropriate circumstances. When applied with sound judgment, this technique is a nice shortcut.
If you're a Visual Basic .NET programmer who has to write stored procedures for MS SQL Server, this article is for you. Learn how to isolate SQL code from VB.NET code to clearly create divisions of labor and focus for your solution.
The database assembly build tool is a tool to allow a developer to select database schema items (tables, views, stored procedures, users, and so forth) and export the DDL to create these items to an SQL file.
A utility form that will show DataGrid events with parameters as they happen in realtime.
Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.
Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.
Learn how to build a Windows Forms interface that allows you to work with your images database.
In building ASP.NET database applications, in addition verifying a connection to the Net, you also need to ensure that your database server is up and running.
