Category: SQL

Control Microsoft SQL memory usage
article #1256, updated 19 days ago

Great info here:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-2017#max_server_memory

Categories:   SQL   Servers

==============

Create New Microsoft SQL Administrative Login
article #1160, updated 277 days ago

Often one will find a Microsoft SQL server with no working or available administrative login. To set one up:

  1. Stop the database. You’ll need its name. Go to services.msc , find entry “SQL Server (XYZ)”; XYZ is the name.
  1. Set up the database to run in single-user mode. In the Sql Server Configuration Manager, in SQL Server Services, in the properties of the desired SQL Server, in the Advanced tab, and for Startup Parameters, add “-m;” (no spaces, no quotes) to the beginning.
  1. Start the database.
  1. From administrative command prompt, run:
SQLCMD -E -S 127.0.0.1\XYZ

If you have only one SQL server on this machine, omit the -S and everything after.

This may take multiple attempts. The attempts may error saying “Reason: Server is in single user mode. Only one administrator can connect at this time.” Eventually it will connect and give you the prompt:

1>
  1. Enter the following, press Enter at every line, and choose something long and horrible for PasswordText:
CREATE LOGIN [sa2] WITH PASSWORD = 'PasswordText'
GO
GRANT CONTROL SERVER TO [sa2]
GO
EXIT
  1. Reverse the change in SQL Server Configuration Manager.
  1. Restart the SQL server.

Categories:   SQL   

==============

Tune MySQL and MariaDB
article #790, updated 1358 days ago

Here’s a good place to start:

http://mysqltuner.com/

Categories:   SQL   

==============

Effective MS SQL Database Maintenance
article #784, updated 1384 days ago

An interesting article:

https://technet.microsoft.com/en-us/magazine/2008.08.database.aspx

Categories:   SQL   

==============

Download SQL Studio 2008 R2
article #761, updated 1467 days ago

Go to this page:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

which looks like it is for SQL as a whole, check the downloads list; the ones you want are near the bottom.

Categories:   SQL   

==============

Download SQL Studio 2008
article #760, updated 1467 days ago

Go to this page:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

which looks like it is for SQL as a whole, check the downloads list; the ones you want are near the bottom.

Categories:   SQL   

==============

Automatic Microsoft SQL backup job settings
article #562, updated 1969 days ago

Open SQL Studio, under the server, Management, Maintenance Plans.

Categories:   SQL   

==============

SQL Server 2008 internal backup
article #272, updated 2840 days ago

In SQL Studio for SQL 2008, under a database object, go to Management, then Maintenance Plans. If you double-click on an item under there, you’ll see a Visio-like flowchart; double-clicking on any of the items will permit reconfiguration.

Categories:   SQL   Servers

==============

Move an SQL Server transaction log
article #224, updated 2956 days ago

A very good series of steps, actually one command-line and one GUI, are here:

http://www.mssqltips.com/tip.asp?tip=1774

Categories:   Servers   SQL