Q & A – Difference between IN and EXISTS Shemaulik asks: “What is the difference between IN and Exists?” I did a quick Google search and found many good examples. So, I don’t plan to go into much detail here. IN and EXIST can both be used to determine the existence of a record in a query statement. A statement […]

SSWUGtv: With Stephen Wynkoop In today’s edition: Don Boxley — Exciting updates with DH2i. [Watch the Show T4 Templates Meet ReSharper One of the hardest things to get my head around is writing code that writes code. Just putting that sentence together was hard enough. Try writing code that reverse engineers from a database and writes ORM code. Now it […]

SSWUGtv – Security and Sharepoint With Stephen Wynkoop With all the sensitive data you store in Sharepoint, how do you make sure it’s protected? Check out todays edition of SSWUGtv as Stephen interviews Patrick Townsend for some real world answers. Watch the Show Interrogating Your Database The last few days we have been talking about a problem submitted by one […]

SSWUGtv – Amazon Web Server and MS SQL Server With Stephen Wynkoop In this Week’s Technology Bit – What issues might you have moving to Amazon Web Services if you use SQL Server? Watch the Show Preparing for Deprecation I started reading about the deprecated list by following a link from Jeff, sent in response to my editorial on sp_depends […]

SSWUGtv – Personal and Professional Office Relationships With Stephen Wynkoop In this edition of SSWUGtv Steve asks the question, "How do you separate personal friendships and professional relationships in the office without offending anyone?" You may be surprised with the results. Watch the Show sys_depends has been optimized In a server environment where multiple databases work together as a whole, […]

SSWUGtv With Stephen Wynkoop What do you know about the Idera Backup Products? Watch today’s episode of SSWUGtv as Steve interviews Rick Plezco from Idera regarding their newest 5.0 Server Backup. Watch the Show Analyzing Database Stored Procedures Richard wrote in with a problem database that has been around for a while, containing many stored procedures. He doesn’t know which […]

More Q & A Today we follow up with more Question and Answer interaction with our readers. Some are providing knowledge for ongoing questions. Others ask questions themselves. So, here we go… Richard: I have been getting your newsletter for quite a while now, and I find it often contains something of interest. For a long time I have wished […]

SSWUGtv – Security is More than… With Stephen Wynkoop In the modern computer environment we ask the question, "What is Security?" Is it simply passwords and Access Controls? Does it include encrypted data? Check out this edition of SSWUGtv as Steven considers what modern security encompasses. Watch the Show Log Shipping and Other Questions Today I received a number of […]

Challenging Times with the Cloud These are great times for the cloud-based solution providers. There are some great examples of what works, what benefits there can be from a cloud-based hosting environment and we have started learning just how great it can be. All sunshine and lollipops! OK, so not so much. To me, it feels like a bit of […]

$$SWYNK$$ SSWUGtv With Stephen Wynkoop When I go to linkedin and review the profiles online I can’t think of any that has not been open to new opportunities. I haven’t looked at it scientifically, but my gut feeling says it would be rare for an individual to have that turned off. In today’s show Steve interviews Laura Rose with the […]