How Much do SQL Server Data Professionals Make?

You’ve thought about your career, you can’t make up your mind about which direction you want to take it. You want to make an informed decision and work out if the career you chose will provide you with financial security you need. The good people at brentozar.com have been running a salary survey and the […]
Read More ›

SQL Server 2016: Keeping Up With the Latest Technology

Welcome to the first ever Learning Tree SQL Server Newsletter. Thank you for signing up. The purpose of this Newsletter is to keep you up-to-date with the latest news in the world of SQL Server. I hope you enjoy it. If you have any feedback on the newsletter, on how it can be improved or […]
Read More ›

Injection Attacks: What They Are and How to Prevent Them

One topic we discuss in Learning Tree’s System and Network Security Introduction and  Defending the Perimeter from Cyber Attacks courses is “code injection.” I wrote a bit about this four years ago, but I want to provide more detail as these attacks are not going way as quickly as we thought they might. Wikipedia defines […]
Read More ›

Excel as a Database: How to Create a Data Model in Excel 2013

Many blogs, including some originating from our friends in the rainy Pacific Northwest, have referred to the “new” data models in Excel 2013. I’m not sure “new” is quite the right word. “Useful”, absolutely. “Interesting”, most definitely. But what we are really seeing here is not so much new as it is another step in […]
Read More ›

How to Use SQL and the Excel Data Model to Repair Data

In the previous instalment on querying economic data with SQL we saw a problem not uncommon in the world of worksheets-as-database. Errors and inconsistencies that seem trivial when looking at the data themselves become annoying impediments to creating the pivot table we want. In many cases, the traditional tools of the SQL database are well […]
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.