SSWUG-TV With Steven Wynkoop, Sam Brace, and our Field Reporter – Kevin Kline In this new episode of SSWUG-tv we take a look at the purchase of Green Hat by IBM. Come Check It Out Is Entity Framework the successor to ODBC? Lots of good input on this topic. Some of the responses are contradictory. Here’s what some of our […]

Is Entity Framework the Next ODBC? What made ODBC a viable technology? It created a single interface for which drivers could be written allowing access to a data store. ODBC drivers were written for text files, Excel Documents, Microsoft Exchange, ISAM Files, Relational Databases, and much more. The key was, there was a common interface used by an ODBC consumer; […]

SSWUGtv – Key Management With Stephen Wynkoop In today’s edition Stephen talks with Townsend about the basics of security. This edition is affectionately titled, "Security: Key Management 101, Lesson one — Always protect the key!" Watch the Show The Skill of the Release Recently I have been talking with colleagues about some of the less vaunted skills a software professional […]

Change Tracking in SQL Server SQL Server 2008 introduced new features for auditing data changes. They are both available on a per-database basis and yet both have distinctly different purposes. Change Data Capture monitors the Transaction log and records changes to data. The changes are stored in change tables managed by SQL Server Service. This provides a history of changes […]

SSWUGtv With Stephen Wynkoop How do you maintain security through encryption, WITHOUT killing your server? Patrick Townsend is on today’s show with some priceless tips. Watch the Show Hypothetical Indexes I was reading a newsletter from a SQL Site and came across the topic of Hypothetical Indexes. That sure got my attention. I didn’t know anything like that was available. […]

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 – Security Tips With Stephen Wynkoop When you are protecting your software assets encryption is a common method. What types of things need to be encrypted? In today’s show and find valuable tips from Security Expert, Patrick Townsend. Watch the Show Eventually Consistent This is a term with increasing importance as companies move toward NoSQL data storage solutions. The […]

SSWUGtv With Stephen Wynkoop Security is an area of change. The goals are still the same. How we implement our security continues to evolve along with our software platforms. On todays show, Patric Townsend continues his series on security with the question, What’s the difference between dual-control and separation of duties? Watch the Show DBA Role Clarification Not every business […]