Tags: sql server

SQL Server Information

Only a short script to get informations about your SQL Server enviroment, like machine name, instance name, edition, version, level, cluster security, user mode, collation and login. I use it as a piece on my whole admin scripts. --> SQL… more »

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 4 (CTP4) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 4 (CTP4) Download: SQL Server 2012 SP1 CTP4 SQL Server 2012 SP1 CTP4 Express SQL Server 2012 SP1 CTP4 Feature Pack The SQL Server 2012 builds that were released after SQL… more »

Antivirus Software on SQL Server

It’s an old story, but still present - Why or why not installing antivirus software on a database server? First of all, I’ve been on both sides of the debate with respect, but I can only, only partially agree to install antivirus software on a database… more »

SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 3 (CTP3) Available

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 3 (CTP3) Download: http://www.microsoft.com/en-us/download/details.aspx?id=30375   The SQL Server 2012 builds that were released after SQL Server 2012 was released: Downl… mehr »

SQL Server 2008 R2 Service Pack 2 Customer Technology Preview (CTP) Available

List of bugs that are fixed in SQL Server 2008 R2 Service Pack 2 CTP (Customer Technology Preview): http://support.microsoft.com/kb/2630455 How to obtain the latest service pack for SQL Server 2008 R2: http://support.microsoft.com/kb/2527041 Mic… more »

Microsoft Driver for PHP for SQL Server 2.0.1

The Microsoft Drivers for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications. In addition to some important bug fixes for the existing SQLSRV driver, version 2.0 release adds support for PDO with a new PDO_SQLSRV… more »

Migrate from MySQL to SQL Azure or SQL Server

Microsoft announced the release of the first version of SQL Server Migration Assistant (SSMA) for MySQL! Download: Microsoft SQL Server Migration Assistant for MySQL v1.0 I hope you know the other SSMA for Oracle/Sybase/Access ?! So take a look here:… more »

Which service pack do I have installed?

Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level.By selecting @@VERSION in a query window ...SELECT @@VERSION AS "SQL Server Version"you / I get following result: more »

Checking the running time since last SQL-Server instance startup

Below script will query sys.dm_exec_sessions to find out how long the SQL-Server instance is running. CodeDECLARE @elapsed_time AS DATETIME, @lr_start_time AS DATETIME SELECT @lr_start_time = (SELECT last_request_start_time FROM sys.dm_exec_sessions… more »

Which login has what server role permissions

Below script will query sys.server_role_members / sys.server_principals to find out which logins have what server role access. CodeSELECT 'ServerRole' = CASEWHEN rm.role_principal_id > 2 THEN SUSER_NAME(rm.role_principal_id) END,lgn.name AS… more »