Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/www.schuirink.net/www/xml/headlines.php on line 383
Warning: fclose(): supplied argument is not a valid stream resource in /var/www/www.schuirink.net/www/xml/headlines.php on line 384
SearchSQLServer: Expert advice on database development :: Ooops! :: XML error: > required at line 60 :: using alternative parser codepage:UTF-8
array(17) {
["encoding"]=>
string(5) "UTF-8"
["title"]=>
string(54) "SearchSQLServer: Expert advice on database development"
["link"]=>
string(49) "http://searchsqlserver.techtarget.com?track=sy200"
["description"]=>
string(117) "Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more."
["language"]=>
string(5) "en-us"
["copyright"]=>
string(43) "Copyright TechTarget - All rights reserved."
["managingEditor"]=>
string(35) "editor@searchsqlserver.com (Editor)"
["webMaster"]=>
string(36) "webmaster@techtarget.com (Webmaster)"
["lastBuildDate"]=>
string(29) "Fri, 12 Sep 2008 23:28:01 EDT"
["docs"]=>
string(33) "http://rss.techtarget.com/200.xml"
["image_title"]=>
string(19) "SearchSQLServer.com"
["image_url"]=>
string(89) "http://searchsqlserver.techtarget.com/digitalguide/images/rss/rss_searchSQLServerLogo.gif"
["image_link"]=>
string(49) "http://searchsqlserver.techtarget.com?track=sy200"
["image_width"]=>
string(3) "153"
["image_height"]=>
string(2) "30"
["items"]=>
array(10) {
[0]=>
array(5) {
["title"]=>
string(51) "SQL Server encryption vs. hashing for data security"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/390773358/0,289483,sid87_gci1285699,00.html"
["description"]=>
string(748) "Choose carefully between encryption and hashing algorithms in SQL Server 2005 because not all methods fit all data security purposes. After you determine if you need to decrypt your SQL Server data, it's time to implement encryption or hashing. Database architect Denny Cherry outlines the algorithm options for symmetric and asymmetric keys and shows you how to encrypt and decrypt SQL Server data.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=GyfNfy"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=GyfNfy" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/390773358" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Fri, 12 Sep 2008 11:26:12 EDT"
}
[1]=>
array(5) {
["title"]=>
string(66) "Using SQL Server datetime functions GETDATE, DATENAME and DATEPART"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/389828132/0,289483,sid87_gci1329539,00.html"
["description"]=>
string(778) "Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the day, month or year from a datetime value, as well as such data as the quarter, week, hour or even the millisecond. SQL Server expert Robert Sheldon gives examples of how to use GETDATE, DATENAME and DATEPART in your SELECT statement.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=fS3Udh"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=fS3Udh" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/389828132" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Thu, 11 Sep 2008 00:39:03 EDT"
}
[2]=>
array(5) {
["title"]=>
string(38) "How to use the SELECT statement in SQL"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/351646949/0,295582,sid87_gci1321368,00.html"
["description"]=>
string(865) "Learn the basics of the SQL SELECT statement in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use SELECT to access almost anything contained in a SQL database, along with the names and functions of the many clauses that compose a SELECT statement. Authors John L. Viescas and Michael J. Hernandez also examine how to eliminate duplicate rows with the DISTINCT keyword and how to properly sort your data with the ORDER BY clause.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=QBEKAv"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=QBEKAv" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/351646949" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Wed, 10 Sep 2008 09:37:11 EDT"
}
[3]=>
array(5) {
["title"]=>
string(59) "Tuning SQL Server performance via memory and CPU processing"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/387724814/0,289483,sid87_gci1328928,00.html"
["description"]=>
string(629) "Part two of our series on tuning the hardware that supports your SQL Server system, Denny Cherry examines memory allocation and CPU processing and how their configurations impact performance. Learn how clustered indexes can drain SQL Server memory and what causes CPU bottlenecks.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=LGFVrP"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=LGFVrP" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/387724814" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Tue, 09 Sep 2008 10:29:24 EDT"
}
[4]=>
array(5) {
["title"]=>
string(67) "SQL Server stored procedures tutorial: Write, tune and get examples"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/102835130/0,295582,sid87_gci1247499,00.html"
["description"]=>
string(938) "This SQL Server stored procedures tutorial covers three areas for simplifying database development. A stored procedure, sometimes called the work horse of the database, also provides an important layer of security between the user interface and database. But the process of grouping T-SQL statements to create stored procedures can be complex. In our tutorial, learn the basics for writing stored procedures followed by methods for tuning them, and, finally, browse our collection of stored procedure examples – for checking database and log file sizes and monitoring long-running jobs and much more.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=1T4NGb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=1T4NGb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/102835130"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Mon, 08 Sep 2008 09:53:57 EDT"
}
[5]=>
array(5) {
["title"]=>
string(68) "SQL Server data conversions from date/time values to character types"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/363018360/0,289483,sid87_gci1324835,00.html"
["description"]=>
string(676) "T-SQL supports two built-in methods for converting date/time data to character data and vice versa. SQL Server expert Robert Sheldon takes you through a step-by-step process for using each method -- implicit and explicit conversions. The steps include using the handy CAST and CONVERT functions for converting date/time values.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=bFOwuG"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=bFOwuG" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/363018360" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Fri, 05 Sep 2008 08:29:05 EDT"
}
[6]=>
array(5) {
["title"]=>
string(57) "FAQ: How to troubleshoot and grant SQL Server permissions"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/383305766/0,295582,sid87_gci1325004,00.html"
["description"]=>
string(549) "Problems with permissions will affect your users, their login abilities and their access to certain aspects of your SQL Server. Troubleshoot all of your SQL Server permissions issues with these FAQs.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=Z9LQpb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=Z9LQpb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/383305766" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Thu, 04 Sep 2008 10:27:11 EDT"
}
[7]=>
array(5) {
["title"]=>
string(51) "Configuring SQL Server with a changed computer name"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382534935/0,289625,sid87_gci1328072,00.html"
["description"]=>
string(450) "Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=3cqAQn"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=3cqAQn" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382534935" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 13:36:39 EDT"
}
[8]=>
array(5) {
["title"]=>
string(63) "Using MDX and UDM in a SQL Server Analysis Services environment"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462013/0,289625,sid87_gci1327221,00.html"
["description"]=>
string(493) "Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=eBTVh8"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=eBTVh8" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462013" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 12:15:58 EDT"
}
[9]=>
array(5) {
["title"]=>
string(65) "SSIS error message due to installation problem on SQL Server 2005"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462014/0,289625,sid87_gci1327219,00.html"
["description"]=>
string(510) "If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=cH5c5z"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=cH5c5z" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462014" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 12:14:28 EDT"
}
}
["items_count"]=>
int(10)
}
1010string(5) "UTF-8"
UTF-8string(54) "SearchSQLServer: Expert advice on database development"
SearchSQLServer: Expert advice on database developmentstring(49) "http://searchsqlserver.techtarget.com?track=sy200"
http://searchsqlserver.techtarget.com?track=sy200string(117) "Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more."
Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.string(5) "en-us"
en-usstring(43) "Copyright TechTarget - All rights reserved."
Copyright TechTarget - All rights reserved.string(35) "editor@searchsqlserver.com (Editor)"
editor@searchsqlserver.com (Editor)string(36) "webmaster@techtarget.com (Webmaster)"
webmaster@techtarget.com (Webmaster)string(29) "Fri, 12 Sep 2008 23:28:01 EDT"
Fri, 12 Sep 2008 23:28:01 EDTstring(33) "http://rss.techtarget.com/200.xml"
http://rss.techtarget.com/200.xmlstring(19) "SearchSQLServer.com"
SearchSQLServer.comstring(89) "http://searchsqlserver.techtarget.com/digitalguide/images/rss/rss_searchSQLServerLogo.gif"
http://searchsqlserver.techtarget.com/digitalguide/images/rss/rss_searchSQLServerLogo.gifstring(49) "http://searchsqlserver.techtarget.com?track=sy200"
http://searchsqlserver.techtarget.com?track=sy200string(3) "153"
153string(2) "30"
30array(10) {
[0]=>
array(5) {
["title"]=>
string(51) "SQL Server encryption vs. hashing for data security"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/390773358/0,289483,sid87_gci1285699,00.html"
["description"]=>
string(748) "Choose carefully between encryption and hashing algorithms in SQL Server 2005 because not all methods fit all data security purposes. After you determine if you need to decrypt your SQL Server data, it's time to implement encryption or hashing. Database architect Denny Cherry outlines the algorithm options for symmetric and asymmetric keys and shows you how to encrypt and decrypt SQL Server data.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=GyfNfy"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=GyfNfy" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/390773358" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Fri, 12 Sep 2008 11:26:12 EDT"
}
[1]=>
array(5) {
["title"]=>
string(66) "Using SQL Server datetime functions GETDATE, DATENAME and DATEPART"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/389828132/0,289483,sid87_gci1329539,00.html"
["description"]=>
string(778) "Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the day, month or year from a datetime value, as well as such data as the quarter, week, hour or even the millisecond. SQL Server expert Robert Sheldon gives examples of how to use GETDATE, DATENAME and DATEPART in your SELECT statement.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=fS3Udh"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=fS3Udh" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/389828132" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Thu, 11 Sep 2008 00:39:03 EDT"
}
[2]=>
array(5) {
["title"]=>
string(38) "How to use the SELECT statement in SQL"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/351646949/0,295582,sid87_gci1321368,00.html"
["description"]=>
string(865) "Learn the basics of the SQL SELECT statement in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use SELECT to access almost anything contained in a SQL database, along with the names and functions of the many clauses that compose a SELECT statement. Authors John L. Viescas and Michael J. Hernandez also examine how to eliminate duplicate rows with the DISTINCT keyword and how to properly sort your data with the ORDER BY clause.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=QBEKAv"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=QBEKAv" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/351646949" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Wed, 10 Sep 2008 09:37:11 EDT"
}
[3]=>
array(5) {
["title"]=>
string(59) "Tuning SQL Server performance via memory and CPU processing"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/387724814/0,289483,sid87_gci1328928,00.html"
["description"]=>
string(629) "Part two of our series on tuning the hardware that supports your SQL Server system, Denny Cherry examines memory allocation and CPU processing and how their configurations impact performance. Learn how clustered indexes can drain SQL Server memory and what causes CPU bottlenecks.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=LGFVrP"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=LGFVrP" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/387724814" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Tue, 09 Sep 2008 10:29:24 EDT"
}
[4]=>
array(5) {
["title"]=>
string(67) "SQL Server stored procedures tutorial: Write, tune and get examples"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/102835130/0,295582,sid87_gci1247499,00.html"
["description"]=>
string(938) "This SQL Server stored procedures tutorial covers three areas for simplifying database development. A stored procedure, sometimes called the work horse of the database, also provides an important layer of security between the user interface and database. But the process of grouping T-SQL statements to create stored procedures can be complex. In our tutorial, learn the basics for writing stored procedures followed by methods for tuning them, and, finally, browse our collection of stored procedure examples – for checking database and log file sizes and monitoring long-running jobs and much more.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=1T4NGb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=1T4NGb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/102835130"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Mon, 08 Sep 2008 09:53:57 EDT"
}
[5]=>
array(5) {
["title"]=>
string(68) "SQL Server data conversions from date/time values to character types"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/363018360/0,289483,sid87_gci1324835,00.html"
["description"]=>
string(676) "T-SQL supports two built-in methods for converting date/time data to character data and vice versa. SQL Server expert Robert Sheldon takes you through a step-by-step process for using each method -- implicit and explicit conversions. The steps include using the handy CAST and CONVERT functions for converting date/time values.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=bFOwuG"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=bFOwuG" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/363018360" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Fri, 05 Sep 2008 08:29:05 EDT"
}
[6]=>
array(5) {
["title"]=>
string(57) "FAQ: How to troubleshoot and grant SQL Server permissions"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/383305766/0,295582,sid87_gci1325004,00.html"
["description"]=>
string(549) "Problems with permissions will affect your users, their login abilities and their access to certain aspects of your SQL Server. Troubleshoot all of your SQL Server permissions issues with these FAQs.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=Z9LQpb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=Z9LQpb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/383305766" height="1" width="1"/>"
["author"]=>
string(13) "Heidi Sweeney"
["pubDate"]=>
string(29) "Thu, 04 Sep 2008 10:27:11 EDT"
}
[7]=>
array(5) {
["title"]=>
string(51) "Configuring SQL Server with a changed computer name"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382534935/0,289625,sid87_gci1328072,00.html"
["description"]=>
string(450) "Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=3cqAQn"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=3cqAQn" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382534935" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 13:36:39 EDT"
}
[8]=>
array(5) {
["title"]=>
string(63) "Using MDX and UDM in a SQL Server Analysis Services environment"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462013/0,289625,sid87_gci1327221,00.html"
["description"]=>
string(493) "Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=eBTVh8"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=eBTVh8" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462013" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 12:15:58 EDT"
}
[9]=>
array(5) {
["title"]=>
string(65) "SSIS error message due to installation problem on SQL Server 2005"
["link"]=>
string(110) "http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462014/0,289625,sid87_gci1327219,00.html"
["description"]=>
string(510) "If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=cH5c5z"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=cH5c5z" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462014" height="1" width="1"/>"
["author"]=>
string(12) "Steve Cimino"
["pubDate"]=>
string(29) "Wed, 03 Sep 2008 12:14:28 EDT"
}
}
Array
(
[0] => Array
(
[title] => SQL Server encryption vs. hashing for data security
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/390773358/0,289483,sid87_gci1285699,00.html
[description] => Choose carefully between encryption and hashing algorithms in SQL Server 2005 because not all methods fit all data security purposes. After you determine if you need to decrypt your SQL Server data, it's time to implement encryption or hashing. Database architect Denny Cherry outlines the algorithm options for symmetric and asymmetric keys and shows you how to encrypt and decrypt SQL Server data.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=GyfNfy"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=GyfNfy" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/390773358" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Fri, 12 Sep 2008 11:26:12 EDT
)
[1] => Array
(
[title] => Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/389828132/0,289483,sid87_gci1329539,00.html
[description] => Part three in our series on datetime in SQL Server describes functions for retrieving the current date and time, or individual parts of a DATETIME or SMALLDATETIME value. Learn how to extract the day, month or year from a datetime value, as well as such data as the quarter, week, hour or even the millisecond. SQL Server expert Robert Sheldon gives examples of how to use GETDATE, DATENAME and DATEPART in your SELECT statement.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=fS3Udh"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=fS3Udh" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/389828132" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Thu, 11 Sep 2008 00:39:03 EDT
)
[2] => Array
(
[title] => How to use the SELECT statement in SQL
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/351646949/0,295582,sid87_gci1321368,00.html
[description] => Learn the basics of the SQL SELECT statement in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use SELECT to access almost anything contained in a SQL database, along with the names and functions of the many clauses that compose a SELECT statement. Authors John L. Viescas and Michael J. Hernandez also examine how to eliminate duplicate rows with the DISTINCT keyword and how to properly sort your data with the ORDER BY clause.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=QBEKAv"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=QBEKAv" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/351646949" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Wed, 10 Sep 2008 09:37:11 EDT
)
[3] => Array
(
[title] => Tuning SQL Server performance via memory and CPU processing
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/387724814/0,289483,sid87_gci1328928,00.html
[description] => Part two of our series on tuning the hardware that supports your SQL Server system, Denny Cherry examines memory allocation and CPU processing and how their configurations impact performance. Learn how clustered indexes can drain SQL Server memory and what causes CPU bottlenecks.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=LGFVrP"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=LGFVrP" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/387724814" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Tue, 09 Sep 2008 10:29:24 EDT
)
[4] => Array
(
[title] => SQL Server stored procedures tutorial: Write, tune and get examples
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/102835130/0,295582,sid87_gci1247499,00.html
[description] => This SQL Server stored procedures tutorial covers three areas for simplifying database development. A stored procedure, sometimes called the work horse of the database, also provides an important layer of security between the user interface and database. But the process of grouping T-SQL statements to create stored procedures can be complex. In our tutorial, learn the basics for writing stored procedures followed by methods for tuning them, and, finally, browse our collection of stored procedure examples – for checking database and log file sizes and monitoring long-running jobs and much more.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=1T4NGb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=1T4NGb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/102835130"/>
[author] => Heidi Sweeney
[pubDate] => Mon, 08 Sep 2008 09:53:57 EDT
)
[5] => Array
(
[title] => SQL Server data conversions from date/time values to character types
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/363018360/0,289483,sid87_gci1324835,00.html
[description] => T-SQL supports two built-in methods for converting date/time data to character data and vice versa. SQL Server expert Robert Sheldon takes you through a step-by-step process for using each method -- implicit and explicit conversions. The steps include using the handy CAST and CONVERT functions for converting date/time values.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=bFOwuG"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=bFOwuG" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/363018360" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Fri, 05 Sep 2008 08:29:05 EDT
)
[6] => Array
(
[title] => FAQ: How to troubleshoot and grant SQL Server permissions
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/383305766/0,295582,sid87_gci1325004,00.html
[description] => Problems with permissions will affect your users, their login abilities and their access to certain aspects of your SQL Server. Troubleshoot all of your SQL Server permissions issues with these FAQs.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=Z9LQpb"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=Z9LQpb" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/383305766" height="1" width="1"/>
[author] => Heidi Sweeney
[pubDate] => Thu, 04 Sep 2008 10:27:11 EDT
)
[7] => Array
(
[title] => Configuring SQL Server with a changed computer name
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382534935/0,289625,sid87_gci1328072,00.html
[description] => Find out how to reconfigure all aspects of your SQL Server after your computer name has been changed.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=3cqAQn"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=3cqAQn" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382534935" height="1" width="1"/>
[author] => Steve Cimino
[pubDate] => Wed, 03 Sep 2008 13:36:39 EDT
)
[8] => Array
(
[title] => Using MDX and UDM in a SQL Server Analysis Services environment
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462013/0,289625,sid87_gci1327221,00.html
[description] => Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=eBTVh8"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=eBTVh8" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462013" height="1" width="1"/>
[author] => Steve Cimino
[pubDate] => Wed, 03 Sep 2008 12:15:58 EDT
)
[9] => Array
(
[title] => SSIS error message due to installation problem on SQL Server 2005
[link] => http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~3/382462014/0,289625,sid87_gci1327219,00.html
[description] => If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools.
<p><a href="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?a=cH5c5z"><img src="http://feeds.feedburner.com/~a/techtarget/Searchsql/DatabaseDev?i=cH5c5z" border="0"></img></a></p><img src="http://feeds.feedburner.com/~r/techtarget/Searchsql/DatabaseDev/~4/382462014" height="1" width="1"/>
[author] => Steve Cimino
[pubDate] => Wed, 03 Sep 2008 12:14:28 EDT
)
)
int(10)
10
SearchSQLServer: Expert advice on database development :: This newsfeed has a problem searchsqlserver_dbdev @ the web & the world :: hundreds of fresh newsfeeds on schuirink.net