 | Creating SQL Server Databases Part 2
The fourth part of the SQL Server Programming Fundamentals tutorial continues the consideration of database creation in SQL Server. In this article we will investigate how to create new databases using Transact-SQL query language commands. |
| Creating SQL Server Databases Part 1
The third part of the SQL Server Programming Fundamentals tutorial investigates the creation of new databases. This first task in any new database project requires the careful consideration of several key configuration options. |
| SQL Server Programming Tutorial Database
The second part of the SQL Server Programming Fundamentals tutorial describes the database that will be created throughout the rest of the tutorial. In each instalment, this database will be improved or used to demonstrate SQL Server development. |
| SQL Server Restricted User Mode
When performing some maintenance tasks, particularly in recovery situations, it is essential to restrict access to databases by general users. In these situations, restricted access mode can be employed to limit connections to high-level users only. |
| SQL Server Single User Mode
In some maintenance situations, it is useful to obtain exclusive access to a SQL Server database. This can be achieved by setting the database's user access into single user mode, which permits only one connection to be made to the database at any time. |
| Determining the SQL Server Version
Software developed for use with SQL Server may be executed on many different versions of the database management system (DBMS). Sometimes you will need to know the edition and service pack level in use to optimise a program or to avoid known issues. |
| Making a SQL Server Database Read-Only
There are many situations where it is important that users are unable to modify the contents of a database. For example, if data is to be migrated to another server or for reporting purposes. This tip explains how to set a database to a read-only mode. |
| Resetting SQL Server Identity Columns
Microsoft SQL Server identity columns provide a useful way to automatically generate consecutive numeric values for identifying rows. During software testing, IDs may be generated and then deleted. Afterwards, you may want to reset the number sequence. |
| Generating Globally Unique Identifiers (GUIDs) in SQL Server
In an earlier article I described some of the purposes and details of globally unique identifiers and their use within the C# programming language. When storing GUIDs in SQL Server databases, the database itself can be used to generate these unique IDs. |
| Padding Numbers Using Transact-SQL
Numeric codes held in a database as integer values or other numeric types will sometimes need to be represented visually in different formats. A common request is to pad a short number with leading zeroes to achieve a specific string length. |
|
|