Let's face it...as developers we're expected to know a lot of stuff about a lot of things: Database design, application design, numerous languages and constructs, testing, debugging, etc. I don't know about you guys, but my head can only hold so much information before an implosion is imminent. Do yourself...
A requirement in a small project I've been working on recently came up for mapping an XSD directly to an RDBMS schema on the fly (i.e. an incoming XML schema needs to be generated into an RDBMS schema structure at runtime...I won't get into specifics as to why), so I started searching for a way to to...
I simply cannot believe all the issues I’m finding in SQL Server Management Studio (for other gripes see my SQL Server 2005 category ). The newest one is just plain dumb IMO (unless I’m doing something wrong). Recently I needed to implement a quick and dirty trigger for a test on one of my...
I posted earlier about some SQL Server 2005 Management Studio (SSMS) gripes I've come across; I recently came across another really big one that I really feel the need to air out: It's next to impossible to export an entire database to a new database on the same machine via the SSMS GUI. Sure, the option...
Huge ups to Mark for sending me an email linking to a ton of free SQL Server 2005 online training from Microsoft (though unfortunately it looks like the “virtual labs” part of the training won’t be available until early February of next year). I usually just go out and buy a ton of...
Does anyone know of a good hard core SQLCMD (not the ADO.Net object, the OSQL replacement that ships with SQL Server 2005) reference? The SQL Books Online documentation for this new tool is terrible, and Google isn’t turning up much more than basic primers. I’m looking for a hard core top...
Forget everything I said earlier about SQL Server 2005 Management Studio (herein referred to as MS from now on); it’s slow, bloated, and just all around pathetic. It seemed great at first, but after having done some heavy lifting with it lately it just seems…well, geared for idiots. It’s...