Sep19
Kevin Idzi of Microsoft was kind enough to leave a comment on my Extracting SharePoint Data using SSIS post informing me of Integration Services enhancements posted on CodePlex.
I had been delaying posting as I wanted to have a full sample showing it in use, but between work and buying a new house recently, I have not had the time to put together my virtual machine images for a complete de...
Posted by Sidney Atkinson on
Friday, 19 Sep 2008 08:05.
Sep16
Earlier this year, I posted a short feature on auditing in SQL 2005 using DDL triggers to capture events and log them. In SQL 2008, one of the less sexy features added, though highly important and underscored by this current eras reporting and traceability debacles in public documents, is SQL 2008's new auditing features (less sexy from a populist point of view, I do note that there is probably...
Posted by Sidney Atkinson on
Tuesday, 16 Sep 2008 08:04.
Sep5
After putting up a primer post about statistics last week, my mind has now jumped to another facet of performance: cached plans.
Cached plan objects, whether they are for procedures, ad-hoc statements, views, etc., can have both a negative and positive effect on system performance. There are some general guidelines for when you will want to consider freeing the cache in order to negate when t...
Posted by Sidney Atkinson on
Friday, 5 Sep 2008 08:02.
Sep3
With all the new features in SQL 2008, it is easy for me to call 29 pages an executive summary.
Kevin Kline, SQL Server MVP, has put together a top ten list that goes into relative detail on the following ten points:
SQL Improvements
Developer Improvements
Reporting Services Improvements
Compression
Data Types and Data Storage
Security
Resource Governor
Auditing and Change T...
Posted by Sidney Atkinson on
Wednesday, 3 Sep 2008 08:01.
Sep2
If you are lucky enough to have a large format color printer (please save paper and don't print!), then TDWI has the download for you: a 20x30 Master Data Management technology poster.
For anyone who has not found it yet, here is a direct link to the PDF for Microsoft's MDM roadmap – of interest given their acquisition of Stratature last year.
Be kind, download TDWI's poster and keep a soft...
Posted by Sidney Atkinson on
Tuesday, 2 Sep 2008 08:00.