Missing Server Configuration Manager from SSRS Server
I had an interesting problem recently. I was doing some work for a client on a CRM deployment and a performance issue. Whilst onsite, I helped with a problem with SSRS and reports not displaying. Further investigation displayed an error that said SSRS was not using a valid execution account. The error was “The report […]
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 […]