geekswithblogs.net
Darren Gosbell [MVP] - Random Procrastination
http://www.geekswithblogs.net/darrengosbell/Default.aspx
Darren Gosbell [MVP] - Random Procrastination. Business Intelligence, SQL Server, .Net, Powershell and MDX Madness. Tuesday, July 26, 2016 #. DAX Studio 2.4.1 Released. The next version of DAX Studio. Has just been released. You can download this release and read the release notes here. Some of the highlights of this release are:. This will swap between using comma delimiters. And semi-colon style delimiters. Short Url: http:/ wblo.gs/mjA. Posted On Tuesday, July 26, 2016 6:37 AM. Saturday, June 4, 2016 #.
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
SQL Breakfast | databasedave
https://databasedave.wordpress.com/2011/05/13/sql-breakfast
Posted by DB Dave in Uncategorized. This morning we (i.e. my team and I) tried something we’ve spoken about for some time, but haven’t got around to doing until now; a Tech Breakfast . So I stopped at a bakery on the way to work to pick up some yummy baked goods, and all 3 of us piled into a meeting room at 07:30 with our individual beverage of choice in hand, and watched Kimberly Tripp’s. MCM presentation and demo. All in all not a bad way to kick off a Friday. BI on SQL Server. Measure twice, cut once.
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...
databasedave.wordpress.com
Do you want a job? Then don’t do this… | databasedave
https://databasedave.wordpress.com/2011/05/17/do-you-want-a-job-then-dont-do-this
Do you want a job? Then don’t do this…. Posted by DB Dave in Uncategorized. We’re always looking for good database folk (i.e. DBA’s or database developers). Its fair to say that the pickings have been pretty slim for some time now, but we still get a constant trickle of applications that make me want to laugh (and sometimes cry). . Here are a few pain-points I’ve come across recently in our recruiting efforts:. Dnt us txt-spk in yr application. Hint, it doesn’t have an x in it). I’m all for you customis...