Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]
Discover the future of DevOps! Join Microsoft MVP Kendra Little to see Redgate's recent innovations in action and give you a picture of where Database DevOps is going, and why.
Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.
This month's T-SQL Tuesday had lots of posts that look at automation from the DBA perspective, rather than the software developer.
Today Steve wonders if companies ought to support remote work better with other benefits.
Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete the duplicate record?
When you're developing a database, the pressure is on to get something that works, using an efficient algorithm. When you are getting close to a release candidate, however, there are some programming habits that must be removed from the code, because they can cause unexpected performance problems. In this article, you'll learn how to detect and remove one such problem: reliance on implicit datatype conversions in your queries. We'll use a combination of plan cache queries, extended events, and SQL Monitor.
Learn how to correct an error that is overloading SCOM by fixing an SPN.
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP Kapuk Kamal Telpon/WA:08213111185 No. 1A, Jl. Kapuk Kamal Raya Blok DEF, Kamal...
BCA KCP Kosambi Telpon/WA:08213111185 Komp. Perum Kosambi Baru Jl. Nusa Indah Tengah Blok A,...
BCA KCP Taman Palem Lestari Telpon/WA:08213111185 Komp. Perum Jl. Taman Palem Lestari No.C5 No....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers