Tags » SQLSERVER

Reblog: SQLServer Firewall Configuration using command line

REBLOG from old ILIKESQL BLOG

SQL Server Firewall Configuration using command line

I’ve been asked the question many times, and you probably have seen it before … 428 more words

SQL Server

PowerShell and SqlServer: dropping a set of databases

I have a bunch of databases which follow a prefix pattern.

For resetting my tests, I want to dropĀ them, using PowerShell. Assumption: no concern about anyone/thing accessing those databases at that time. 161 more words

Powershell

SqlServer: firewalls

When doing a new install of SQL, I always remember to turn on TCP/IP client access, and to allow SQLServer through the firewalI . But I sometimes forget about the port number, and I did that again today. 8 more words

SQLServer

SQLServer - Como eliminar una base de datos

USE [master]
GO

IF EXISTS (SELECT name FROM sys.databases WHERE name = N’NombreBaseDeDatos‘)
DROP DATABASE [NombreBaseDeDatos]

Probado en: SQLServer 2008 R2

SQLServer

SQLServer - Como crear una base de datos

USE
GO

CREATE DATABASE [NombreBaseDeDatos];

Probado en: SQLServer 2008 R2

SQLServer

SQLServer - Como crear un login de base de datos

CREATE LOGIN [NombreLogin] WITH PASSWORD = ‘Contrasenia‘, DEFAULT_DATABASE=[BaseDeDatos], DEFAULT_LANGUAGE=, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

Probado en: SQLServer 2008 R2

SQLServer

Speaking at SQLSaturday Pordenone

Next week, on Saturday 28, make sure you don’t missĀ SQLSaturday Pordenone!

Pordenone is the place where the Italian adventure with SQLSaturday started, more than two years ago… 385 more words

SQL Server