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.
From time to time, I've discussed the problem of drowning in a sea of information. Reading and digesting all the technical content that interests you and is readily available on the Web or in print is impossible. So, where do you start? Sometimes...
Microsoft has posted a new article that details a SQL Server 2000 Service Pack 1 (SP1) bug. The article explains that executing a SELECT statement that has a nested query on a table that contains a computed column might generate the following...
Congratulations to Tony Bain, senior DBA at Wellington, New Zealand-based SQL Services and Zivan Karaman, manager of the statistical department at Limagrain Genetics in Chappes, France. Tony won first prize of $100 for the best solution to the...
Are you a busy SQL Server professional who hasn't learned XML because you don't need it to fulfill your day-to-day job responsibilities? If so, you might want to rethink your reasons for not learning XML...
EDITOR'S NOTE: Send your T-SQL questions to SQL Server MVP Itzik Ben-Gan at [email protected].
Using a UDF in a CHECK Constraint to Validate a Column
I want to validate a column in table S by allowing only primary key value...
Microsoft is intent on proving that .NET's no dog when it comes to Web application development. Using C#, Microsoft. NET, and SQL Server 2000, Microsoft has implemented Sun's Java 2 Enterprise Edition (J2EE) best-practices blueprint application...