Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and their self-esteem. In casual usage, however, it usually appears in the adjectival form, “egotistical” (most often followed by “jerk”). You don’t need to be a jerk to be a DBA; humility is important. However, ego is important […]
2021-06-26
287 reads
Of all the valuable attributes of a DBA, from passion to humility to practicality, perhaps one of the most important attributes may turn out to be the most seemingly nebulous: foresight. According to Free Dictionary, foresight is the "perception of the significance and nature of events before they have occurred". Foresight does not come naturally to most people, as the […]
2021-05-15
312 reads
I started in the early days of SQL Server, when having a gigabyte of disk storage was unheard of, much less a gigabyte of RAM. My watch has more storage space than the mainframe we replaced with an early version of SQL Server years ago. The technical possibilities and amounts of data we are capable […]
2020-02-15
130 reads
An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]
2020-02-01
183 reads
Recently, there was a prominent film director fired from directing an episode in a very entertaining and profitable movie franchise. His firing was for tweets he made that were in very bad taste. And bad doesn’t begin to cover it, they were about topics that were universally despicable. What made this interesting was not that […]
2018-09-10
60 reads
Recently, as I was doing some work for the upcoming PASS Summit, a question popped in my head: “Why am I doing this?” It reminded me of the time when I was young (and idealistic). I went to the leader of a non-profit group asked about making it my permanent vocation. The leader looked at […]
2018-07-30
71 reads
One of the greatest things that has arisen in the past 10 years or so is a veritable stream of great conferences for people to learn how to write better software, many of them low cost or even free. In the Data Platform community, we have had nearly 800 free SQL Saturday events around the […]
2018-06-18
45 reads
In order to be great, you need to have an idea what great is. A quote I use in every one of my database design presentations is by one of my non-technical inspirations, C. S. Lewis. The quote is from his book, An Experiment in Criticism. “There are no variations except for those who know […]
2018-02-26
39 reads
2017-08-28
125 reads
I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]
2017-05-01
47 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers