Viewing 15 posts - 916 through 930 (of 1,993 total)
I know it sounds simple, but I use Amazon AWS and Azure servers for my home lab
I Have a work provided MSDN and Amazon account. I can log on using...
MVDBA
August 15, 2019 at 9:02 am
Once the system is in production, it becomes very hard to change anything, from security to code, without lots of testing and approvals. I find that often trying to work...
MVDBA
August 15, 2019 at 8:33 am
if you set your profiler trace to write to a table rather than a file but don't execute it, ...just script it out
once you create the trace in script form...
MVDBA
August 13, 2019 at 3:35 pm
profiler might be better for this since you want the sql text
i'm assuming it's a data change not a structure change you are auditing? if it's a structure (DDL) change...
MVDBA
August 13, 2019 at 2:35 pm
I've found with Transactional replications I've measured our on premise database in England replicated to an azure database in Ireland at normally 6 seconds
1-2 seconds from publisher to distributor and...
MVDBA
August 13, 2019 at 11:10 am
I tried this once using mirroring with snapshots... the report started the snapshot which worked really well.
except.... we had to run 2 16 core enterprise editions. (you couldn't run the...
MVDBA
August 12, 2019 at 10:55 am
for 20 seconds latency I cannot see anything but transactional replication working....
Grant - feel free to give me another option as I'm out of ideas for a system to get...
MVDBA
August 12, 2019 at 8:08 am
That something compiles or does not throw a syntax error is hardly the same thing as unit testing. That is the bare minimum lazy developers do to say...
MVDBA
August 5, 2019 at 7:58 am
Excellent post, Steve. What we need now is someone that's an expert in QA or an expert system designer to provide people that write requirements with knowledge and techniques...
MVDBA
August 5, 2019 at 7:45 am
Banem.. you are lucky, I grew up on Zilog Z80, 6800 and 8502 assembly with 8K of RAM in assembly (Hex coding). when they let me loose on turbo pascal...
MVDBA
August 2, 2019 at 1:57 pm
With how bad some of our existing legacy code base is, fresh hardware wouldn't make a dent in it.
I would love to be in the utopia where the only thing...
MVDBA
August 2, 2019 at 9:05 am
What I'm really getting at is that a lot of Developers that I've worked with at other companies think that they don't need to test their own code as they...
MVDBA
August 1, 2019 at 7:57 am
What? People use hardware machines in production? We need to keep the underlying hardware on compatible chipsets so that we can move virtual machines around.
So true … but some...
MVDBA
July 22, 2019 at 1:50 pm
Given that most medium to large companies predominantly use HP... you don't have much of a choice.
My antique home PC is an AMD Athalon 3400 and it has served me...
MVDBA
July 22, 2019 at 8:04 am
Hi prettsons
that's cool info for anyone facing the same issue. I did all of those things but at checkdb stage I got the error message I mentioned, as I posted..
in...
MVDBA
July 4, 2019 at 9:09 am
Viewing 15 posts - 916 through 930 (of 1,993 total)