Help. My Data Is Sharded! I’ve come across a company that has very large databases that work together as a whole. They were separated in order to maintain disaster recovery requirements. In some databases a great amount of the data is modified or replaced daily. In others, the data is static in comparison. Because they already have their data sharded, […]

SSWUGtv With Stephen Wynkoop How do you know if your systems (and your data) are protected? How can you be sure? Patrick Townsend has the answers! Watch the Show Aspect Programming I have been reading “Microsoft .NET: Architecting Applications for the Enterprise.” In this book I have been introduced to what is a new concept of programming to me called […]

SSWUGtv: BYOD – Bring Your Own Device With Stephen Wynkoop Lets face it…its easy to bring your own devices into a work environment. They are small, convenient, and useful. But, how do you lock down devices and stay secure when you allow BYOD? Watch the Show Separation of Environments I have written a lot about separation of concerns from a […]

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