THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sqlserver   (RSS)
  • Bootstrapping SQL Server bloggers and blog readers with Twitter!

    On 17th December 2009 Aaron Nelson (you may know him as @sqlvariant) had a great idea – he invented the #SQLHelp hashtag; with a little kickstart from Brent Ozar the idea grew and #SQLHelp became a successful QnA channel in the SQL Server community and is today going from strength to strength. I’m a great advocate of SQLHelp and not just because ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 3, 2013
  • Building a database installer with WiX, datadude and Visual Studio 2010

    Today I have been using Windows Installer XML (WiX) to build an installer (.msi file) that would install a SQL Server database on a server of my choosing; the source code for that database lives in datadude (a tool which you may know by one of quite a few other names). The basis for this work was a most excellent blog post by Duke Kamstra entitled ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 10, 2011
  • It will happen on a spring day in May...

    ''The world's favorite season is the spring. All things seem possible in May.''-   Edwin Way Teale  This spring, the Portland, Oregon, development community is coming together in a way never experienced before. Using the University of Portland campus, SQL Saturday and Portland CodeCamp are combining and coordinating ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on February 22, 2010
  • It doesn't matter, it's just data...

    Database Design. Sounds simple, and at the same time, demanding. I mean, what's to design. You just need a few tables to hold the data for the application you are creating. You just can't really take the time to design -the entire project is agile and under continuous evolution. Or, you are trying to support a database that someone else ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on December 14, 2009
  • You Bet Your Life

    Yesterday, Jonathan Kehayias wrote in his blog post ''Have you got air in your spare..'' about dealing with a flat time. He went on to compare spare tires to HA/DR planning. An excellent article and recommended reading. I wish to expand on Jonathan's discourse a bit. It strikes me that he opened the door for a fertile analogy. Consider that ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on October 22, 2009
  • Is it time for SQL Server to have Isolated Transactions?

    SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’ serving to increase (and decrease) the @@TRANCOUNT indicator. The transaction can be committed or rolled back at any point that the @@TRANCOUNT value is equal to one. Error conditions may or may not cause the transaction ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on March 9, 2009
  • You HAVE to Trust, you MUST Verify -and that may still not be enough!

    In Brian Kelly's recent blog post, he makes an excellent case outlining why there are few options but to 'Trust' SQL Server Administrators. And then he goes into excellent detail explaining that it may be impossible to completely 'prohibit' disruptive behavior, and that one should establish a robust auditing of security events. And it is not ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on February 20, 2009
  • What’s in a Name?

    Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the equally meaningless ‘usp’ for stored procedures. I think that it is because that is what they see illustrated in books, magazines, white papers and on-line 'example' code.  So the real question is really: ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on October 23, 2008
  • Through the Looking Glass: Elegant -or Not?

    SQL Server as an EAV Database -Good Idea?  It seems like I am getting more and more inquires from potential clients asking for help solving performance related issues with what, after some investigation, is using SQL Server as an EAV database. First, for those unfamiliar with the concept, an Entity-Attribute-Value (EAV) database seems ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on October 3, 2008
  • To Blog or Not to Blog -Is that Really the Question?

    Over the past couple of years, the chorus of voices asking, requesting, even demanding that I present my thoughts in a blog has grown so loud I can no longer ignore. As a long time teacher and trainer, I have great respect for the 'written word' -and even more for personal presentation. I thrive on dialogue, I refine and clarify my thoughts ...
    Posted to Arnie Rowland (Weblog) by ArnieRowland on October 1, 2008
Privacy Statement