DBTechCon – Spring 2011 It’s finally here…In fact this is the last day to register to attend what is going to be the most valuable Virtual event of the year. This conference features over 20 speakers with names that have become synonymous with their areas of expertise. These experts and professionals will give you practical insights you will be able […]

DBTechCon – This Wed-Friday, April 20-22 The final countdown has begun for the largest virtual conference. Be sure to register now if you haven’t already. You won’t find a better value. Taxes and Total Cost of Ownership (TCO) Most of us who work with computer systems are not concerned with what can be a tax deduction. We, reasonably, leave that […]

SelecTViews: The SQL Server Show with Stephen Wynkoop Cloud security – what SPECIFIC steps can you start taking to assure success? Gazzang also on the show today, along with our Facebook question and upcoming events! [Watch the Show] (it’s free) Readers Responses: Timeshare – The Old Cloud One thing that is clear is that the Timeshare of yesteryear and the […]

Does Single Source produce the best system for Your Company? Apple has had a superior desktop product for decades. But it costs too much because there is no competition. As a result Microsoft Windows comes in second place running on machines that have only recently become more stable like their counterparts. Let’s be fair; Apple controls their hardware and OS. […]

Some First Steps for the Cloud… There has been a great response to the questions about the cloud (thanks!) – including an article series here on the site from Craig Mullins – make sure you keep an eye out. I put together some basics to help get you started in working with your cloud providers. I hope this at least […]

SelecTViews Show: A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] (it’s free) $$SWYNK$$ Featured Article(s) Troubleshooting Linked Servers in SQL Server 2008 In this article, Alexander Chigrik explains some problems with SQL Server 2008 linked […]

SelecTViews With Stephen Wynkoop A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] $$SWYNK$$ Plan Guides In response to yesterdays tip using sp_execute_SQL I received the following comment from Leif regarding a database configuration that can […]

Why the radio silence with this data breach? I’m confused. "The cloud is the answer" to so many things from scalability to security and performance. Sure, it’s not the be-all, end-all, but it is touted as a rational extension to your systems. I get it, and I agree… but I’ve been concerned about security from the get-go. I also think […]

$$SWYNK$$ SQL Tip – SP_Execute_SQL For those rare occasions when you really must build dynamic SQL for your SQL Server instance while using scripts or stored procedures. When doing this you have two options. EXEC(‘SQL Statement’) Or Sp_Execute_SQL There is a big difference between the two. The exec method operates completely as an ad-hoc query. If every command is EXACTLY […]

New Video Program Posted – Watch free now SelecTViews: A pet peeve – what is up with the silence about the massive cloud data breach??? Also on the show today – Michael Crump and some great applications for Silverlight. [Watch the Show] More Testing Stories Let’s finish out this week with an acknowledgement of praise to our worthy testers. Every […]