Viewing 15 posts - 1 through 15 (of 921 total)
I've worked for companies that like to have public executions of those that have made mistakes (I exaggerate, but only slightly) and then announce to the world that all is...
September 29, 2021 at 3:25 pm
Any newly-elected leader should have to watch the entire West Wing series. That was an amazing show.
January 7, 2021 at 4:24 pm
That reminds me of a poster I saw last week.
"Kids are like farts - mine are amazing and yours disgust me".
January 6, 2021 at 7:55 am
In a two-node AG you should have Primary and a sync secondary. As you have said, failover is easy because the secondary is sync. When you failover, both nodes will...
October 29, 2020 at 11:22 am
Index usage can change within a database due to several factors, but part of it can be due to the data changing and the statistics no longer reflecting the true...
October 29, 2020 at 10:24 am
I'm with Grant on this. Certifications on their own aren't viewed well - experience is always the main focus. However, studying for the certificate will give you some direction and...
September 10, 2020 at 1:09 pm
You're telling me that 'Error' isn't giving you enough information? I'm shocked.
I know you know your stuff, but just in case the obvious has passed you by (I'm an expert...
August 7, 2020 at 12:37 pm
When my step-sons lived with us, I wouldn't go into their rooms without a full haz-mat suit and checking the Basalisk under the bed had been fed.
I'm in the strangely...
August 7, 2020 at 10:33 am
I've used the LinkedIn Premium, a long time ago and found it to be a bit of a waste.
It lets you send more messages and get better details of searches...
August 7, 2020 at 7:16 am
Extended Support of SQL 2012 expies in two years, so I don't see why it shouldn't be supported on Windows 2019.
Of course, the best option is to try this on...
July 31, 2020 at 2:27 pm
For maintaining a copy that is allowed to be slightly behind the 'live' instance, I would go for transactional replication.
It can take a little practice to set up and maintain...
July 28, 2020 at 1:48 pm
It is a bad example to use for that type of DB engine, but as the article was aimed at RDBMS people they had to use something that could be...
July 10, 2020 at 10:30 am
You can't have the same database with different names across an AG. When you add a database to an AG, there are no options to cater for it having a...
June 30, 2020 at 10:09 am
Lynn's post leads on to another aspect of Senior DBA - dealing with people.
The higher you climb up the food-chain, the more your people skills become important. You have to...
June 24, 2020 at 10:09 am
Could you have another table that held this aggregated data? At the start of each month a process gets the details from the previous month's data and stores it in...
June 23, 2020 at 12:48 pm