The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. In this article, Greg Larsen explains the details and how to configure the SQL Server error log.
2021-01-08
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.
2021-01-06
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten tips to help managers attract and retain DevOps talent.
2021-01-04
Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.
2020-12-30
Cross-server references keep cropping up as a problem for development and build. Phil Factor demonstrates how using linked server 'aliases' can get around these issues, even if the individual databases use four-part references within the code rather than synonyms.
2020-12-24
Deep Learning theories have been around for many decades, but solutions have not always been practical due to hardware constraints. In this article, Shree Das explains how GPU Acceleration can help organisations take advantage of Deep Learning to speed up training of neural networks.
2020-12-24
987 reads
Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size.
2020-12-21
Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.
2020-12-17
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.
2020-12-15
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers