Viewing 15 posts - 61 through 75 (of 6,041 total)
Yeah, automatic touchless transactions can make your life easy - until you have to deal with fraud. It could spoil someone's vacation or holiday.
Perhaps we could design tap cards in...
September 25, 2024 at 1:16 pm
Historians in the future, who look at archival copies of today's "news" websites, will laugh at all the stupid memes and click bait ads appearing in the margins. Also, what's...
September 23, 2024 at 6:06 pm
The fact that most input parameters are defined as NVARCHAR (4000) is evidence that the original code was generated by an ORM.
My guess is that the developers were instructed to...
September 20, 2024 at 1:33 pm
We have about 900 Point Of Sale locations across the US running SQL Server Express on workstations and SSD drives. So, the disks are not invisible. If the event of...
September 9, 2024 at 2:46 pm
This thing about asking for an improbable mix of skills seems far more common for third party recruiters. Not only do these shops pad job descriptions, but they pad resumes...
September 5, 2024 at 5:40 pm
Another suggestion is: don't the table accumulate 10s or 100s of millions of rows. Use a job to truncate off-hours on a daily or weekly schedule.
For example, on some servers,...
September 3, 2024 at 2:29 pm
when you already have partitions, you could simply do a
TRUNCATE TABLE dbo.big_stuff WITH (PARTITION(1 TO $partition.pf_big_stuff_function(date_key)));
I leverage partitions to truncate data on large tables as well,...
September 3, 2024 at 2:21 pm
Steve, I was just thinking yesterday that I want to know more about Kafka. It's leveraged by one of the application teams to replicate a subset of tables, columns, and...
August 28, 2024 at 1:46 pm
Even with the rise of cloud hosting and AI, my belief is that junior level developers and database/server administrators will always be in demand - but just not in the...
August 27, 2024 at 3:12 pm
I've found ChatGPT to be most useful when asked to summarize the tools and steps involved in implementing a process.
August 26, 2024 at 6:33 pm
The vast majority of folks in IT are not scientists or even engineers, and I'm not sure there is really any broad market demand for it. Most organizations are moving...
August 23, 2024 at 2:35 pm
Well... Do that for 100+ attributes and you need 100+ indexes.
And still you can't use more than one index when searching for
WHERE treatment = @treatment AND bp = @bp...
August 13, 2024 at 3:24 pm
If you watch the video, there are a lot of telemetry things. I don't think they send any video, but these stores might not have great bandwidth anyway.
POS transactional...
August 12, 2024 at 8:06 pm
I'm surprised a typical Chik-Fil-A would be generating a massive amount of telemetry and operational data, but in rural locations, it's probably constrained by lack of broadband internet.
I suspect the...
August 12, 2024 at 3:27 pm
Where I work, our DBA team developed a "system outlier" report that's similar to Brent Ozar's sp_blitz.
It's a powershell script on a daily schedule that polls each server, running 100+...
August 12, 2024 at 2:11 pm
Viewing 15 posts - 61 through 75 (of 6,041 total)