Well its the 30th November already down-under and the expectation is that Visual Studio Team System for Database Professionals will be released today. Stay tuned…
You are browsing archives for
Month: November 2006
What I’m Reading 28 Nov 2006
Its been a busy few weeks for me and I haven’t had as much time to catch up on my reading as I’d have liked. This is the list of things that I have been / trying to read. Software Development at Microsoft Observed Microsoft Research paper on developers� typical tools and work habits and […]
SQL Server 2005 New Feature: Scalable Shared Databases
Microsoft have released details of a new feature available in SQL Server 2005 Enterprise Edition: Scalable Shared Databases. What is it? A read-only database stored on a SAN than can be attached to multiple SQL Server instances. It will allow you to have multiple instances of SQL Server host the same database, with the same […]
Davide Mauri’s SQL Server 2005 Index Usage and Health Scripts
Davide Mauri has published a number of SQL Server 2005 scripts he uses as part of his DBA toolkit to analyse indexes including their usage and health. They’re a great short cut to building your own after wading through BOL. So far there are four UDFs he’s published that show the indexes on a table, […]
Capturing STDERR output from SQLCMD.exe
Today while working with a .bat file full of SQLCMDs with really verbose output, I wanted just to capture error messages that were being sent to STDERR without changing the .sql files. I know how to capture/redirect handles in a variety of programming languages, but I haven’t tried to do this in a windows command […]
“SQL Server 2005 Everywhere Edition” Now Called “SQL Server 2005 Compact Edition”
Ahead of the final release in December 2006, Microsoft have released SQL Server Compact Edition RC1. SQL Server 2005 Compact Edition is a very lightweight, in process relational database engine for use in desktop applications and mobile devices. It has an extremely small footprint (~3MB) and minimal overhead. It won’t use any where near as […]
Architecting Service Broker Applications
Microsoft have released a whitepaper on Architecting SQL Server 2005 Service Broker Applications. The whitepaper focuses on when its appropriate to use Service Broker, design aspects for message flow and processing, availability, and infrastructure. I think its an excellent view of Service Broker implementation from a medium-high level, with discussion of the methods used, without […]
SQLIOSim Tool Released
Microsoft have released their SQLIOSim Tool for stress testing IO subsystems. Different from the SQLIO tool which is tests IO throughput. The tool is designed to simulate the effects SQL Server would have on disk subsystems. It includes options for testing multiple files; random OLTP style queries; read aheads; bulk inserts; checkpoints; rollbacks; backup; sort; […]
Count the Occurrence of a Phrase or Word in a Column (SQL Server 2005)
Simple little bit of code that will show you the number of times the value of @PhraseOrWordToCount is found in TextColumn. SELECT (LEN(TextColumn) – LEN(REPLACE(TextColumn, @PhraseOrWordToCount, ”)) / LEN(@PhraseOrWordToCount)) AS Occurrence FROM dbo.MyTable I noticed this on Simon Sabin’s blog, I think it has more applications than just FullText searches so I thought I’d do […]
Count the Occurrence of a Phrase or Word in a Column
Simple little bit of code that will show you the number of times the value of @PhraseOrWordToCount is found in TextColumn. SELECT (LEN(TextColumn) – LEN(REPLACE(TextColumn, @PhraseOrWordToCount, ”)) / LEN(@PhraseOrWordToCount)) AS Occurrence FROM dbo.MyTable I noticed this on Simon Sabin’s blog, I think it has more applications than just FullText searches so I thought I’d do […]