Browse by Tags

• Irks
• Links and News
• Opinions
• Programming Paradigms
• Technology and Internet
• Tools and Resources
• Visual Studio

• Your Database Administrator Is Your Best Friend

  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 favor and make buddies with a DBA near you (in my case, a guy 2 cubes over). More than likely they've devoted their entire careers to RBDMS of numerous varieties, and chances are even better... Posted Mar 04 2007, 11:34 PM by Jayson Knight with | with no comments Filed under: Technology and Internet, Opinions, SQL Server, Programming Paradigms

• XSD To Relational Database Model Converter -- XSD2DB

  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 do this via the BCL. The new SQL Server SMO libraries looked promising, however they are vast and patience quickly lost out to a some good ol' one on one Google time. I ended up stumbling across this... Posted Jan 21 2007, 05:53 PM by Jayson Knight with | with 1 comment(s) Filed under: Technology and Internet, Tools and Resources, Links and News, SQL Server

• Yet Another SQL Server Management Studio Gripe

  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 SQL Server 2005 databases, so I fired up SSMS expecting there to be a context menu option when you right click a table (ala Enterprise Manager) to create it. Nope, not there. Alright fine, do it via... Posted May 05 2006, 04:26 PM by Jayson Knight with | with 9 comment(s) Filed under: Irks, SQL Server

• More SQL Server 2005 Management Studio Woes

  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 is there (right click a db, tasks, export data), and the wizard is pretty similar to the one we had via SQL Server 2000's Enterprise Manager, except for one glaring "feature": The only objects you... Posted Feb 12 2006, 05:58 PM by Jayson Knight with | with 7 comment(s) Filed under: Tools and Resources, SQL Server

• Free Microsoft SQL Server 2005 Training

  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 books when new technology comes out, but given the price of tech books these days, I’ll take anything that’s free…especially if it’s straight from the source (in this case, Microsoft... Posted Dec 18 2005, 07:07 PM by Jayson Knight with | with no comments Filed under: Tools and Resources, SQL Server

• Looking for Some Definitive SQLCMD.EXE Resources

  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 to bottom detailed article (either online or print is fine) discussing the usage of it given my disdain for the new Management Studio (MS) I griped about earlier . What little I have done with SQLCMD... Posted Nov 28 2005, 05:26 PM by Jayson Knight with | with no comments Filed under: SQL Server

• SQL 2005 Management Studio is Pathetic

  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 just really been dumbed down to the point looking like Access (no offense to the Access folks). Getting anything done takes an insane amount of clicks, and it just feels soooo slow compared to... Posted Nov 22 2005, 07:35 PM by Jayson Knight with | with 23 comment(s) Filed under: Visual Studio, SQL Server