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.
Do you have a list of SQL Server features or enhancements that you desperately want to see in future releases? Are you frustrated because you don't have a way to convey your SQL Server feature requests to Microsoft? Do you think that Microsoft...
SQL Server 7.0 includes many undocumented extended stored procedures. Although you might not want to rely too heavily on them because Microsoft might remove or decide not to support them in a future SQL Server release, the procedures can be ...
Burton Roberts' SQL Server Magazine article "Treat Yourself to Fn_Split()" (July 2001) reminded me of two user-defined functions (UDFs) I use regularly. Roberts' fn_Split() UDF emulates the Visual Basic (VB) Split() function and lets develop...
When I declare a table variable and refer to its columns as @table_variable.column_name, I get the error message Incorrect syntax near '.'. However, when I replace @table_variable.column_name with column_name, the query executes correctly. How can...
Beginning next week, SQL Server Magazine contributing editor, columnist, and database-design expert Michelle A. Poolet will present a two-part series of 1-hour SQL Server Magazine LIVE! Webinars about database-design best practices. The first...
In a follow-up to last week's commentary about the new Microsoft SQL Server 2000 Web Services Toolkit, I talked with Tom Rizzo, group product manager of Platform and Infrastructure for SQL Server, about the toolkit's XML for SQL Server (SQLXML)...