DBA Basics

Mind your Database Ps and Qs

• by Louis-Davidson-(@drsql)

• SQLServerCentral.com

• Editorial

• Editorial

Louis Davidson explains why a little database courtesy goes a long way.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2015-11-16

159 reads

• Discuss

Script All Server Level Objects to Recreate SQL Server

• by Additional Articles

• MSSQLTips.com

• objects

• Article

Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.

2015-06-19

3,975 reads

Traits of a DBA - Part Two – The Personal Side of a DBA

• by Additional Articles

• Database Journal

• DBA Basics

• Article

A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.

2014-07-22

12,741 reads

DBAs Checklist for Designing and Reviewing SQL Server System Architectures

• by Additional Articles

• MSSQLTips.com

• Article

In this tip, Sadequl Hussain will try to list a few areas DBAs need to cover when they are designing new systems or reviewing proposed solutions.

2014-02-27

5,421 reads

Great DBAs do <blank>

• by Tony Davis

• SQLServerCentral.com

• Editorial

• Editorial

We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2013-06-24

252 reads

• Discuss

What Counts for a DBA: Laziness

• by Louis-Davidson-(@drsql)

• SQLServerCentral.com

• Editorial

• Editorial

Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2013-03-25

274 reads

• Discuss

RE: a design problem?

• by Don Peterson

• SQLServerCentral.com

• Reply

Why not use MSDE, or MySQL or any number of other freely available DBMS's out there?  XML is NEVER the best choice for anything, at its best XML is an incredibly inefficient mechanism for data transmission.  The lack of flexibility (which is inherent in its hierarchical nature) is just the start of the problems with XML, a total lack […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-08-26

RE: transaction logs grow to much

• by John-Tabor

• MSSQLTips.com

• Reply

I hear you, but unfortunately the boss says no!

2004-07-22

insert rights

• by sqlquery-101401

• Database Journal

• Topic

in sql server how can i grant only creation of objects right no drop ,no alter. in creation also if i want only sp creation right.pls suggest

2004-04-28

1 reads

RE: Defragging a Database Server - Good or Bad???

• by James Travis

• MSSQLTips.com

• Reply

Although I believe there are pratical impacts on defragging the servers file system I do suggest only do when you have CPU cycles you can spare and be aware if the file is locked it may not be defragmented until you can shut down SQL Server or at least close the DB for a frame […]

2004-03-19