Plus niste prezentari fantastice din cadrul IT's Showtime: What Nobody Ever Told You About Securing SQL Server Is That Application Really Safe?  

Celor interesati de subiectul securitate le recomand urmatorul link: http://www.nextgenss.com/research/papers/ Sau direct: 13/09/06 Inter-Protocol Communication12/09/06 Low Cost Attacks on Smart Cards - The Electromagnetic Side-Channel16/11/05 Database Servers on Windows XP and the Unintended Consequences of Simple File Sharing 08/11/05 ...

newsletter the data miner (si RSS)

Free Chapter - Practical Business Intelligence with SQL Server 2005: Data Mining  

O noua functionalitate care mi-a atras atentia este "logon triggers". Un articol pe aceasta tema a unui prieten Kent Tegels puteti citi la urmatoarea adresa: http://www.sqljunkies.com/WebLog/ktegels/archive/2006/11/09/25306.aspx

Source: Script Repository: SQL Server 2005 - List Indexes With the Most Contention USE AdventureWorks;GODECLARE @dbid INT;SET @dbid=DB_ID();SELECT  DB_NAME(database_id) AS DbName,OBJECT_NAME(s.[object_id]) AS ObjName,i.name AS IndexName,i.index_id,partition_number,row_lock_count,row_lock_wait_count ,CAST (100.0 * row_lock_wait_count / (1 + ...

Se poate! Din T-SQL:USE tempdb;GOCREATE SCHEMA S1;GOCREATE SCHEMA S2;GOCREATE TABLE S1.T(i INT);GO-- Move T from S1 to S2ALTER SCHEMA S2 TRANSFER S1.T;GOSELECT * FROM S2.T;GO -- Clean-upDROP TABLE S2.T;DROP SCHEMA S1;DROP SCHEMA S2; Visual - right click in Object Explorer pe tabel, Design:

LEAD Technologies Inc. V1.01

If the SP1 introduced two new Dynamic Management Objects sys.dm_exec_query_resource_semaphores and sys.dm_exec_query_memory_grants, SP2 comes with just one - the sys.dm_exec_text_query_plan dynamic management function. As the name says it returns the Showplan for a batch or a specific stament within the batch in text format. The syntax is ...

Eventual puteti face modificarea din Enterprise Manager.