Tuesday, October 7, 2008

Support for SQL Server 2008 – new release

We are very excited to announce a major new release of the following tools which now provide full support for SQL Server 2008:

  • xSQL Object V3 (free for SQL Server Express)
  • xSQL Data Compare V3 (free for SQL Server Express)
  • xSQL SDK V3
  • xSQL Builder V2
  • RSS Reporter V3 (free for one SQL Server instance)
  • xSQL Object Search V2 (free tool)
  • xSQL Script Executor V2 (free tool)

What's new - a detailed description of changes and enhancements on this new release can be found at: <>. Following are some highlights:
  • Support for all new or enhanced data types such as geography, geometry, hierarchyID etc.
    Support for the table level change tracking feature introduced by SQL Server 2008.
  • Data compression support for tables, primary key constraints, unique constraints and indexes.
  • Support for the enhanced full-text catalogs and indexes.
  • Support for Remote Service bindings for Service Broker.
  • Improved object dependency handling.

You can download those tools from: http://www.xsql.com/download/

Wednesday, October 1, 2008

He is just the data guy – what the …. does he know!

This is a true story. I don’t think that this particular opinion about those “data guys” so eloquently articulated by this particular person represents a majority opinion and as such I should probably simply ignore it but it stung pretty badly so I couldn’t put it to rest without expressing my disappointment in writing.

Here is the story. I was consulting for this marketing company who was working on a project for a big customer. An experienced data guy, let’s call him Frank (not the real name), on the customer’s side had provided the data for the project as well as some important pointers on what he thought we should be focusing on. Well during one of the meetings at this marketing company’s site when the discussion was going on a direction that completely ignored Frank’s suggestions I reminded them of what Frank had said. The person in charge, forgetting for a moment that I am a “data guy” by trade as well, said “Frank is just a data guy, what the …. does he know!”. As the last words were coming out of his mouth he realized the mistake but it was too late.

This marketing company has a small IT department which is “coincidentally” made up of “data guys” and I had seen this person tell those data guys how important they were to the company and how much their hard work was appreciated and blah, blah, blah… I was just glad those guys were not in the room at that moment.

As for me personally, I don’t hold any animosity towards this person with a marketing degree who for whatever reason (other than the fact that this guy makes twice as much as those data guys) thinks that he is smarter and better than those “data guys” who have computer and math degrees. I simply doubled my rate for this client and I am sure that in the next assignment (if it ever comes) I will be twice as smart J

There, now I can forget about this!

Wednesday, September 17, 2008

New version of xSQL Profiler released

We have just released a new version of xSQL Profiler. In addition of performance and other improvements on the core (including bug fixes of course) it includes custom query templates that allow the user to gain invaluable insight from the trace data that the xSQL Profiler collects. It utilizes SQL statement signatures to identify the queries that may be bogging a particular server down because of CPU consumption, I/O traffic etc.

The performance reports included in this release are:
  • Top N queries by number of times executed
  • Top N queries by CPU time
  • Top N queries by duration
  • Top N queries by number of Reads
  • Top N queries by Read/Writes
  • Top N queries by number of Writes
xSQL Profiler supports SQL Server 2008, SQL Server 2005 and SQL Server 2000 all editions. You can even trace SQL Server Express and MSDE instances.

Completely free with no restrictions or limitations for up to two SQL Server instances. Download your copy today from: http://www.xsql.com/download/sql_server_profiler/

Friday, August 29, 2008

SQL Server Express 2008 - 3 editions

There are three different version of SQL Server 2008 Express:

SQL Server 2008 Express
SQL Server 2008 Express with Tools
SQL Server 2008 Express with Advanced Services

What are the key differences? Which one should I download?

First let’s look at SQL Server 2008 Express and SQL Server 2008 Express with Tools – there is virtually no difference in functionality – the only difference is that the download package for the SQL Server Express 2008 with Tools includes a bare bones version of Management Studio to allow you to perform some admin functions from a nice interface. Well, there is one more little difference – SQL Server Express with Tools includes PowerShell Integration which otherwise would have to be installed separately. So which one should you download? Well, if you already have SSMS (SQL Server Management Studio) installed on your machine then there is no reason to download the SQL Server Express 2008 with Tools.

When it comes to SQL Server Express 2008 with Advanced Services things are different – there are a few critical (this is relative term – those are critical services if you need them) services included in this edition that you otherwise don’t get:
- Integrated Full Text Search
- Reporting Services (increase RS memory limit; RS Word/Rich Text Export; IIS agnostic report deployment; Enhanced gauges & Charting; Business Intelligence Developer Studio)

Also, the SQL Server 2008 Express with Advanced Services includes Synchronization Services which in the other two editions would require a separate installation.

So, if you need any of those advanced services your choice is clear – download the SQL Server Express with Advanced Services.

You can learn more about SQL Server 2008 Express and download your copy from Microsoft’s official site at: http://www.microsoft.com/express/sql/default.aspx

Wednesday, August 27, 2008

xSQL Profiler deployed in minutes

From all the comments we have received so far it appears that we have hit the mark with the “agent-less” feature of xSQL Profiler. Unlike many of the database monitoring / diagnosing tools that require the installation of service agents on the target servers and consequently require days to deploy, xSQL Profiler does not need any agents. The xSQL Profiler application and service are installed in minutes on a single machine from where you can define and schedule traces to run simultaneously on as many target servers as you need. The trace data from all servers are pulled automatically on predefined time intervals into the central repository. It can’t be simpler than that. And did we mention that it is completely free for up to two SQL Server instances? Go ahead, download your copy today and let your colleagues know.

PS not only can you trace SQL Server 2000, SQL Server 2005 and SQL Server 2008 but you can also trace SQL Server Express and MSDE instances.

Tuesday, August 26, 2008

Every 10 PCs migrated to Vista = one car off the road

“Every 10 PCs migrated to Windows Vista is equivalent to taking one car off the road in terms of greenhouse gasses” (Windows Vista Energy Conservation - http://www.microsoft.com/windows/products/windowsvista/enterprise/vistafacts/default.mspx).

This got my attention fast – consider the number of PCs in use and just imagine the impact this could have! I decided to dig deeper and inform myself so that I could potentially become an advocate of this cause – after all I would much rather convert my PCs to Vista than give up driving my car to save the environment (well, as the melting of the arctic ice continues we may have to soon give up the car and much more but if there is anything that would help us postpone that I am all for it).

As I started reading the paper the first thing that struck me was the disclaimer section which in essence says “if you believe anything we say here don’t blame us it’s your own fault” – I found this a bit discouraging but given that nowadays everybody and their uncle seems to have some claim against Microsoft I thought that this was the prudent thing for them to do and continued reading the paper.

So, what did the paper tell me? It told me that yes, potentially, assuming your PC stays on for 24 hours with neither the monitor nor the PC ever being turned off or going to “sleep mode” then yes the energy savings you could realize by either turning the PC off for the 16 hours you don’t use it or by replacing the operating system with Windows Vista, which by default will make the PC go to sleep mode when not in use, are significant. Based on published and accepted averages the carbon dioxide (CO2) you would keep off the atmosphere is about 1,178 lb which is the equivalent of about 10% of the CO2 emitted by an average car on one year. So, yes with those calculations 10 PCs converted to Vista equal one average car off the road. But, is the scenario considered in these calculations realistic? Absolutely not! Even in enterprises where the employees maybe instructed to leave their machines on so that they are available for software installs, patching and remote access the monitors are likely set to go to sleep mode so that alone removes a good portion of the presumed savings. Furthermore, what’s really critical to remember is that Windows Vista may make realizing energy savings easier and more convenient but those potential savings are available and can be realized without having to upgrade to Windows Vista.

Please note that this is not a case against upgrading to Windows Vista – the reasons for upgrading are abundant in many scenarios – but it is rather taking aim at bold and not always well founded marketing claims.

Is this smart marketing? I would say yes, in a World that is becoming more and more aware of the environment a claim like this has a high chance of getting the attention of the potential customers – it certainly worked on me.

Does it work beyond getting attention? The answer to this is a bit more complicated. While it may sometimes backfire, often it works. Here is why. For a mid level manager that is trying to make the case for upgrading, such claims made by reputable companies are a huge help. These managers don’t need convincing for themselves - they may have a lot of other, well founded but hard to explain to upper management, reasons for upgrading; what they need is ammunition that will help make their case a simple no-brainer and such claims give them exactly that ammunition.

Is it ethical? If the claim was false then this wouldn’t be a question but it is not false. I think the ground is a bit shaky here and so is my answer. To be completely on the safe side the statements should highlight the average scenario instead of the extremes but I can't quite say it is unethical to highlight the extremes.

Thursday, August 21, 2008

MCDBA with no experience OR 5 years of experience

If you had to choose between hiring an MCDBA who has very little real life DBA experience and someone who has 5 years of practical DBA experience but no certification which one would you go for?

Please submit your vote on the right hand panel here and if you wish explain your rational on a comment to this posting.

Please note that this is completely hypothetical – no one’s fate is being decided by your response here but it would be very interesting to see if there is an overwhelming opinion in favor of one or the other.