SQL Server 2000 Table Hints
As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time…
Part of the
network
network
Tag: sql server
Auditing Your SQL Server Environment Part II – Reviewing your Role Membership
Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in…
Inputting A Text File Into SQL Server Using T-SQL
Question: Is it possible to input a text file into SQL Server using T-SQL?
Regular Expressions in T-SQL
I recently had the problem of trying to search for a regular expression in a database field. There is no…
SQL Server Startup Parameters
Every now and then we all have to reread something we may already know because frankly if you are like…
Small Business Server and e-Commerce Capacity
Question: I'm a partner (one of six) in a small business and am trying to deploy our web site with…
Auditing Your SQL Server Environment Part I
Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in…
How to implement generators in MSSQL server
One of the important properties of any client-server application is its serviceability and an intuitive user interface. Many widely used…
Transact-SQL Programming – Sample Chapter 1
Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features--a wide variety of datatypes,…
Data Access with ADO.NET
This will be a multi-part article dealing with ADO. We will begin with a bit of history of ADO, what…
