I”m about to preorder a copy of SQL Server MVP Deep Dives at Amazon.
53 SQL Server MVP”s have been working on the book for the past year or so. Among the authors are Paul Nielsen, Hugo Kornelis, Itzik Ben-Gan, Bob Beauchemin, Erland Sommarskog, Brad McGehee, Tibor Karaszi, Aaron Bertrand, Joe Webb, Kevin Kline
Now, where did I leave my Master Card?
I knew it!!
I noticed the following blog post the other day on SQL Server myths: http://sqlblog.com/blogs/paul_nielsen/archive/2007/12/28/sql-myths.aspx
We tend to take things for granted when reading blog posts. Aparently there is a lot of crap written about SQL Server on the Internet.
Man I sometimes can”t believe what people write about indexes or transaction logs!
Who”s right and who”s not? Blogs are a great learning resource but I”d rather read from the great ones or buy a good descent book.
The Belgian SQL Server User Group will take part in the next Community Day which will take place in Keerbergen at June 26th.
One or two free sessions will be given by each one of the 9 participating user groups
Community Day is a free event including food and beverages.
Check this out: A webpage that gets all the tables, their column names, column data types and other information from an SQL Server database.
A list of my personal freeware DBA toolkit:
I found out today I”m a geek by reading this excellent post from NOMADISHERE
Or maybe I”m just intelligent as he put it…
I”m not sure what I have to do with this information. It can”t be a bad thing I guess (I hope).
Someone of the BI gang came up to my desk the other day complaining the Enterprise Manager was deadly slow when opening a database. We both went to his desk and yes indead, it took ages whilst looking at the status bar which said: “Establishing connection and checking security settings” or some sort.
Well folks, for the ones who din”t know yet (as myself), check out this KB: http://support.microsoft.com/default.aspx/kb/889696
That”s what I call a superb KB!
It almost took me two days but I made it to import a SQLBase database into SQL Server. It looks like a lot of people in user groups had problems as well, that”s why I don”t bother anymore posting my problem, it”s not getting answered anyway.
So for all you lot out there dealing with the same issue, here is what I did:
Now, first go to the Gupta website and download the SQLBase 9.0.1 Driver Pack for Windows from http://www.guptaworldwide.com/Products/SQLBase_Prod_Drivers_Download.aspx .
Make sure you reboot after the drivers have been installed. Next make a DSN to the SQLBase database engine. The information you need to enter is quite straight forward but keep in mind that you need to enter a UNC path to the sql.ini file of the machine where the database engine is installed at.
Next, within a DTS you should be able to import data by choosing a Gupta DSN or Gupta OLE DB Provider and voila!
It doesn”t look that dificult at all but it still took me two days to get it working.
Now that I know a little SQLBase, I have to say it”s a quite interesting product. I think I might fiddle with it for a while.
Although it exists quite a while I only find out until now that Microsoft puts it”s Technet Magazines available for download in chm format. Oh boy, reading material for the holidays ;,,)
Check out this excellent SQLQueryStress utility from Adam Machanic: