Simple Talk is now part of the Redgate Community hub - find out why

Scaling out SSRS on SQL Server Standard Edition

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.… Read more

Upside Down Sizing

0
0
At one point late last week I had a 4 bedroom house in the happiest place on earth, Orlando, Florida. It was a nice two story home, with a swimming pool and game room, new appliances and two large oak trees out front and a fertile rose bush whose yellow roses bloomed 40 or more … Read more
0
0

The Target of Your Defection

0
0
I was a bit nervous this morning. I had been tasked with adding two SQL instances back into a master/target (MSX/TSX) relationship so that they would receive updated job code that had a new DFS share backup maintenance plans. Why was I nervous? Well, nervous might not be the right word. I was challenged because … Read more
0
0

Wonder Twins at PASS Summit 2014

0
0
It is Saturday afternoon in Orlando and as I type this, my wife, Karla, is in St Louis attending SQL Saturday #333. I have just finished my HoneyDo list and have been thinking about the upcoming PASS Summit 2014 in Seattle and all of the great memories there. I could tell you about the time … Read more
0
0

Crime Scene Investigation: SQL Server

0
0
“The packages are running slower in Prod than they are in Dev” My week began with this simple declaration from one of our lead BI developers, quickly followed by an emailed spreadsheet demonstrating that, over 5 executions, an extensive ETL process was running average 630 seconds faster on Dev than on Prod. The situation needed … Read more
0
0

SSRS Reports as a Data Source in Excel 2013

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now take advantage of development efforts in new ways.… Read more

DEF CON SQL

0
0
On Saturday July 27 2013, 10:37 AM EST, I was sitting with a small clan of DBAs at the SQL Saturday in Cocoa Beach, Florida (you know, the place where actual rocket scientists live and work). A colleague had a serious issue with his laptop, on which was critical information for the event. Somehow, inexplicably, … Read more
0
0

Dear Microsoft Access: I Love You

0
0
Five weeks ago, I was on a phone call talking about problems our users were having with an MS Access application. Up until this point in my career, I had successfully fended off “database” questions or issues in MS Access because I was not an MS Access expert. Now though, on this call, put together … Read more
0
0

2013 and the Impossible Challenge

0
0
I am consistently amazed when I read on twitter the exploits of DBAs who compete in marathons, endure triathlons, or simply run every single day. For me: impossible. The furthest I have ever run in one go was 3 miles. I was 9 years old, barefoot, and being chased by a Doberman. Older now, and … Read more
0
0

How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue

Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue