SQL Server 2014 New Features: Encrypted Backup

James X. from Learning Tree’s Course 535 Developing High Performance SQL Server Databases asked a question (during coffee break) that wasn’t related to performance, but was important nonetheless. “Is it true that someone can circumvent a lot of SQL Server’s security by simply restoring a database backup to a different machine where he or she […]
Read More ›

Are Cursors in SQL Server Evil? Part Two: How to Use Cursors in Transact-SQL

In the previous installment, we looked at the numerous options for declaring a cursor. All that remains is the easy part: fetching data from a cursor. To do this, we shall have to declare variables for each of the columns of the cursor. For purposes of clarity and ease of understanding, I see no reason […]
Read More ›

Are Cursors in SQL Server Evil? Part One: How to Declare Cursors in Transact-SQL

Henry K., from Learning Tree’s class Developing High Performance SQL Server Databases, writes “My sysadmin said that cursors are evil, and I should never use them in my stored procedures. Is this true?” Henry: Cursors are just another tool in the T-SQL toolbox, and like any tool they can be used properly or used poorly. […]
Read More ›

How to Create Your Own Array Functions in Excel VBA

Excel Array Functions In a previous instalment, we saw how to use MINVERSE, one of Excel’s built-in array functions and we saw how we can use <ctrl><shift><enter> to insert the array result into a rectangular array of cells. We also mentioned that many Excel experts, like Mr. Excel, call such functions “CSE” functions, as a […]
Read More ›

How to Link Excel to MATLAB to Solve Complex Equations

Solving Linear System and Linear Optimization Equations Using Microsoft Excel and MATLAB In the previous instalment on linear systems we saw that Excel can easily invert a modest-sized matrix and find solutions to a set of simultaneous linear equations. In the real world, a place I allude to frequently and try to avoid as much as […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.