Navigationless Database XML: Hierarchical Data Processing
Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.
Bread and Butter of SQL Server DBA - Part 2
Continuing on with his series on the basics of being a DBA, the MAK brings us an article that shows how to restore a backup to a new database.
Modifying Data - SQL School Video
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
The Relational Manager
Managing DBAs can be a challenge for both sides. Steve Jones talks a bit about some of his relationships with managers and the trouble that sometimes occurs.
Resource Governor in SQL Server 2008
This article describes how Database Administrators can manage SQL Server workload and critical system resource consumption using Resource Governor in SQL Server 2008
Database Audit Specifications in SQL Server 2008
This is the final article of a three part series on Auditing in SQL Server 2008. This article shows how to setup a Database Audit Specification.
Managerial Relations
Steve Jones talks a bit more about the employee manager relationship in this turbulent times.
Managerial Relations
Steve Jones talks a bit more about the employee manager relationship in this turbulent times.
Managerial Relations
Steve Jones talks a bit more about the employee manager relationship in this turbulent times.
Recovery
How do you recover small pieces of data from a 16GB database? New author from Australia, Graham Okely, brings a story from the real world of data recovery at his employer.
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers