SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Database Administration Rss

Search for any content tagged database administration

   Items 1 to 9 of 9   


By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,502 reads

Changing Data Types on Large Tables: The INT to BIGINT Conundrum

Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.  Read more...
By Additional Articles 2018/03/13 | Source: SimpleTalk | Category: database administration
Rating:  Rate this |   Briefcase | 9,115 reads

Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert

In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.  Read more...
By Additional Articles 2018/03/12 | Source: MSSQLTips.com | Category: delimiters
Rating: (not yet rated)  Rate this |   Briefcase | 3,178 reads

How to Survive as a Lone DBA

Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade. While many DBAs work on teams instead of alone, she has great advice for all.  Read more...
By Additional Articles 2018/02/27 | Source: SimpleTalk | Category: dba
Rating: (not yet rated)  Rate this |   Briefcase | 4,313 reads

How to Suck at Database Administration

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,487 reads

Using SQL Server and R Services for analyzing DBA Tasks

Article shows how R Services can help database administrators with their daily work   Read more...
By Tomaž Kaštrun 2017/02/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,402 reads

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.  Read more...
By Kenneth Igiri 2016/11/30 | Source: SQLServerCentral.com | Category: space management
Rating: |  Discuss |   Briefcase | 1,072 reads

3 Built-In Technologies for Centralizing SQL Server Administration

DBAs can be more effective in managing their workload by centralizing their procedures. There are several features of SQL server that can be harnessed to this end: PowerShell is only part of the solution: there is also Central Management Server, Master /Target Agent and the Remote Server Administration Tools. It's time to work out your objectives and pick the most suitable technologies to meet them.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,605 reads

Are you bad enough to join the DBA Team

If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.  Read more...
By Press Release 2014/09/10 | Source: SQLServerCentral.com | Category: database administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,363 reads
   Items 1 to 9 of 9