Latest SelectViews SQL Server Show Posted
We’ve had excellent feedback on our series of how-to shows that we started last week and are continuing this week. We’ll have our final in this series next week and are taking your feedback and suggestions on these as we go forward. Please keep the comments, suggestions, feedback and referrals coming!
(Special Edition) – The show this week is a getting started with SSIS how-to show. If you’re curious how it works, how you get started with it, how you can use it, this is for you.
Simplify Your Life…
Simplify your queries (and more). Working with multiple database types can be a challenge. By using a single tool across platforms, you can really save time, energy, confusion and money. With the Advanced Query Tool, you can do administrating, data synchronize and compare, edit tables and much more. You can even do migration work between platforms. Check it out here – the single license covers all platforms – no multiple license charges here just to get going and production with your environment! Get more information here.
How I hire a DBA (The Interview beyond the technical questions)
I have posted a previous article on a set of sample questions I would ask a Database Administrator, in the next couple of weeks I will supply the questions that I ask a Database Developer. You can find the Administration Questions here. Beyond the technical questions there are things that I want to know that will help me decide.
Mitigating Risk with Data Policies
Just a quick note about data risk and policies. Gary wrote in to say:
"I just had an issue come up in this regard.
I just received a letter from Western Union saying they had a data security breach and my data may have been compromised.
Well, in my mind, since I used their service only once and that was over 5 years ago and I don’t consider myself a current customer, why did they still have my records hanging around so they could be compromised?
I recall something about not keeping credit data over 90 days, or so, after the last transaction, in order to mitigate risk."
Which is really the other side of the "controlling risk" coin – if you don’t have the data to lose, you can’t be compromised. If you can’t be compromised, not only are you doing a service to your own risk management group, but you’re also providing protection for your customers. One of the things we’re doing in some cases is helping people understand how they can set up data warehouses to house the summarized data, then get rid of the details that cause the issues. If you can set up the rules that help you govern how to make the data transition to summary from detail, you’ll be well on your way to adding a risk limiter.
Microsoft T-SQL Performance Tuning Part 2: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using Indexing Strategies
This white paper, authored by SQL Server expert Kevin Kline, discusses the basics of indexes, such as density and selectivity… (read more)
Essential Integration for the Mid-Sized Enterprise
Integration gaps – between business partner, internal organizations, business processes, and automated systems – are responsi… (read more)