3 Tips On Being A Rookie DBA
New author Greg Bates brings us a few tips for those of you new to being a DBA or without much experience.
2009-01-26
14,623 reads
Articles
Auto notification for failover of a server and restart of SQL Server services
Learn how you can monitor the SQL Server instances for failover of a cluster or a restart.
2009-01-26
3,621 reads
Restore a SQL Server 2008 Database into SQL Server 2005
You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.
2009-01-26
4,000 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
477 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
757 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
474 reads
Find and Generate Missing Values in an Access Table
Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.
2009-01-23
1,912 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've had a good discussions about networking since I wrote the first two parts, with a focus on the value of networking.
2009-01-23
1,698 reads
Understanding Logging and Recovery in SQL Server
Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Paul Randal gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database.
2009-01-23
3,187 reads
Using Views and Synonyms for Abstraction - SQL School Video
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,415 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers