Selamlar ;

sa kullanıcıyla sql'inize bağlanmak istiyorsunuz ama herşey Ok olmasına rağmen ( Sql Server hem sa hemde windows authentication için açık , sa login enabled ve sa 'in şifresini bildiğinizi varsayıyorum..) bir türlü bağlanamıyor ve
TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

Property IsLocked is not available for Login '[X]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

gibi bir hata alıyorsanız... Windows Authentication la login olup

alter login sa with password = 'sifrenizzz' unlock, check_policy = off, check_expiration = off

yazdığınız takdir de sorunsuz bir şekilde artık login olabilirsiniz.

iyi çalışmalar.

Selamlar ; Sql Server 2008 ile hayatımıza MS kanadından girecek olan yeniliklerin listesi ve ilgili linkleri aşağıda.

• _{Security and Data Auditing}
  • _{Transparent Data Encryption - This is encrypting the data while it is on disk and remains transparent to applications}
  • _{External Key Management - This new functionality relates to consolidation of key management and integration with external products}
  • _{Data Auditing - This is one core feature of SQL Server 2008 that will include a number of new features to include:}
    • _{The introduction of first class 'AUDIT' objects}
    • _{Auditing DDL (data definition language) commands}
    • _{Support for multiple logging targets}
  • _{Additional information - http://www.microsoft.com/sql/prodinfo/futureversion/datamanage/default.mspx}
• _{Availability and Reliability}
  • _{CPUs - Support for pluggable CPUs which means that a CPU can be added on the fly and recognized by SQL Server 2008 just like memory in SQL Server 2005}
  • _{Database Mirroring - Enhanced Database Mirroring to include compression of mirror streams, enhanced performance and automatic page-level repair for the principal and mirror}
• _Performance
  • _{Data Compression - This new feature provides the ability to easily enable or disable data compression as an online command as well as offer more efficient data storage above and beyond traditional data compression}
    • _{http://blogs.msdn.com/manisblog/archive/2007/08/13/data-compression-with-sql-server-2005-sp2-and-katmai.aspx}
  • _{Backup Stream Compression - The ability to configure compression with server level control or backup statement control of all backup types (full, differential, transaction log)}
  • _{Performance Data Collection - When you are experiencing a performance issue the biggest problem is pinpointing the problem, so with SQL Server 2008 Microsoft is introducing a single common framework for performance related data collection, reporting, and warehousing}
  • _{Improved Plan Guide Support - With SQL Server 2008 plans can be frozen for permanent query usage as well as pull plans directly from plan cache with SQL Server Management Studio integration}
  • _{Resource Governor - If you have had the need to segment your SQL Server resource utilization then you should be looking forward to SQL Server 2008 because you will have the opportunity to create pools and groups to segment the resources and govern them independently}
    • _{http://decipherinfosys.wordpress.com/2007/07/21/new-features-in-sql-server-2008-i/}
• _Management
  • _{Policy-Based Management Framework - The ability to manage objects via policies as opposed to traditional scripts with inherent monitoring and enforcement}
  • _{Microsoft System Center - Integration with Microsoft System Center which a product from Microsoft to improve operational costs}
  • _{Extended Events - Another new feature is Extended Events which is a high performance yet light weight tracing infrastructure with insight into the core engine independent of SQL Trace}
• _{New Data Types}
  • _{Date Time Data Type - The datetime data type will now be able to support the following:}
    • _{Precision to the 100th nanosecond which is 7 digits past second}
    • _{Time-zone datetime offset to translate the datetimes across numerous time zones}
    • _{Rather than having to parse the datatime for just the date or just the time, now SQL Server 2008 will have date only support as well as time only support}
  • _{HierarchyID - With the introduction of the HierarchyID data type this data type will be hierarchical-aware and will be accompanied by built-in functions, methods, etc. to support complex hierarchies in your data with .NET}
    • _{http://www.sqlskills.com/blogs/bobb/2007/08/02/NewSQLServer2008DateTimerelatedTypesAndADONET.aspx}
• _{Development Enhancements}
  • _{Entity Data Model - With SQL Server 2008 will come the concept of a 'business entities' vs. tables, this will enable the ability to model more complex relationships as well as be able to retrieve entities as opposed to a result set of rows and columns}
  • _{LINQ- LINQ is a new .NET Framework that encompass language-integrated query, set, and transform operations}
    • _{http://msdn2.microsoft.com/en-us/netframework/aa904594.aspx}
  • _{SQL Server Change Tracking - This feature provides the ability to have change data capture without a comparable value}
  • _{Table Valued Parameters - Ability to create variables of a table value data type and be able to pass this variable into a stored procedure}
    • _{http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266498,00.html}
  • _{MERGE statement - Another term for this new feature is 'upsert'; this commands provides the ability to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic}
    • _{http://www.sqlteam.com/article/microsoft-announces-sql-server-2008}
  • _{Large UDT's - The 8000 byte limit is no longer applicable for on CLR-based UDTs and UDAs}
  • _{Spatial data - SQL Server 2008 will support GEOMETRY and GEOGRAPHY data types with built-in spatial function support and spatial indexes to support more GIS needs}
    • _{http://www.directionsmag.com/editorials.php?article_id=2477}
  • _{XML enhancements (support for lax validation, office 12 support, xs:dateTime support, lists/union types, LET FLOWR support, etc.)}
    • _{http://www.codeplex.com/MSFTXmlProdSamples/Release/ProjectReleases.aspx?ReleaseId=5717}
• _{Service Broker}
  • _{Interface - A new user interface and tools will be released for working with Service Broker in order to add, drop or edit Service Broker objects directly in SQL Server Management Studio}
  • _{Conversation Priority - The ability to set message ordering with a send and receive impact with levels one to ten}
• _{Data Storage}
  • _{Data Compression - Reference the Performance section above}
  • _{FILESTREAM Attribute - With this feature get the best of both worlds with functionality from BLOBs in the DB vs. BLOBs on filesystem}
    • _{http://blogs.msdn.com/pedram/archive/2007/06/04/store-any-data-in-sql-server-2008-katmai.aspx}
  • _{Integrated Full Text Search - With SQL Server 2008 Full Text Search is fully integrated into the relational engine with no external storage, no external service as well as more efficient and reliable costing}
  • _{Sparse columns - SQL Server 2008 has more efficient storage for 'wide' tables with many columns that repeat and do not contain data}
  • _{New index types - New indexes include:}
    • _{Spatial indexes}
    • _{Hierarchical indexes}
    • _{FILTERED indexes (indexes on filtered values within columns)}
• _{Data Warehousing/ETL}
  • _{Partitioned Table Parallelism - This feature eliminates the one thread limit per partition}
  • _{Star Join support - SQL Server 2008 now supports a star join with no special syntax which is completely optimizer based with full backward syntax support}
    • _{https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5562}
  • _{Data compression - Reference the Performance section above}
  • _{Resource Governor - Reference the Performance section above}
  • _{Persistent Lookups in SSIS - There is no longer a need for re-querying for lookup operators and cache lookups in multiple ways with the ability to persist lookups to disk}
  • _{Improved thread scheduling in SSIS - This is accomplished by a shared thread pool and pipeline parallelism}
  • _{SQL Server Change Tracking - Reference the Development Enhancements section above}
  • _{MERGE statement - The MERGE statement will add a great deal of value with slowly changing dimensions}
  • _{Scale-out analysis services - With read-only storage multiple Analysis Services SQL Servers can be leveraged}
  • _{Subspace computations}
  • _{New tools for cube design}
  • _{Best practice design alerting}
  • _{Backup cubes with better scalability}
  • _{Excel - Data-mining add-ins for Excel}
• _Reporting
  • _{Reporting Services Deployment - IIS is no longer required to run Reporting Services}
  • _{Rich-text support}
  • _{Enhanced visualization graphing}
  • _{Word - Reports can be rendered to Microsoft Word}
• _Deprecation
  • _{Many of the 'old' features are removed to include:}
    • _{60, 65 and/or 70 compatibility modes}
    • _{NOLOG and/or TRUNCATEONLY for the BACKUP command}
      • _{http://blogs.technet.com/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx}

   Microsoft on Monday released the first community technology preview of SQL Server 2008, the official name for what was initially codenamed "Katmai." The announcement was made here at the Microsoft TechEd Conference in Orlando.

   Katmai is set to ship in 2008 and the company is making it a central plank of its push into the business intelligence space. But Redmond is also building a number of developer-specific capabilities into the next-gen server release: The ADO.NET Entity Framework (EF) and the Language Integrated Query (LINQ).

   Developers can use the Entity Framework to program against data defined in a conceptual way, instead of having to work with information organized in tables and columns. "With the Entity Framework, we’re essentially programming at the conceptual level rather than at a logical level or a physical level," Francois Ajenstat, director of product management, SQL Server previously told RDN.

   LINQ enables developers to tap various sources from within VB.NET and C#. The LINQ to Entities specification will ship as part of the Entity Framework, and, like the EF, will be supported by Visual Studio tools.

Other improvements slated for SQL Server 2008 include added support for various data types, including spatial and unstructured data.

In related SQL Server news, Microsoft on Monday also announced it had acquired technology from Dundas Data Visualization Inc., for the creation of charting in SQL Server Reporting Services.

Read the SQL Server 2008 Datasheet

SQL Server 2008 Product Overview

Watch the TechEd SQL Server 2008 Webcast

Download the latest release

http://virtualteched.com/Pages/OnlineSessions/OnlineWebcastsDefault.aspx

Selamlar sevgili okuyucular;

Evet en sonunda bu hafta içerisinde duyurusu yapılan Sql Server 2008 yani Katmai'inin CTP'nin oluşturulduğunu öğrenmiş bulunmaktayız.Ta uzaklarda..Orlando'da ki TechEd konferansında. :) Velhasıl kelam 3 önemli değişiklik bir yazılımcıları bekliyor..1.'si ADO.NET Entity Framework ve LINQ için yapılan değişikler.Optimizasyon yönünde özel bir çalışma devam etmekte. 2.Uzun zamandır ürünlerini kullandığım ve memnun kaldığım Dundas'ın Sql Server Reporting Services için geliştirdiği çözümün Microsoft tarafından alınmış olması,3.date ve time tiplerinin birbirinden ayrılacağı ve yeni veri tiplerinin geldiği (GIS gibi (Geometry,Point,Polygon,MultiPoint,MultiPolygon... bunlar Mysql'in uzun zamandır desteklemekte olduğu tipler.Net olarak hangi fielt type'lar eklenir bunu specler açıklandıktan sonra göreceğiz ama normalizasyon adına önemli bir gelişme..))..

Gelişmeler çok hoş..

SQL Server 2005 SP2'nin CTP'sini download etmek için burayı tıklayabilirsiniz.

Bu CTP'de ne gibi yenilikler olduğunu kısaca özetlemek gerekirse;

• Vista desteği
• SSAS ve SSRS için Office 2007 BI entegrasyonu
• SSRSda Hyperion Essbase desteği
• Sıkıştırılmış bir decimal türü olan vardecimal veri türü. (yeni bir veri türü)
• SQL EE'de common criteria desteği
• görsel ve performans açısından pek çok iyileştirme

şeklinde sıralayabiliriz.

"Teşekkürler Kadir'cim."   

 

İyi çalışmalar.

Eralp

SQL Server için ilk güncelleme paketi ( sp1 ) release oldu.Gözümüz aydın :D Yalnız anlayamadığım bir şey var ki o da boyutunun neden bu kadar büyük olduğu nerdeyse ana kurulumla aynı :S

 

Sql Server 2005 Sp1'i indirmek için..