I use Redgate - it's not not very invasive on your server and it has a few really cool features , my favourite is that it looks at patterns of...

I haven't heard of this problem! Can you post more about web apps getting compromised on an intranet?

edit: I would think if you had attackers get past the firewall...

the only thing that I can advise is to check all indexes are in place on both servers (maybe one is missing) - then look at your server settings -look...

if you delete data from a heap, the space might not be released and the pages remain allocated to the table, but unused

the problem gets worse, the more times you...

Fair enough, these points I can accept. A good report designer needs to be bought for VS to make it usable for such purposes. Access doesn't do anything like...

I know this is blindingly obvious, but put a clustered index on the table (maybe on create_date) - then recompare

you have no idea how many issues you can get into...

quite interesting - I've been using a low power server to do my DR testing - my databases get restored regularly but I've avoided checkdb purely on the amount of...

@rod - where is the double facepalm emoji when you need to show your frustration at excel users?

I'm glad you are looking at devops - if you haven't then get...

I can't remember who it was (I think it might have been itzik ben-gan or Michael hotek) who presented a chess game in management studio - this was back at...

30 across our "zoo" of applications (they are all named after animals) - I have no idea how many - maybe 40 or so access frond ends (I still call...

but how do you manage version control and merge changes for multiple developers?

only one person can work on it at a time - and there is no way (that I...

we have the same system - about 1000 ish people log in to many different access clients (stock control, despatch control timesheets etc)  - these are split across multiple shifts...

• This reply was modified 5 years, 10 months ago by MVDBA (Mike Vessey).
• This reply was modified 5 years, 10 months ago by MVDBA (Mike Vessey).

I think I might take your offer up on the article

I would add that getting to a conference or even trying to speak can be career changing.

I attended Data relay...

We use the Access runtime on a terminal server as the front end, with a SQL Server back end. Each of the 100 users has their own copy of...

I have never done any development on Access, but I have sure been called to consult for a lot of Access applications. On many occasions, I have had the...