Email Alerts
-
Row versioning with SNAPSHOT isolation level
Using "dirty" reads is a thing of the past. SQL Server 2005 expert Adam Machanic discusses SQL Server 2005's new snapshot feature. Ask the Expert
-
Granting permissions in SQL Server 2005
New security features in SQL Server 2005 make it easier to manage and grant permissions on a more granular basis. Learn more from site expert Adam Machanic here. Tip
-
SQL Server 2005 reaches final milestone
The final update before SQL Server 2005 goes out in November has some tweaks in the user interface and management tools. Article
-
Query to return database name
Global function DB_NAME() allows you to return the name of a database that a process is connected to. SQL Server 2005 expert Adam Machanic offers a sample query in this response. Ask the Expert
-
Image encryption in SQL Server 2005
SQL Server 2005 will have better image encryption capabilities, but expert Adam Mechanic gives you the resources to encrypt images now in SQL Server 2000. Ask the Expert
-
Equivalent code of sp_configure 'allow updates' in SQL Sever 2005
Ask the Expert
-
SQL Server password policies and credentials
Learn about SQL Server password policies and credentials in this excerpt from "A First Look at SQL Server 2005 for Developers." Article
-
A quick review of SQL Server security concepts with enhancements
Get a quick review of SQL Server security concepts with enhancements in this excerpt from "A First Look at SQL Server 2005 for Developers." Article
-
Optional features are turned off by default
Find out which optional features are turned off by default in SQL Server 2005 in this excerpt from "A First Look at SQL Server 2005 for Developers." Article
-
Separation of users and schemas
Learn about separation of users and schemas in SQL Server 2005 in this excerpt from "A First Look at SQL Server 2005 for Developers." Article