简介：sql server lessons learned and notes from the field (microsoft consultancy services, uk)

原站：http://blogs.msdn.com/benjones/default.aspx

“Benjamin Wright-Jones”的内容更新

累计：17 篇（自 2009-09-18 起）

更新：约7篇/年，最后更新837 天前

Benjamin Wright-Jones

New editions of SQL Server 2008 R2 announced

sql server 2008 r2 datacenter sql server 2008 r2 parallel data warehouse http://www.microsoft.com/sqlserver/2008/en/us/r2-editions.aspx... (309 天前)

http://inezha.com/w/0vbil5f

Benjamin Wright-Jones

Processing Excel files in SSIS 2008 – Lessons Learn

i have recently been working on a project where we need to load and transform data held in excel 2007 into a sql server database.? the excel sheets were fairly complex and had different structures.? fortunately, ssis 2008 provides some good tools to handle this situation.? lessons learned 1. it is possible to read the excel metadata using the mechanism ... (309 天前)

http://inezha.com/w/e5ypu59

Benjamin Wright-Jones

Changing the LISTENER_IP address in a database mirro

this question came up today: how can i change the ip address between the principal and mirror in database mirroring? not a common operation but this procedure worked in an isolated lab environment where we had full control over the application and transaction activity.? we wanted to introduce a wan latency injector so needed to change the database mirror... (309 天前)

http://inezha.com/w/rwr8rxx

Benjamin Wright-Jones

New HP Resources on SQL Server 2008 Data Warehousing

i haven’t had a chance to look through these yet so i can’t comment on the content but i thought i would post here to share these new resources. hp business intelligence sizer for microsoft sql server 2005/2008 http://h71019.www7.hp.com/activeanswers/us/en/sizers/microsoft-sql-bi.html hp whitepapers on sql server 2008 data warehousing / business intel... (309 天前)

http://inezha.com/w/n8bx2xs

Benjamin Wright-Jones

Troubleshooting SQL Server Transactional Replication

i often see questions about transactional replication performance problems, especially around latency/delays between the publisher and subscriber(s) so i’ve put a few pointers below on what to investigate.? latency between the publisher, distributor and subscriber(s) is, more often than not, the symptom of other causes for example, poor i/o capacity on ... (309 天前)

http://inezha.com/w/9rlubx0

Benjamin Wright-Jones

Fusion IO 640GB SSD PCI-Express Cards

we recently had the opportunity to test a couple of the fusion io pci-express 640gb ssd cards http://www.fusionio.com/products.aspx in a dell r900 server, unfortunately time was against us and we were unable to do this. the fusion io ssd cards would dramatically increase the iops capacity and personally, i think they would be suited to storing tempdb.? i... (309 天前)

http://inezha.com/w/bgivjx3

Benjamin Wright-Jones

SQL Server 2008 Books Online (July 2009) Update

only just noticed that a new revision of the sql server 2008 books online documentation has been published, the download is here http://www.microsoft.com/downloads/details.aspx?familyid=765433f7-0983-4d7a-b628-0a98145bcb97&displaylang=en... (309 天前)

http://inezha.com/w/tt73yxi

订阅者 ( 1 )

相关订阅源