Architectural Change I was talking with a colleague recently about how architectures have changed over the last decade, and how that change has brought about a lot of successes and failures. The discussion continued to come back to business rules and performance. Coming from a SQL Server background I liked the ability to store my business rules close to my […]

Clustered SQL Server Service Won’t Start I had the joy of moving the Master Database Files in a clustered SQL Server environment. This isn’t a very hard task to do, normally. Windows Server 2008 has a great utility recently named Windows Cluster Manager which makes managing a failover cluster much easier to get your head around. So, I follow straight […]

When Indexed Views Don’t Work There are two kinds of virtual objects which you can cause to be persisted resulting in faster query performance; views and computed columns. By default views and computed columns are simply pre-defined SQL queries that are not realized until they are executed. However, if you create an index on a view or a computed column, […]

$$SWYNK$$ Reader Feedback Mark – Set NOCOUNT ON I believe it faster because it avoids extra trips to the client and back for each row count message since I believe that data is sent separately from the results for each and every row count. Prabhu – Continuous Integration I am a Program Director specializing in large scale implementation of ERP […]

$$SWYNK$$ SQL Server Tip – SET NOCOUNT ON This one short clause has been known to speed up database operations for years. I have no idea why it works. If you check the variable @@ROWCOUNT after executing your command, you will get the number of rows impacted by the last SQL Statement. However, the NOCOUNT property is by default turned […]

Continuous Integration Continuous Integration is a software development practice where changes to your software are integrated into the current code base on a regular basis. The value of continuous integration is the ability to bring new features online at the earliest possible moment. Continuous integration is accomplished by automating many of the processes for releasing software such as Building, Testing, […]

$$SWYNK$$ Do You Write Clean Code? While cruising through technical books on Amazon.com I came across a book by Robert C. Martin entitled, “Clean Code – A Handbook of Agile Software Craftsmanship.” The following quote was taken from the book, which convinced me to put it on my “TO READ” list. Robert Writes: “I know of one company that, in […]

SOLID Followup Today one of our readers, David, who contributes regularly to our editorial, submits three points we should consider when using SOLID principles. David Writes: It’s always good to take a “refresher course” on basic principles and practices now and then. And discussing basic principles often takes a back seat to the mechanics of basic skills or how to […]

SSWUGtv With Stephen Wynkoop In todays edition Steve meets with Laura Rose asking the question "What is the place of socializing (texting, IM, etc) in the workplace?" You may be surprised at some of the answers. Watch the Show SOLID – Dependency Inversion Principle This is the last in the series of SOLID principles, covering the topic of Dependency Inversion. […]

SOLID – Interface Segregation Principle This is the fourth newsletter in the series covering the topic of the SOLID Object Oriented Principles for software development. Unlike the other principles we have covered up to this point, Single Responsibility, Open/Closed, and Liskov Substitution, the Interface Segregation Principle is less transferable to languages that are not object oriented. If I were to […]