LessThanDot Site Logo

LessThanDot

A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "administration"

MongoDB: Using the web-based administrative tool

MongoDB ships with a web-based administrative tool. You can see this tool by going to http://localhost:28017/

You can see a bunch of stuff on this screen.

However when trying any of these on top

List all commands | Replica set status

Command…

Read More...

SQL Advent 2011 Day 2: system tables and catalog views

With the introduction of SQL Server 2005 system tables have been deprecated, there are three new set of objects to replace system tables: Compatibility Views, Dynamic Management Views and Catalog Views.

Compatibility views replace the system tables, so while you still can use syscolumns, you should get into the habit of using sys.columns instead

Read More...

List all stored procedures that run at startup in SQL Server

You know that you can mark a proc to run at startup in SQL Server. What you have to do is create the stored procedure in the master database and after that you have to set the startup flag to true. If your stored procedure name is spMyProc, the code wou…

Read More...

How to move datafiles to a new drive in SQL Server

For one of the databases that I have to manage we were running out of space, so we got a shiny new 10.9 TB sized drive.

I was asked to move some files used by one database to this new drive. I decided to write up a little blog post just in case you…

Read More...

Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action

I read SQL Server 2008 Administration in Action and really like this book, I have reviewed SQL Server 2008 Administration in Action here: Review of SQL Server 2008 Administration in Action I decided to ping Rod Colledge about doing an interview and he said yes. Some of the questions came from our forum users in […]

Read More...

Find Out The Recovery Model For Your Database

You want to quickly find out what the recovery model is for your database but you don’t want to start clicking and right-clicking in SSMS/Enterprise Manager to get that information. This is what you can do, you can use databasepropertyex to get that info. Replace ‘msdb’ with your database name T-SQL1 select databasepropertyex(’msdb’,’Recovery’) select databasepropertyex(‘msdb’,’Recovery’) […]

Read More...

How to Rebuild System Databases in SQL Server 2008

The PSS SQL Server Engineers made a nice blogpost explaining How to Rebuild System Databases in SQL Server 2008 In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as “rebuild master”). You were required to use the setup.exe program with command line switches. This is […]

Read More...