Connecting to SQL Server with ASP
This article shows you the basics of connecting to SQL Server in Active Server Pages.
2001-04-30
8,656 reads
Articles
Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,414 reads
Moving Databases to a New Server
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,446 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,672 reads
Book Review: Guru's Guide to T-SQL
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
2001-04-29
5,502 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,935 reads
Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,916 reads
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,552 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,636 reads
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
2001-04-25
3,457 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers