High Availability - Sample Chapter
Apress has been generous enough to provide us with a sample chapter from their book on SQL Server 2005 High Availability by Alan Hirt.
2007-10-03
1,418 reads
Articles
SQL 2000 DBA Toolkit Part 2
After introducing us to a comprehensive encryption toolkit in part I, Michael Coles delves into Regular Expressions and the functions included in the toolkit for use on SQL Server 2000.
2007-10-03 (first published: 2006-04-20)
21,318 reads
2007-10-03
806 reads
The PASS 2007 Round Up
A list of articles and comments, including some pictures, from the 2007 PASS Summit in Denver.
2007-10-03
1,193 reads
The Troubleshooting List
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
2007-10-03
4,596 reads
Access to SQL Server: Linking Tables
SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to
2007-10-02 (first published: 2005-02-23)
45,499 reads
Aggregate Queries
They are a basic type of query that every DBA and developer should be able to write, but aggregates are sometimes misunderstood and result in strange behaviors and results. Kathi Kellenberger brings us a tutorial on what aggregate queries are and a few hints on how to become more proficient at writing them.
2007-10-02 (first published: 2005-12-19)
37,462 reads
An Introduction To Linked Servers
Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.
2007-10-02 (first published: 2004-06-02)
48,033 reads
Auditing with SQL Profiler
SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.
2007-10-02 (first published: 2004-09-01)
35,413 reads
Auditing Your SQL Server - Part 2
This article expands Steve Jones' look at ways to audit changes to your data by building mirror tables.
2007-10-02 (first published: 2003-03-17)
22,360 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers