Microsoft SQL Server
Learn how to save time and prevent permission configuration problems when you move a SQL Server database from one computer to another.
- James H. Byrd
- Tagged With: ALTER USER, Mapping Logins, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
Use SQL Paging to make your grids so fast that you'll wonder if you really clicked the mouse button.
- James H. Byrd
- Tagged With: GridView Performance, Microsoft C#.NET, Microsoft SQL Server, Programming Example, ROW_NUMBER SQL Function, SQL Paging, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.
- James H. Byrd
- Tagged With: Microsoft SQL Server, Programming Example, Stored Procedures, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
The next time you are designing a new application database or adding new tables to an existing database, take a few moments to think about how you can leverage the DRI features of SQL Server to make your development life a little easier.
- James H. Byrd
- Tagged With: Database Design, Foreign Key Constraints, Microsoft SQL Server, Relational Integrity, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
You'll love this tip if you are tired of navigating all over your hard drive to find your scripts from inside SQL Server Management Studio.
- James H. Byrd
- Tagged With: Microsoft SQL Server, Productivity
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.
- James H. Byrd
- Tagged With: Database Transactions, Microsoft SQL Server, Transact-SQL
- Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings
James H. Byrd
Book Publisher
Fiction Author
Software Developer
Technical Writer
Speaker
Vegetarian Cook