Apply the Openrowset Function to Acquire Rowsets
In the previous blog on SQL Server’s OPENROWSET function we observed that while OPENROWSET is most often encountered in relation to linked servers, it is also valuable for directly reading flat files. It’s worth taking a moment to mention another less common application of OPENROWSET ( ). If you wanted to write code that returned […]
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 […]