|
|
-
|
|
In the last two posts we examined FOR XML AUTO and FOR XML RAW. It is time for us to examine the most hated FOR XML directive: EXPLICIT. EXPLICIT is the most powerful directive that you can use with FOR XML, which gives you total control over the shape of XML being generated. Using EXPLICIT mode, ......
|
|
-
|
|
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop. SQL ......
|
|
-
|
|
SQL Server 2008 R2: Ensuring Your Data Is Secure (Level 300) Thursday, May 06, 2010 11:00 AM Pacific Time (US & Canada) In this webcast, we explore two performance-related tools, Performance Studio and Best Practice Analyzer, that ship with Microsoft SQL Server 2008 R2. Performance Studio help......
|
|
-
|
|
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices. SQL Server Compact 3.5 SP2 for devices is the service pack release of SQL Server Compact 3.5 for devices. The download doe......
|
|
-
|
|
SQL Server 2008 Performance Tuning Wednesday, May 05, 2010 12:15 PM Eastern Time (US & Canada) There are a number of tools available on the market that can assist you in performance tuning and troubleshooting your SQL Server 2008 database engine. But fortunately for us, Microsoft has i......
|
|
-
|
|
Tuesday, May 04, 2010 11:00 AM Pacific Time (US & Canada) In this webcast, we examine the architecture and configuration of PowerPivot for SharePoint and explain how to properly install and configure PowerPivot for SharePoint on Microsoft SharePoint Server and in a SharePoint Server farm. We al......
|
|
-
|
|
SQL Server Compact 3.5 SP2 Server Tools Windows Installer (MSI) file installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data with SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 November CTP. SQL Server Compact 3.5 SP2 Server To......
|
|
-
|
|
The results of a SQL Server SELECT query can be transformed into an XML document by using the FOR XML command. Building XML documents using string functions – concatenating XML tags and embedding values between them using string operations – is not a recommended method. This post tries to look into ......
|
|
-
|
|
So what is so exciting about the SQL Server 2008 R2 Release? Well, along with plenty of BI features and enhancements, there is a tiny cute feature that I am sure all of us will appreciate a lot. The product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 G......
|
|
-
|
|
Solid Quality Mentors India is doing an exclusive training program on SQL Server 2008 and Sharepoint 2010 in Hyderabad from May 10 to May 14, 2010. There will be two separate tracks; one for SQL Server and the other for Sharepoint. Microsoft SQL Server 2005/2008 Query Optimization & Performance......
|
|