Enterprise Manager
|
120 results found, displaying items 1 - 20
|
SQL Server 2005 Management Tools
The release of SQL Server 2005 brings lots of changes in every aspect of the product. Join Kalen Delaney and Ron Talmage on an exploration of the new management tools.
SQL Server Magazine
—
Kalen Delaney
, et al.
Proactive Alerting Prevents Downtime
A reader highlights his favorite product: SQLCentric.
SQL Server Magazine
—
Dawn Cyr
Resizing a Column in a Large Table
Microsoft's Richard Waymire says your best bet for changing the size of a column in a large table is to use the ALTER TABLE command.
SQL Server Magazine
—
Microsoft's SQL Server Development Team
Using T-SQL to Automatically Move Tables
You can automate the process of moving a table--not just its indexes--to a different filegroup using T-SQL. Here's how!
SQL Server Magazine
—
Brian Moran
Anatomy of a Performance Solution
Follow the solution to a real-world SQL Server performance problem from identification through investigation to a happy conclusion.
SQL Server Magazine
—
Kalen Delaney
For Your Eyes Only
Concerns about legislation regarding personal privacy have DBAs searching for solutions that SQL Server doesn’t support natively. With this example solution, you can secure your database row by row and satisfy the most stringent privacy requirements.
SQL Server Magazine
—
Sean Maloney
Heterogeneous Management Tools
SQL Server’s built-in management tools are powerful, but they have limitations. However, third party tools can make up the difference. Here are three heterogeneous management tools to manage SQL Server, Oracle, and DB2 databases.
SQL Server Magazine
—
Michael Otey
SQL Server Magazine UPDATE, April 8, 2004--Data Modeling
Brian Moran talks about what he wants to see in a data-modeling tool from Microsoft, learn about viewing procedures in Enterprise Manager, get the results of our latest instant poll, and more!
SQL Server Magazine
—
Various Authors
Publishing SQL Server in Active Directory
By adding SQL Server to Active Directory, you can help clients locate databases quickly, easily, and securely. AD's Service Publication and lookup let you keep server and database information up-to-date in a dynamic environment--or several of them.
SQL Server Magazine
—
Chad Miller
54 Administration Tips
Got a question about managing or tuning your SQL Server system? Check out this array of top tips--we've got the answers you're looking for.
SQL Server Magazine
—
Various Authors
[February 17, 2004]
|
|
54 More Administration Tips
Here are even more of the best DBA tips from our first 5 years.
SQL Server Magazine
—
Various Authors
Crossing the Line: Ownership Chains
A broken link in a cross-database ownership chain can put your data at risk. Understanding SQL Server 2000’s security model can keep your data safer now and prepare you to take advantage of security enhancements in Yukon.
SQL Server Magazine
—
Kalen Delaney
Inside ALTER TABLE
The ALTER TABLE command can make many changes at once and still gives better performance than dropping and recreating a table. Find out how it all works.
SQL Server Magazine
—
Kalen Delaney
[November 21, 2003]
|
|
Developer .NET UPDATE, November 21, 2003
Yukon, the next release of Microsoft SQL Server, includes major changes, such as the replacement of SQL Server Enterprise Manager with SQL Server Workbench, integration with the Windows .NET Framework, and enhancements in ADO.NET.
Windows IT Pro
—
Various Authors
Queueing Up
If you need to maintain multiple database servers at multiple sites and synchronize all the data, SQL Server has a solution to make your job easier--SQL Server’s Transactional Replication with Queued Updates can help.
SQL Server Magazine
—
Sameer Dandage
Dangers of Enabling Cross-Database Chaining
Cross-database chaining is a new configuration option in SP3 that you can enable for individual databases by using the sp_dboption command. Cross-database ownership chaining opens up several serious security holes and should be avoided.
SQL Server Magazine
—
Brian Moran
Top Yukon Features
Microsoft has had plenty of time to add many new features to SQL Server’s next release, code-named Yukon. Here are seven important features that they have announced for Yukon.
SQL Server Magazine
—
Michael Otey
Hiding DTS Packages Names
Would you like to know how to hide Data Transformation Services (DTS) packages from a certain set of Enterprise Manager users?
SQL Server Magazine
—
Brian Moran
Dealing with a Task-Pad Error
Do you regularly get an annoying error message from Enterprise Manager when you try to view database information through the Task Pad view?
SQL Server Magazine
—
Brian Moran
Registering the Same Instance Multiple Times
Registering the same physical instance of SQL Server more than once might be convenient sometimes.
SQL Server Magazine
—
Brian Moran
|
|