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.
Have you deployed SQL Server technology in a creative and innovative way to solve a thorny technical or business problem? Do friends walk into your server room and sigh, "Wow, I wish I had a SQL Server setup like that"? Do you yearn to stand on...
After the publication of "Set Sail with Visual Studio .NET," February 2002, InstantDoc ID 23457, I received lots of questions from DBAs and developers who realized the importance of Visual Studio .NET to the next release of SQL Server, Yukon. Here...
Can I create in T-SQL a stored procedure that loops through rows and concatenates data into a variable, as I do in Visual Basic (VB)?
There are two basic ways to solve problems in T-SQL: row-by-row processing or set-based logic. Row-by-r...
I created a unique constraint on a column called Col1 in table Test1 to enforce uniqueness with the exception of NULL. The entry for "Unique Constraint" in SQL Server Books Online (BOL) specifically says that you can create a unique constraint on...
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to [email protected]. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...