ASP.NET News from Blogger:
SQL Server 2005 Distilled
Total News: 43
"Are you using SQL Server 2005 Express Edition and want to contribute to helping us continue to improve it?"...
The updated version was released few days ago:
January 2006 version of Microsoft SQL Server 2005 Upgrade Advisor...
Detailed discussion on how Microsoft IT used the full-text search feature of Microsoft SQL Server 2005 to significantly increase the speed of document indexing and retrieval for the internal document ...
Detailed discussion describing how Microsoft IT uses SQL Server 2005 to improve data security for its line of business applications. SQL Server 2005 enabled Microsoft IT to implement column-level encr...
Detailed discussion describing how the EAS group in Microsoft IT used the new features in SQL Server 2005 to dramatically increase the availability of SAP R/3 at Microsoft.
Word document
Powerpoint ...
Overview of the business value that Microsoft IT realized by deploying SQL Server 2005.
Microsoft IT Showcase: Overview of SQL Server 2005 at Microsoft...
Discussion on how Microsoft IT moved its line-of-business applications to SQL Server 2005.
Word document
Powerpoint slides...
This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified da...
The TPC page (tpc.org/tpcc/results/tpcc_result_detail.asp?id=105112801) has a mention of SQL Server 2005 SP1. The availability date is indicated as 06/05/06. ...
What are the seven types of indexes available in SQL Server 2005?
Click for answer:...
SQL Server 2005 Books Online (December 2005): The December 2005 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was releas...
You may know that Service Broker gets disabled when a database is restored or when a database is attached. What if you need to enable it whenever a database is restored This is just one example, but w...
Rushi Desai today posted a comment on Bob Beauchemin's blog. I think, anybody developing/managing Service Broker application(s) should pay close attention to the best practice recommendation he makes ...
While writing a code that works with both SQL Server 2000 and 2005, I noticed that for SQL Server 2000 the counter is Target Server Memory(KB) - while the counter for 2005 is Target Server Memory (KB)...
SQL Server 2005 does NOT allow defining CHECK constraints on XML columns.
a.)True
b.)False
99\';\nGO\n\nINSERT INTO tbl1 SELECT \'100\';\nGO\n\nSELECT * FROM tbl1;\nGO\n\nFirst INSERT will succee...
What startup trace flag need to be passed in order to enable the creation of the database mirroring endpoints
a.)None. As long as it is Standard Edition or Enterprise Edition of SQL Server 2005, dat...
"In this show, Jim (a database industry legend, Turing Award winner and Microsoft Distinguished engineer) gives his thoughts on the future directions for database products, LINQ, T-SQL and discusses ...
When you create a new database, is Service Broker enabled by default When you restore a database, is Service Broker enabled
When you attach a database, is Service Broker enabled
a.)Yes, Yes, Yes
b...
What will happen when you run the following command while connected to a SQL Server 2005 instance:
CREATE DATABASE TestDB ON DEFAULT = 10;
a.)Creates a database called TestDB of size 10 MB wi...
In SQL Server 2005, how would you set the database to emergency mode
a.)SQL Server 2005 no longer allows putting the database in emergency state.
b.)Same as in 2000; allow updates to 1, and updating...
In my recent presentation to NTSSUG, I mentioned that Service Broker must be enabled and database master key must be created in order for Service Broker communication to work. What I did not mention c...
While doing a little research on Reporting Services today, I found this PDF file that does an excellent job of comparing various reporting solutions available today, including SQL Server 2000 Reporti...
In SQL Server 2005, is it possible to change the compatibility level (sp_dbcmptlevel) of the master database How about changing the compatibility level setting of the model database, is it possible
a...
SCHEMA_ID can be used to find out the schema id associated with a schema name, while the SCHEMA_NAME function returns the schema name associated with the specified schema id. If no parameter is passed...
Dedicated Administrator Connection (DAC) can be established by using:
a. osql.exe
b. sqlcmd.exe
c. isql.exe
d. None of the above
Click for answer:...
Bill Gates is specially visiting Bangalore, India on December 9, 2005 to kick off the India Launch of SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006.
Live Webcast...
71-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
Registration begins: November 7, 2005
Beta exam period runs: December 5, 2005 through December 16, 2005
Call:...
Summary: Attach a single read-only reporting database to multiple server instances over SAN (data files must be on a read-only volume).
KB Article 910378
The scalable shared database feature allows...
In September CTP, Microsoft renamed sys.dm_database_mirroring_connections to sys.dm_db_mirroring_connections to be consistent with other database DMVs (such as sys.dm_db_index_operational_stats and sy...
Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances. SSMSE can also manage relational engine ...
www.microsoft.com/downloads/details.aspxFamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en
The November feature pack includes:
ADOMD.NET (x86, x64, and IA64)
MSXML 6.0 (x86, x64, and IA64...
Watch the webcast of Microsoft CEO Steve Ballmer highlighting customers and partners who have found success using the newest capabilities in the Microsoft application platform brought forth by SQL Ser...
SQL Server Express Utility: SQL Server Express Utility is a tool for interacting with SQL Server. It provides many features including Connect to the main instance or user-instance of SQL Server, Crea...
Finally got some time this evening to uninstall September CTP and install SQL Server 2005 RTM. SELECT @@VERSION returned:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37...
"This morning at 9 AM in shiproom, we did official signoffs for SQL Server 2005!
As Paul Flessner went around the room to get signoffs from everyone, it gave me great pleasure and an enormous sense...
Excellent white paper (and slide deck) on understanding and leveraging cryptography support in SQL Server 2005! (includes some best practices too)
www.microsoft.com/downloads/details.aspxfamilyid=cb1...
www.microsoft.com/downloads/details.aspxFamilyID=eedd10d6-75f7-4763-86de-d2347b8b5f89&DisplayLang=en
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to collect information from i...
The New Generation of Microsoft Certifications
The new generation of Microsoft certifications is more specific and targeted to reflect the detail of what you do and to prove your expertise...
I have found at least two versions of how SODA acronym is expanded and defined. Sybase and Gartner like to expand it as "Service Oriented Development of Applications" whereas Microsoft (specificall...
Question: If your SQL Server 2005 machine (32-bit) has 32 GB of physical memory, it is recommended that you put /3GB switch in your boot.ini file, in addition to /PAE switch.
a. True
b. False
Click ...
Davide Mauri shows an example of scenarios where SELECT TOP can be slower than SET ROWCOUNT. I tried his example in SQL Server 2000 (SP 3a) and SQL Server 2005 (Sept CTP), and verified that SET ROWCOU...
A very basic SQL Server 2005 Launch Countdown (JavaScript-based) is now being shown on my blog home page
(www.YukonXML.com/weblog/darshan) and on www.YukonXML.com front page....
What's the maximum number of concurrent connections supported by SQL Server 2005 Express Edition
a. 5
b. 255
c. Number of physical processors * (max worker thrads configuration)
d. No hard-coded maxi...
View Other bloggers