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 you write an MDX query that returns the Unit Sales for the months of 1997 on columns and the top product brand names that account for 25 percent of Unit Sales for 1997? The solution is not as difficult as it might sound. If you have ideas...
Microsoft designed the ADO model to expose the functionality of the OLE DB API to client applications. The OLE DB API provides a low-level interface to many data sources, and ADO provides a higher-level COM-based set of objects...
I have a situation in which a trigger calls a stored procedure that creates a temp table within the BEGIN TRAN operation and drops the temp table before the transaction is committed. An error in SQL Server 7.0 appears, saying the DROP TABLE ...
When you're gathering business rules and requirements for a database project and implementing them in the data model, you might need to let a data value, or attribute, assume a value of unknown. Unknown is real. So you can expect to be able ...
WebSQL subscribers who don't want to wait until next month's issue can find the answers to these questions at the link to this article at http://www.sqlmag.com...