Showing posts from November, 2015

Start and Stop SQL Server Reporting Services from Windows Command Line or File

After learning how to start and stop Microsoft SQL Server from the command line (and thus from a command file), I decided it was time to do the same for other SQL Server services. SQL Server Reporting Services was the next. StartSSRS.cmd NET START ReportServer$SQLEXPRESS SET /p DUMMY=Hit ENTER to continue... This will start the service and, to ensure you have the opportunity to catch any messages it might throw back, wait for you to hit the ENTER key before closing the command window. StopSSRS.cmd NET STOP ReportServer$SQLEXPRESS SET /p DUMMY=Hit ENTER to continue... This stops the service and then waits for you to hit the ENTER key. Note that both command files are set up for the instance called SQLEXPRESS. Depending on what you're running and what you named it, your instance may be called something else. You can always see what the instance is named by opening the Services application, clicking on the service, and noting the Service Name: So, if like me you&

Create a Data Stream for Free at

I was browsing the SparkFun website and, curious about the tab " Data ", clicked on through. What I found was a free service where you can upload data from any of your projects and share it with the world. Choice bits from their data page include: Why are you building this? We want to bring a dose of reality to the Internet of Things hype.  is a free, robust service for use with all of your projects.  What types of projects would benefit from this service? Almost anything. Your weather station in the backyard. A classroom of kids working on science experiments. A community concerned with pollution and crowdsourcing data collection. The weight of your pug's food dish. You get the idea. If your project can send an http request, you can push data out to our servers. Can I publish a stream anonymously? Yes. But all streams are public and can be accessed by anyone with the url. Be sure to explore various streams (

Handy Tool to Pretty-Print Your SQL Queries

I'm having to wade through some pretty long SQL statements in SSRS -- one of them clocks in at over 2200 lines. The developer who created these wasn't big on consistent formatting so visually following subqueries, complex CASE statements, etc. is a real bear. A few minutes of Googling uncovered a tool by Gudu Software called SQL Pretty Printer: I'm giving the trial version of the SSMS plugin a chance and so far it's proved a time- and sanity-saver. A license will run you $50. So far it's saved me enough time that buying the license is a no-brainer. There's a free online version into which you copy-and-paste your query, hit the button, and it returns a pretty-printed version which you can then copy-and-paste into your SSMS query window (or SSRS report).