Viewing 15 posts - 1 through 15 (of 918 total)
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
If nobody comes back with an answer, there is a similair issue on a Stack Overflow question:
which also references https://serverfault.com/questions/816053/ssrs-error-about-report-server-database-version-after-hotfixing-sql-the-found-v/893739#893739
June 22, 2020 at 10:51 am
Yeah, I think I've paid too much attention to articles that say they're using Regex within SQL, where in reality they're just using some clever 'LIKE' coding and patindex.
June 12, 2020 at 9:45 am
Oh FFS - 'NOT LIKE'!
Seriously - I stared at that code and that never occurred to me...
I'm spending too much time trying to be clever.
June 7, 2020 at 11:09 pm