At SQL Saturday #75 Columbus, OH, on June 11, I had the distinct pleasure of moderating the Women in Technology lunch. The topic: “Energizing the Next Generation”. The panel: Jen Myers (blog | twitter), Sarah Barela (blog | twitter), and Erin Stellato (blog | twitter). The room: packed. The audience: awesome. If you haven’t been to one of our lunch panels yet, this is what you need to know: a group of women in technology sit up at the front of a room, talk about their experiences, and answer questions and foster discussions with the audience.

Dan Jones posted a blogpost here: http://blogs.msdn.com/b/dtjones/archive/2011/06/10/sql-server-code-name-denali-supported-oses-and-upgrade-paths.aspx showing what OS Denali can be installed on. _1) The current support matrix for OSes is as follows: Windows Vista SP2 or later Windows Server 2008 SP2 or later Windows Server 2008 R2 SP1 or later Windows 7 SP1 or later 2) Denali will support upgrading from these SQL Server versions: SQL Server 2005 SP4 or later SQL Server 2008 SP2 or later

Another very fun, very successful SQL Saturday has been written down in the history books. The Columbus SQL Server User Group hosted SQL Saturday #75 on Saturday, June 11, 2011. Friday morning, I packed up The Mighty Honda Fit for a four-state road trip. I learned a very important lesson on this drive: I was crazy for not having a GPS years ago. I rolled into town around 6:00 PM, checked into my hotel, and headed to the speaker dinner.

One of the quickest and easiest ways to make a database more performant is to reduce how much space the data takes up. Here’s a script that I wrote that’ll find each table in a database (run it in the context of the database). This script determines how many rows of data each table has (in kilobytes), determines the size of the data in the table, and then gives you a ratio of data per row.

Introduction In my previous posts I installed node.js and I made the code be a bit more readable. Now I want to make the view a bit more HTML like so that it reads a bit better and to separate concerns. I selected mustache.js out of the many that are out there. Internal template first thing was to download mustache.js. I used a package manager for that. Namely npm. To install npm you must however first install curl via

Introduction Let’s be honest the default Hello world code is far from readable and there is a bit of a mix of concerns there. javascript var http = require('http'); http.createServer(function (req, res) { res.writeHead(200, {'Content-Type': 'text/plain'}); res.end('Hello Worldn'); }).listen(1337, "127.0.0.1"); console.log('Server running at <a href="http://127.0.0.1:1337/');">http://127.0.0.1:1337/');</a> So let’s split things up. Splitting it up First of all I want to split it up in a server class and a helloworld class.

Introduction Node.js is kind of a new kid on the block. You might have heard about it since it uses javascript and in the future everything will be using javascript. node.js is server-side javascript. And you can read what the point is on their website. Setting it up node.js is coming from the linux world so the best way to test it and play with it is to install virtualbox and then download a Ubuntu VM.

I picked up the book Physics of the Future: How Science Will Shape Human Destiny and Our Daily Lives by the Year 2100 mainly to see what is in store for humanity in the year 2100. Having read Ray Kurzweil’s 3 books on a similar subject, this was of interest to me. When people predict the future they usually underestimate the pace of progress, just imagine when you looked at CPUs between 1980 and 1985, you would never think that we would have quadcore CPUs in our laptops, these quadcore CPUs would outperform those clunky machines by such a factor that it is almost impossible to put it on the same graph.

This is day 5 of my training and today it is going to focus on Backups, Advanced Backup Techniques, Sybase Central and Monitoring the System Backups Instead of backup and restore Sybase uses the commands dump and load, SQL Server people will be familiar with dump devices and the sp_addumpdevice stored procedure. In order to be able to perform backup, you first need to make sure that the Backup Server is running.

This is day 4 of my training and today it is going to focus on Bulk Copy, Automatic Recovery, Checking and Fixing Database Consistency Bulk Copy Getting the DDL The lesson started with showing how you can get the DDL for an object, you can use Sybase Central to do this or you can use the ddlgen Utility. Sybase Central is similar to SSMS, you right click on the object and select the Generate DDL option.