What types of connectors make the most sense for SSIS packages? New author Mike Frost brings us a look at the various options along with some recommendations for different types of data as well as the 64-bit platform.
2007-08-30
9,143 reads
Tired of creating templates in SQL Server Reporting Services? Learn how to maintain reusable Reporting Services templates in SQL Server 2005 using BIDS.
2007-08-30
3,809 reads
Discover how to import and export SharePoint list items using SQL Server Integration Services and the new Collaborative Application Markup Language (CAML).
2007-08-30
2,012 reads
One of the more common requests of an application working with SQL Server is to deal with pages, or sections, or data rather than an entire result set. Often an application retreives the entire result set and then only shows the user a few records, repeating the process with the next page. Regular columnist Jacob Sebastian brings us a more efficient method of implementing paging in SQL Server 2005.
2007-08-29
13,717 reads
Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams.
2007-08-29
2,486 reads
Not every application needs a full-featured enterprise-scale database. In such cases, you can reduce costs and save resources by using a small-footprint database.
2007-08-29
3,786 reads
SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.
2007-08-28
13,053 reads
Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.
2007-08-28
1,980 reads
This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced.
2007-08-28
2,785 reads
If you're in the UK in October, you might want to sign up for the SQLBits Community day put on by MVP Simon Sabin.
2007-08-27
708 reads
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers