TribalSQL

External Article

Guerrilla Project Management for DBAs

  • Article

All DBAs need to engage in a little project management to help make sure everything runs smoothly. In this extract from the book Tribal SQL, David Tate explains his system for managing workload, colleagues, and projects, and how not to be just "the guy who says no".

2014-02-24

3,072 reads

External Article

Agile Database Development

  • Article

Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.

2014-01-13

5,036 reads

Technical Article

RE: enterprise manager

  • Reply

Start | Run | mmc Console | Open | C:\Program Files\Microsoft SQL Server\80\Tools\Binn Select 'SQL Server Enterprise Manager.MSC' That should do the trick. Or, you could make a shortcut to C:\WINNT\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"

You rated this post out of 5. Change rating

2004-06-17

Technical Article

NO LOCK vs FOR BROWSE

  • Topic

Hello All,Someone asked me today about FOR BROWSE and I got stumped.I use in most of the cases NO LOCK hint for Select queries and never heard about FOR BROWSE before. I checked BOL and MS site ( below link) and still wondering if anyone use it (FOR BROWSE) in real life for ASP/SQL Server application.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dblibc/dbc_pdc02_4tb9.asp TIA

2004-04-07

29 reads

Technical Article

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

  • Reply

Something you can consider for larger databases is the use of raw partitions.  Raw partitions are probably easier to manage within a SAN environment than with DAS.  Using raw partitions would eliminate any possibility of physical file fragmentation.  Because you would then only get logical fragmentation within SQL Server, you can cure this just be using […]

2004-03-19

Technical Article

RE: Moving DBs to a new server

  • Reply

I agree with SQL Draggon!Just becareful of 1 thing! Hence my question about which Replication Model are you using.When you remove replication from a replicated Database where MERGE Replication was implemented, it does NOT remove the UniqueIdentifier Columns on all tables that were part of any publication!

2004-03-14

Blogs

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

The Future of the Social Web Is in Good Hands

By

The Social Web Foundation is aiming to grow the fediverse and make the social...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers