Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tag
Administration
Refine your search with one of the following additional tags (with number of items):
SQL Server 7, 2000
(324)
Worst Practices
(6)
Performance Monitoring
(2)
Management Studio
(1)
SQL Server 2005
(140)
ADO
(5)
Product Reviews
(2)
MAXDOP
(1)
Configuring
(63)
.Net
(4)
Reviews
(2)
Memory
(1)
T-SQL
(57)
Basics
(4)
Shrink Database
(2)
MemToLeave
(1)
Miscellaneous
(54)
Career
(4)
SQL Puzzles
(2)
OLAP Server
(1)
Strategies
(36)
Editorial
(4)
Storage Management
(2)
OpenXML
(1)
Monitoring
(33)
Naming Standards
(4)
User Defined Function (UDF)
(2)
Operations Manager
(1)
Security
(32)
SQL Server
(4)
Video
(2)
Other
(1)
Programming
(31)
System Development Life Cycle
(4)
XML
(2)
parallelism
(1)
Performance Tuning
(28)
Transaction Log
(4)
2005 Compact Edition
(1)
powershell
(1)
SQL Server 6.5
(24)
Triggers
(4)
Admin
(1)
process
(1)
Backup and Recovery
(22)
Blogs
(3)
ALTER DATABASE
(1)
Profiler
(1)
Reporting Services (SSRS)
(16)
Data Warehousing
(3)
Analysis Services (SSAS)
(1)
Rants
(1)
Stored Procedures
(15)
Distributed Queries
(3)
Architecture
(1)
Scalability
(1)
Advanced Querying
(14)
Editorial - iPod
(3)
attach
(1)
SMO
(1)
Database Design
(14)
Editorial - WMV
(3)
Audit
(1)
SQL Agent
(1)
Basic Querying
(13)
Service Packs
(3)
Best Practices
(1)
SQL Server 2005 - Security
(1)
Installation
(13)
State of the Business
(3)
Bugs
(1)
SQL Server 2005 - SSIS
(1)
Disaster Recovery
(12)
Advanced
(2)
copy_only
(1)
SQL Server 2008
(1)
Visual Basic 6
(12)
Auditing
(2)
Data Types
(1)
SQL Server Management Studio (SSMS)
(1)
Replication
(10)
Backup / Restore
(2)
database size
(1)
SQLServerCentral
(1)
DTS
(9)
Capacity planning
(2)
Declarative Management Framework (DMF)
(1)
System Tables
(1)
SQL-DMO
(8)
detach
(2)
disk space
(1)
telecommuting
(1)
Best and Worst Practices
(7)
DMV
(2)
English Query
(1)
UpdateGrams
(1)
Indexing
(7)
Editorial - MP3
(2)
Excel
(1)
uptime
(1)
News
(7)
Jobs
(2)
Index Management
(1)
Virtualization
(1)
Availability
(6)
Maintenance Plans
(2)
INFORMATION_SCHEMA
(1)
XSL
(1)
Development
(6)
Miscellaneous
(2)
Search for
any
content tagged
Administration
Items 1 to 20 of 644
Next 20 >>
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Read more...
By
Rudy Panigas
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
13,266 reads
Just For Fun: An Impossible Delete
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
Read more...
By
RBarry Young
2009/10/30 (first published: 2008/08/05)
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
30,611 reads
SQL Server 2005 Build List
Build List Updated with Cumulative Update 16 for SP2 and CU 6 for SP3.
Read more...
By
Steve Jones
2009/10/26 (first published: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
79,496 reads
Managing Free Space
A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.
Read more...
By
Paul Els
2009/09/10
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
4,681 reads
How to isolate the current running commands in SQL Server
Examining what has already occurred, while valuable in some cases is most likely not as important as what is currently taxing your server. This being the case, how do you examine the currently executing statement for each of the requests issued against your SQL Server instance?
Read more...
By
Additional Articles
2009/08/14
|
Source:
MSSQLTips.com
|
Category:
Administration
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,581 reads
Different ways to determine free space for SQL Server databases and database files
In this tip we take a look at a few ways to find the current free space within a database, so you can better manage your database files.
Read more...
By
Additional Articles
2009/08/06
|
Source:
MSSQLTips.com
|
Category:
database size
Rating:
Rate this
|
Briefcase
|
3,237 reads
12 Essential Steps After Installing SQL Server
Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.
Read more...
By
Additional Articles
2009/08/03
|
Source:
SQL Server Performance
|
Category:
Installation
Rating:
Rate this
|
Briefcase
|
6,089 reads
Identify last statement run for a specific SQL Server session
The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.
Read more...
By
Additional Articles
2009/07/30
|
Source:
MSSQLTips.com
|
Category:
Administration
Rating:
Rate this
|
Briefcase
|
2,959 reads
Checksum Problems, Choosing the Correct Recovery Model and More
Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
Read more...
By
Additional Articles
2009/07/23
|
Source:
TechNet
Rating:
Rate this
|
Briefcase
|
1,592 reads
SQL Server Memory Configuration, Determining MemToLeave Settings
Tweaking SQL Server memory settings to provide support for managed code.
Read more...
By
John Sansom
2009/07/06
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
7,401 reads
Move SQL Server transaction log files to a different location via T-SQL and SSMS
I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?
Read more...
By
Additional Articles
2009/07/02
|
Source:
MSSQLTips.com
|
Category:
Administration
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,717 reads
Practical Database Change Management (Part 2)
The final article on Change Management examines the more technical aspects of Change Management.
Read more...
By
Additional Articles
2009/06/25
|
Source:
SQL Server Universe
|
Category:
System Development Life Cycle
Rating:
Rate this
|
Briefcase
|
2,345 reads
Practical Database Change Management (Part 1)
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change
Read more...
By
Additional Articles
2009/06/24
|
Source:
SQL Server Performance
|
Category:
Administration
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,950 reads
SQL Server 2005 Build List
Build List Updated with Cumulative Update 16 for SP2 and CU 6 for SP3.
Read more...
By
Steve Jones
2009/10/26 (first published: 2007/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
79,496 reads
One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...
Read more...
By
Andy Warren
2009/06/16
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,229 reads
SQL Server Profiler Part 2: Custom Templates and Saving Data
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
Read more...
By
Jack Corbett
2009/06/15
|
Source:
SQLServerCentral.com
|
Category:
Profiler
Rating:
|
Discuss
|
Briefcase
|
2,763 reads
Determining the source of full transaction logs
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
Read more...
By
Additional Articles
2009/06/15
|
Source:
SearchSQLServer
|
Category:
Transaction Log
Rating:
Rate this
|
Briefcase
|
3,053 reads
Tracking and Reporting Database Growth
An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.
Read more...
By
Lokesh Gunjugnur
2009/06/02
|
Source:
SQLServerCentral.com
|
Category:
Monitoring
Rating:
|
Discuss
|
Briefcase
|
9,255 reads
Moving Database Files Detach/Attach or ALTER DATABASE?
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
Read more...
By
Jonathan Kehayias
2009/05/27
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
12,580 reads
How to find out how long a SQL Server backup took
Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.
Read more...
By
Additional Articles
2009/05/22
|
Source:
MSSQLTips.com
|
Category:
Backup and Recovery
Rating:
Rate this
|
Briefcase
|
2,361 reads
Items 1 to 20 of 644
Next 20 >>
Most popular
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Read more...
By
Rudy Panigas
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
13,266 reads
What SQL Statements Are Currently Executing?
This article describes a utility that allows you to identify what SQL statements are currently executing.
Read more...
By
Ian Stirk
2008/10/28
|
Source:
SQLServerCentral.com
|
Category:
DMV
Rating:
|
Discuss
|
Briefcase
|
28,363 reads
Just For Fun: An Impossible Delete
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
Read more...
By
RBarry Young
2009/10/30 (first published: 2008/08/05)
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
30,611 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use