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 […]
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 […]
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 […]
Oracle Vs SQL Server: Are They So Different?
Before Christmas I was asked to compare SQL Server against Oracle. So I thought that would make a good SQL Server versus Oracle post. Although I have thought about this over years as I have worked with clients that have had both SQL Server and Oracle, when you sit down to write down and convey […]
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 […]