Developer or DBA – Who makes the most?
My last newsletter was focussed on a salary survey that was taken back in January. You can see that post here. We’ll use the same data set in this post. In this post we will look at the data, try and look at what the different types of data professional jobs are, and what people working […]
Optimize Your SQL Server Queries with Column Statistics
Have you ever done something that your mother told you to never ever do? Well, we’re going to do that today, except with SQL Server. We’re going to get rid of SQL Server column statistics with the goal of learning what column statistics are and how they help SQL Server arrive at superior query plans. […]
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 […]
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 […]