SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
2009-08-24
258 reads
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
189 reads
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
804 reads
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
208 reads
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
2009-08-19
181 reads
To mentor or to protect data, what is the role of the DBA? A guest editorial from Matt Simmons.
2009-08-18
219 reads
The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?
2009-08-17
339 reads
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
2014-02-17 (first published: 2009-08-17)
240 reads
Sharing how you do your job can help others be better at theirs. This Friday's poll asks a technical question. How do you determine which fillfactor to use.
2009-08-14
461 reads
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
2009-08-13
103 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