Tags: sql server
Microsoft Driver for PHP for SQL Server 2.0.1
Dec 2nd
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 driver… more »
Migrate from MySQL to SQL Azure or SQL Server
Aug 13th
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?
Apr 3rd
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: SQL Server VersionMicrosoft SQ… more »
Checking the running time since last SQL-Server instance startup
Feb 15th
Below script will query sys.dm_exec_sessions to find out how long the SQL-Server instance is running.DECLARE @elapsed_time AS DATETIME, @lr_start_time AS DATETIMESELECT @lr_start_time = (SELECT last_request_start_time FROM sys.dm_exec_ses… more »
Which login has what server role permissions
Jan 31st
Below script will query sys.server_role_members / sys.server_principals to find out which logins have what server role access.SELECT 'ServerRole' = CASE WHEN rm.role_principal_id > 2 THEN SUSER_NAME(rm.role_principal_id)… more »
XML Feeds