EAV Yes or No : Reader Responses There hasn’t been a lot of response to this topic, and, in database circles, this topic can be close to trolling for feedback. The responses today really added something to the discussion, and I’m glad to share them. Mark: My opinion, of course, is “It depends”. I have run into the issue you […]

SSWUGtv – Technology Bit With Stephen Wynkoop How does development change as people use tablets, and how can you match your standards to their expectations? Found out more in this weeks Technology Bit from SSWUG. Watch the Show EAV – Yes or No David Pool writes about his Antipathy for Entity Attribute Value data models at http://www.sqlservercentral.com/articles/data+model/95918/. For those of […]

SSWUGtv – Characteristics of Good Leader Good managers create high-caliber teams that they enjoy and are proud of. But how can a manger be liked and trusted without sacrificing authority? Laura Rose is on today’s show with some great tips! Watch the Show IN vs. EXISTS Last week we took a moment to respond to a question regarding when to […]

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