New Ashdar Partners Web Site

By -

Ashdar Partners (that's me) has recently rebooted our web site. You can see it here. 

It fulfills all of our requirements, which are:

  • Have a web presence, because it shows at least some minimum level of competence.
  • Be as simple as possible, because simpler is better.
  • Be served entirely out of GitHub, because GitHub seemed easier than Azure.

That is all.

Popular posts from this blog

Parsing SQLIO output with Powershell

By -
Anyone who has used sqlio knows that it's output files are not particularly readable. I used to manually run sqlio tests, then retype the output into a spreadsheet so that I could more easily analyze the data. This proved time-consuming, error-prone and boring, so I wrote a script that parses all of the data that I wanted from the sqlio output file. This post provides that code, and some background on how I use it. I will return to my series on my Powershell set up next time. The first thing to do is to run your tests with sqlio and get it's results into files. This is left as an excercise to the reader. I have a .cmd file that I use to do this. I use a .cmd file because most of the machines that I test do not have Powershell installed on them. I am including this file in the SQLIO.scripts.zip file. The reason that I break the running of the tests and the parsing of the output into two seperate processes is to decouple them. It can take quite a while for sqlio to run, especial...
Read more

Using Powershell in a SQL Server 2008 job step

By -
I have been using Powershell since I first got wind of the beta and realized that all of my Windows Scripting Host skills would become obsolete.  However, I've never had the opportunity to try out the Powershell job step type for SQL Agent jobs until today. I know that the Powershell that "comes with SQL Server" isn't the same as the regular Powershell but, other than some fiddling around with the SQL Server file system provider, I've bumped up against those differences before. It's just different enough to be frustrating, so I'm blogging about it. It's a bit of a rant, but maybe it will save someone some time or someone can point out something that I've overlooked. My goal is to have a simple script that I can use in a SQL Agent job that can automatically discover and backup any SSAS database that exists on the same computer that as the SQL Agent. (This is an improvement over my old method, which used hard-coded XMLA queries to backup speci...
Read more

In Memoriam: Azure Data Studio

By -
Recently, Microsoft announced that they will be sunsetting Azure Data Studio (ADS).  In other words, ADS is off to Software Valhalla, where it will join Query Analyzer and SQL Enterprise Manager. (And SQL Server for Itanium and SQL Server for Alpha and Multiplan and Professional Development System and QuickBasic and QuickC and many, many other things (Microsoft or not) that exist only as memories.) This announcement  was a bummer, but I was surprised at my lack of surprise. It was more of a "yeah, I guess that makes sense" rather than a "oh, wait-what?" or "I thought they were going to get rid of SSMS". Remember when Microsoft helpfully (?) installed ADS when you installed SSMS? I've been using SSMS since SQL Server 2005 When I started working with SQL Server, I used Query Analyzer because that is what was available. Which means that I used Query Analyzer for about six or seven years. How could it have been that long? No one remembers good old QA anymo...
Read more