Viewing 15 posts - 151 through 165 (of 6,041 total)
Do we really need to keep the entire database in memory? It depends on what problem you're trying to solve.
We already have in-memory option for tables, which is good for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 6, 2023 at 5:46 pm
Definitely have a profile on LinkedIn and read matching job descriptions that land in your email - even if you are in no way considering a move. Do this to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2023 at 3:43 pm
Daylight Savings Time makes winter days extra short and summer days extra long. Aside from traditional farming, that's also useful for the construction and vacation industry.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2023 at 1:12 pm
Yes, TLS enabled on the client by itself will encrypt the data and SQL commands sent between client and server. SQL Server at install time will automatically create a certificate...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2023 at 7:48 pm
I just export the plan and its consumption statistics from the plan cache.
1 file with all consumption details, 1 .sqlplan file per plan
Yes, we can get plan from either...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 27, 2023 at 5:58 pm
This is an interesting discussion in the context of database object deployments.
SQL Server will take schema stability locks when running a SELECT query (or a DML, DDL, etc operation) which...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 26, 2023 at 3:32 pm
A Computer Science or Engineering degree definitely gives someone an advantage when they are starting a career in IT - not just from the perspective of looking good on paper...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 20, 2023 at 1:49 pm
Elon Musk says the universe we live in is a computer simulation. If that's true, then God would be the SYSADMIN ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 17, 2023 at 1:50 pm
Steve, your point about keeping a copy of the incident response letter offline reminded me of something I read a while back. It's a lot easier to apologize for a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 4, 2023 at 2:27 pm
"..I'm especially surprised how many have performed lift-and-shift migrations to IaaS services after a mandate by management. I'm also not surprised that many customers find they're spending too much, and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 18, 2023 at 6:39 pm
".. However, using data to try and improve your efficiency has a downside. It can lead you to a very narrow focus in your approach .."
A good example of this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 13, 2023 at 1:16 pm
I think folks are learning that 99.999 uptime is expensive, and even if you pay for it, there are operational reasons why the database will be offline on occasion anyhow.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 27, 2023 at 6:03 pm
I've used INSERT.. DELETE.. OUTPUT.. in the past to implement archival of log tables. A daily scheduled job simply deletes where datetime < X days, and the deleted rows are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 27, 2023 at 5:58 pm
I remember back when LINQ and Entity Framework were going to write all our queries for us, but it didn't pan out that way.
It's sort like saying that self serve...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 1, 2023 at 3:22 pm
At this point, ChatGPT answers a broad range of questions based on the vast public domain of information and consensus of opinion that exists in the internet. It is impressive,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 27, 2023 at 1:45 pm
Viewing 15 posts - 151 through 165 (of 6,041 total)