Usergroup meeting last night
The slides and demos
for Darren’s session can be found here http://www.sqlis.com/post/SSIS-Tips-Tricks-(Presentation).aspx
For the list of
events coming up go to http://sqlserverfaq.com
Here are some answers
to the Q&A asked at the start,
Replication
file sizes
From my
investigation the multiple files produced in the snapshot are based on the
statistics for the primary key column, base on rows. If your rows have differing
sizes i.e. contain different size documents, or your statistics are out of date
then you could end up with different size files. The numbers of rows will always
be different because the values used to segment the data are those in the
statistics and they might not fall on the exact boundary. Look at the output
from DBCC SHOW_STATISTICS (table,pk_constraint)
WMI
security
There is a
great section in MSDN on WMI remote access http://msdn.microsoft.com/en-us/library/aa389290(VS.85).aspx
As expected
there are a number of aspects including. WMI uses RPC, this uses port 135 which
is a common security flaw and used by many viruses including Nimda, CodeRed and
Slammer(http://us.trendmicro.com/us/threats/enterprise/glossary/n/network-viruses/index.php). Or DCOM permissions might not allow remote uses to start
the WMI service.
The section in
MSDN should help you through the issues.
A big thank
you to Redgate for sponsoring the event and I hope to see you again
-