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 ›

Do you know your Recovery Point and Recovery Time (RPO and RTO) Objectives?

Introduction I have been working on a client project over the last few weeks, well it’s more like a few months now; as I was asked to help with a SQL Server performance issue. Once the performance problem was sorted, I ended up taking on many of the other database administration and architecture tasks that […]
Read More ›

How to Use the OPENROWSET Function to Read Text Files

Fayed, a student in Learning Tree’s Introduction to SQL Server, asked how to import text files into SQL Server. Quite a difficult question, actually, because there are many different ways. The hardest part is choosing the method that is best for the task at hand. Today we’re going to take a look at reading text […]
Read More ›

SQL Server 2016 a Year Review

SQL Server 2016 It is the first week of the new year. It is around this time that I like to reflect on the year gone by and look forward to the year ahead. From a SQL Server perceptive, 2016 was a very interesting year indeed. Back in June we saw the release to market/manufacture […]
Read More ›

Save Time Writing T-SQL With Templates and Code Snippets

Time-savers are most important when you are busy – that seems obvious. The unfortunate irony is that when you are busy you cannot take the time to create them. The creation of time-savers drops to low priority the minute the rush is over. Well, today I am going to fight my natural laziness and create […]
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.