Everyone has a set of handy utilities and tools that they use with their SQL Server, but sometimes convincing an employer to purchase tools is hard. Longtime DBA David Bird brings us a list of the tools he likes to use and are FREE.
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
An proposal about using simple server name resolution and INI files to make a DTS package portable.
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
On my database server I have my databases set to the full recovery model, but the transaction logs get quite big, so I am issuing a BACKUP LOG with NO_LOG. I am not exactly sure if this causes any issues, but I know that I am able to free up space in my transaction log and shrink the file. Is this the correct way to handle this situation?
One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their order is important. For example, values lying along a time line. The solution is actually quite simple, but not immediately obvious.
What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening.
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Daan Mogot No.KM. 11, Wisma SSK, Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...
Jl. Pesanggrahan Jl. Puri Kencana No.28 29, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers