What's the routine of a normal DBA job? Too many people work alone and don't get feedback or comments on what they should be doing from other DBAs. Andy Warren has jotted some notes down on what you should make sure is a part of your job.
Learn how to perform administrative tasks by accessing the SQL Server 2005 WMI Providers using Window PowerShell.
Learn how to reorganize permissions in SQL Server 2005 in a multiple database environment.
SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the second part in a series looking at what these changes do and how to use them.
In a new DBA role, Daryl Quadros brings us a list of the first tasks you should perform.
With WPF, you can perform data manipulation using Microsoft® .NET Framework code, XAML, or a combination of both.
The author explains an application development approach advocated by many proponents of agile application development that can cause future problems for developers, while potentially sacrificing the integrity and reusability of the data.
A quick workaround from a longtime community member that helps you prevent the LF/CR from being lost if you copy scripts from the code tags in your posts.
SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the first part in a series looking at what these changes do and how to use them.
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers