blog.3bit.com
3Bit Solutions: blog.3bit.com
http://blog.3bit.com/pageno/15
TelstraClear: now’s good, but you’ll have to wait. My partner's parents are TelstraClear customers for their home line and broadband. No complaints about service or reliability, it all works well. The real drama is when you try and get in touch with TelstraClear and get services changed or moved. I would buy a lazy boy, a wireless headset, and get comfortable, as it will take forever. No service for a month, a terse phone call (which took 50 minutes. To get these two rather simple issues resolved. About ...
blog.infostructure.co.nz
The Occasional Thought: July 2013
http://blog.infostructure.co.nz/2013_07_01_archive.html
Tuesday, 30 July 2013. People can be seen by a business as an appreciating asset - hence the concept of "human resources". The more time the asset is associated with the business, the more value the asset accumulates. A business is no more and no less than the historical and on-going product, of the effort of people - individuals, and teams. That's why we call formalized businesses "companies" - they are a company of people working toward a business objective. Saturday, 13 July 2013. The programme got me...
databasedave.wordpress.com
I’ve moved (already)! | databasedave
https://databasedave.wordpress.com/2011/05/29/ive-moved
I’ve moved (already)! Posted by DB Dave in Uncategorized. I’ve had a domain name for ages now, but never did anything with it. So last week I got my a into g, organised some hosting, and transferred the content from this blog across to my new shiny hosted one, here - curlewis.co.nz. Error: Twitter did not respond. Please wait a few minutes and refresh this page. BI on SQL Server. Conor Cunningham's blog on SQL Server. Glenn Berry's SQL Server Performance Blog. Measure twice, cut once.
databasedave.wordpress.com
Our SQL Server “Denali” experiences – Part 2 | databasedave
https://databasedave.wordpress.com/2011/05/12/our-sql-server-denali-experiences-part-2
Our SQL Server “Denali” experiences – Part 2. Posted by DB Dave in Uncategorized. Where has the week gone? I finally got round to continuing my SQL Denali testing today with very promising results in fact! To give you an idea of the environment (which I brushed over in the previous post) and a little more context, we have a number of SQL servers which sit between our web servers, and our main core databases. These act as read-only search, browse and caching servers for the Trade Me. Full-text related per...
databasedave.wordpress.com
Where am I? | databasedave
https://databasedave.wordpress.com/2011/05/06/where-am-i
Posted by DB Dave in Uncategorized. Well, right now I’m sitting in a hospital room waiting for my wife to come out of surgery – nothing too serious. In the mean time it feels like I’ve got a rather nice little office in fact; a comfy(ish) chair and desk in a private ward with good free wi-fi access, and coffee just down the hall. But I’m not here to write about my current physical surroundings, so, moving swiftly along…. Returns a completely different server name! Nevertheless, the thought of unintention...
databasedave.wordpress.com
Generate scripts to detach/attach all databases | databasedave
https://databasedave.wordpress.com/2011/05/23/generate-scripts-to-detachattach-all-databases
Generate scripts to detach/attach all databases. Posted by DB Dave in Uncategorized. I haven’t had time to do any Denali testing since my last post, so instead I thought I’d share a script I wrote a while ago which simply generates a script to attach one or more databases using their current file paths (and optionally then detaches these databases). EXEC sp detach db @dbname = @database, @skipchecks = 'true'; - change this to false if you want it to update stats before detaching*/ FETCH NEXT FROM dbname ...
databasedave.wordpress.com
Our SQL Server “Denali” experiences – Part 1 | databasedave
https://databasedave.wordpress.com/2011/05/09/our-sql-server-denali-experiences-part-1
Our SQL Server “Denali” experiences – Part 1. Posted by DB Dave in Uncategorized. To start with I had to subscribe the database to a few of our core SQL 2005 transactional replication publications, which was (fortunately) totally uneventful. We use full-text quite extensively, and going from SQL 2005 to Denali meant that I needed to create a new data file and filegroup for the full-text index to use. I didn’t. 1 Identifying unique indexes that aren’t defined as unique « databasedave. Error: Twitter did n...