Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.
2008-05-22 (first published: 2007-06-20)
20,745 reads
People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.
2008-05-22
1,515 reads
Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.
2008-05-22
4,960 reads
SQL Server Integration Services is an incredibly rich and complex development environment that can handle almost any data movement task. Even those that do not involve SQL Server. Longtime author Tim Mitchell brings us a use that has nothing to do with SQL Server, but can be very handy for many of us.
2008-05-21 (first published: 2007-06-25)
11,843 reads
2008-05-21
16,061 reads
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
2008-05-21
39 reads
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
2008-05-21
33 reads
A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.
2008-05-21
32 reads
Database developers need to write stored procedures which are not only fully functional, but also which perform acceptably. This article concentrates on some of the counters used to measure performance and analyses methods of capturing these counters.
2008-05-21
6,671 reads
I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.
2008-05-21
3,165 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Comments posted to this topic are about the item Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers