Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Our SQL Server 7.0 server reflects the old server name instead of the current server name. All the databases on the current server, including the master database, are restored from the old server. How can I avoid passing on the old server and...
Qualifying the owner of an object when you reference it is always a good idea, even when SQL Server's default name-resolution rules don't require the qualification. When you use SQL Server Profiler to generate the SP:CacheMiss event, as we did in...
When I move a database from one server to another server, I usually perform a backup and restore. However, the last time I tried, I couldn't retrieve the logins with passwords and restore them to the other server. How can I bring over the...
Query Analyzer includes time-saving shortcuts to two online Help files: Transact-SQL Help and Object Help. To access Transact-SQL Help in SQL Server 2000, 7.0, and 6.5, type a T-SQL statement such as...
One of SQL Server's weak points when critics compare it with DB2 and Oracle is its lack of programmability. Longtime SQL Server users might find this criticism strange. From the developer standpoint, SQL Server seems to be the most programmable...