Viewing 15 posts - 16 through 30 (of 925 total)
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
... worse, my Monday morning ritual is to leave early and grab a mcdonalds breakfast - they were closed 🙁
Not sure if you like cooking, but it's something...
March 23, 2020 at 2:52 pm
Now you've gone and done it - I need to boil my laptop now.
March 17, 2020 at 10:58 am
I had a look at this myself, a few weeks ago - because log backups can be taken from any of the AG servers, yet differential backups can't. This is...
February 10, 2020 at 2:47 pm
A little left-field, but a snapshot backup just before the log file ships and then running a data compare (such as redgate's SQL Data Compare) between the snapshot and the...
December 10, 2019 at 3:46 pm
I worked at a place where the slightest mistake was met with derision, shouting and a generally abusive atmosphere. On the last day of my probation period I pulled the...
December 6, 2019 at 9:59 am
The Update Failed message reminds me of when I was a database developer some time ago working with Oracle, and the DBA's there programmed some automated job that would...
October 31, 2019 at 9:22 am
I've found that as I get older I worry less about future employment opportunities, as my experience and confidence increases. Because, I still find the role of a DBA interesting...
October 14, 2019 at 11:21 am
Viewing 15 posts - 16 through 30 (of 925 total)