|
|
-
|
|
I was working on my presentation for 24-hour-pass event on 2nd September and came across the sorting issue with the solution explorer. I have a number of script demos and I wanted to organize them by name. No matter, what I did, the solution explorer continued to display the script files in its own ......
|
|
-
|
|
While going over the ‘What is new’ part of SQL Server 2008 R2 Books Online, I found a reference to generating ATOM Data Feeds. It appeared that I could crate a report and then generate the data as an ATOM Data Feed. I found it very interesting. I was very excited with the idea of generating and pub......
|
|
-
|
|
I have recently seen a number of questions on locking in the Database Engine Forums. Shankar Reddy and oj has shared links to a few interesting whitepapers and articles that helps to understand how locking works in SQL Server. Troubleshooting Performance Problems in SQL Server 2008 <a h......
|
|
-
|
|
If you have been waiting for SQL Azure (formerly known as SSDS) Database CTP, there is a good news. Registration for SQL Azure Database CTP is open: http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx Key features with this CTP: Relational Data model supporting TSQL, including s......
|
|
-
|
|
If you have been waiting for SQL Azure (formerly known as SSDS) Database CTP, there is a good news. Registration for SQL Azure Database CTP is open: http://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx Key features with this CTP: Relational Data model supporting TSQL, including s......
|
|
-
|
|
Welcome to XQuery Lab 47. In this lab, we will see how to generate an HTML table from an XML document, using XQuery.
Here is the source data:
CUST COMPANY="Company1" CONTACT="Jacob" /><br />CUST COMPANY="Company1" CONTACT<span style="color: #000......
|
|
-
|
|
SQL Server 2008 R2 is a minor release and the number of features and enhancements added to the database engine is very limited. The public CTP is available for download at http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx The following are the main Database Engine Features added in SQL Se......
|
|
-
|
|
When a VARBINARY(MAX) column is marked with the FILESTREAM attribute, the limitation of 2GB is not applicable on the value any more. You can store values larger than 2GB in such a column. The maximum size is limited only by the size of the disk. A FILESTREAM column can be accessed from TSQL, just l......
|
|
-
|
|
One of the enhancements added to SQL Server Reporting Services 2008 R2 is the new Map Report Item. Here is a blog post that might give you some ideas. http://denglishbi.spaces.live.com/Blog/cns!CD3E77E793DF6178!1881.entry......
|
|
-
|
|
The August Customer Technology Preview (CTP) includes Application and Multi-server Management which will help organizations manage database environments efficiently at scale with increased visibility and control across the application lifecycle. Microsoft SQL Server StreamInsight will also be made a......
|
|