Change Tracking in the Data Warehouse Today we have a feedback from readers about the use of Change Data Capture and Change Tracking features in SQL Server 2008 and later. Thomas I wouldn’t encourage anyone to use Change Tracking without emphasizing that they should be on the latest CU of whatever version of SQL they are running. For instance for […]

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

Readers Say Size Really Matters Based on the response from the editorial Size Matters it seems this is a common concern. Today, many of our readers have provided some real world solutions I believe you will find helpful. John writes: We work with thousands of stored procs and T-SQL code bits between several systems and hundreds of databases. I am […]

SSWUGtv With Stephen Wynkoop How can you tell if your employees are engaged and motivated? How would you motivate someone who’s driven by "Identity and Purpose"? Laura Rose knows the answers! Watch the Show Size Matters Recently I was assisting a client with some SQL code. The code was the script to create a stored procedure consisting of a large […]

Readers Respond Ouch. I really missed some good information from Darryll’s reply on EAVs. I was sure to read it all today, and am glad to post here his much more complete response. Thanks, Darryll, for sending a second reply. As I mentioned below in my original email, there is a reference pattern / model for EAV described in the […]

SSWUGtv With Stephen Wynkoop Cell-level encryption and TDE: what do you need to know? Patrick Townsend has great tips on today’s show. Watch the Show Do Reference Materials Provide Support for a Data Model Today I wanted to come back to my main concern demonstrated in the EAV – Yes or No editorial this past Tuesday. Using EAVs is a […]

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