Many DBAs and systems administrators are intimidated by the idea of SQL Server clustering. But by breaking the process into these six manageable steps, you can set up a clustered environment to provide high availability for SQL Server.
Linked servers, the core technology in SQL Server 2000 distributed partitioned views, let you use distributed queries to query a SQL Server or non-SQL Server database as if it were on the local server.
Extended stored procedures are a useful way to display information about files or your system. Any noninteractive program you can write in C or C++, you can write as an extended stored procedure as long as it's compiled as a DLL file.
In SQL Server 6.5 and 7.0, Microsoft ships a set of stored procedures that let you use a one-line cursor query for querying the master database for all tables or databases and performing an action on the results.
Over 50 hours of recorded sessions. Including topics on:
• Windows Server & Windows 8
• SQL Server
• Platform Development Tools
Known for its unbiased content, this year’s IT/Dev Connections provides deep training on the technologies that run your business.
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More