Viewing 15 posts - 31 through 45 (of 577 total)
I have always kep Visio diagrams of our databases as part of the systems documentation, using the reverse engineering feature of Visio to create them.
However Microsoft have ruined Visio...
September 11, 2015 at 1:17 am
I ticked 4 boxes to cover my job. DBA for both development and production, SSxS developer and ASP.NET developer
That's this month - in a month or two it could be...
September 3, 2015 at 1:05 am
Thanks all, especially Beatrix and Stuart. Bristol and Bath are readily commutable and Swindon too. Even Southampton isn't really too far. I'll look for the book and peruse the websites....
August 18, 2015 at 6:52 am
I posted this about career options a while ago and just my luck, it didn't even make the daily email and hasn't generated a single reply, but now the...
August 17, 2015 at 9:43 am
Have you installed the sql server client tools, notably the visual studio shell part because that is what turns ordinary visual studio into the version for sql ssis, ssas and...
August 13, 2015 at 1:03 am
Because SSIS (2008) only writes to one system table we decided to write our package logs to flat files on the database server then add a step to import those...
July 29, 2015 at 1:31 am
Having worked in a similar small situation and now in a slightly larger but more regulated organisation, I definitely prefer the latter. We aim to cover each other's tasks so...
July 2, 2015 at 1:30 am
When you divert records on error (with a red linking line between transformations) then the last two columns available are error code and error column. You can google the error...
July 1, 2015 at 1:29 am
As an IT pro and graduate, I've been involved in the recruitment of programmers and the very first requirement on the job spec. is a degree or HND or equivalent...
July 1, 2015 at 1:12 am
If copying a scheduled job, delete the line that begins "@schedule_uid= " and the preceeding comma as it can't create two schedules with the same id.
If it's for backups, have...
June 29, 2015 at 6:01 am
It works both ways - my job title is DBA but as well as managing the backups/restores, databases and security and query tuning etcI also do BI development, loads of...
June 29, 2015 at 5:51 am
Could you try getting management help to introduce some new tools or even just new tricks for the devs with the selling pitch that these are going to speed up...
June 24, 2015 at 2:05 am
I was doing some tuning on a database a couple of days ago and added indexes as there were none. Came back the next day and they'd vanished!
The developers'...
June 11, 2015 at 12:59 am
We do lots of csv import and have found that | isn't a good delimiter character as it can easily be mistyped into data when hitting the shift key or...
June 2, 2015 at 7:19 am
We do this on two or three systems - backup live between 6pm and midnight then restore that backup to test server from 4a.m. onwards. It's a good way of...
June 2, 2015 at 6:57 am
Viewing 15 posts - 31 through 45 (of 577 total)