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.
How can I restrict users in our Windows 2000 network to only one concurrent connection? I'd like a solution that I can implement on our Win2K server, without needing to configure individual workstations...
Last week, Microsoft announced availability of SQL Server 2000 Windows CE Edition (SQL Server CE) 2.0. The new release includes updates that will improve your query capabilities and let you set security and connectivity options more quickly. But...
I added stored procedures as articles to my merge replication publications so that SQL Server would copy the stored procedures to the subscriber database. Although the publications' Snapshot Agent is set to begin delivery of the new stored...
Server roles debuted in SQL Server 7.0. You use these helpful security tools to assign a predefined set of permissions to one or more database logins. The sysadmin role is the most powerful fixed server role because its members can perform any fu...
Your knowledge of bitwise operators can come in handy when you want to write a trigger to identify which columns an UPDATE statement modified. If you want to determine only whether a given column was updated, you can use the UPDATE() functio...