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. […]

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 […]

$$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 […]