Quote of Day – On Knowledge

You do not really understand something until you can explain it to your grandmother. – Albert Einstein  I’ve met lots of really smart people that can’t explain what they know. I think this really sums it up!


SQL Serer 2005 – Script Tables and Data

I was asked about the "DUMP" command in MySQL yesterday. It will create a script (in order) of all the database objects and the data they contain. The question was, does SQL Server 2005 have anything like that? Why yes it does! Check out this free tool from Microsoft: http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en It’s called the "Database Publishing…


Mandelbrots and SQL Server

I was watching Nova last night and they talked to Benoit Mandelbrot, the man who codified some of the math that bears his name. This math branch deals with "rough" or repeating surfaces. You probably already know that Transact-SQL can be used to type almost any math formula. I’ve included statistical formulas, and other math…


Opening SQL Server Profiler from SSMS

The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you’ll see a list of processes that you can order, sort and filter. If you right-click any process, you’ll see an option to "open in Profiler". Click that,…


More SQL Server Videos

I was sent this link by a reader: http://www.sqlservervideos.com/series/  Not sure about the content, but I thought I would pass these along. If you review them, let us know what you think.


Quote of the Day: Do it now

“You cannot escape the responsibility of tomorrow by evading it today.” – Abraham Lincoln I have a lot going on right now – I just got back from Brazil, I’m headed to Spain, and then back for PASS here in Seattle. One thing that I have learned when things get hectic and rushed is that it…


A few minutes of the virtual…

This is pretty cool – the first 10 minutes or so of one of the virtual conference I did earlier last month is now available for free online. You can see it here: http://www.vconferenceonline.com/speaker.asp?id=BWoody


SQLH2 on Codeplex

Recently someone asked me if they could get the source to SQLH2, the “health” monitoring solution for SQL Server. I told them that I couldn’t give out source code, but Microsoft can. I said “make the suggestion on http://connect.microsoft.com and see what happens.” Guess what happened?    http://www.codeplex.com/sqlh2


SQL Server 2008 Feature Pack

This is to let you know that the SQL Server 2008 Feature Pack for October is now available.   What’s in this release? Find more details here: ·         ADOMD.Net ·         AMO ·         DMViewer ·         PowerShell extensions for SQL ServerReplication Management Objects ·         Report Builder 2.0 ·         Service Broker External Activator ·         SQLXML ·         SAP BI…


ERD Designer

So what are you using for an Entity Relationship Diagran (ERD) tool? I’m teaching a class at the University of Washington and we’re doing that part of the class now. I normally use Visio, but find it a little less than perfect for this. And some of the students can’t afford to buy it, so…