The omnipresent nature of Web-based technologies expanded the concept of distributed environments with the ability to utilize services hosted on remote servers accessible via standard Internet protocols. This capability can be easily leveraged in SQL Server 2008 R2 Integration Services by employing Web Services Task, whose characteristics have already been covered in detail on this forum. However, in some cases, it might be required to reference Web Services directly from within a Script Task code. We will describe how such a need can be accommodated in this article.
http://www.databasejournal.com/features/mssql/sql-server-2008-web-services-script-task.html
Friday, June 17, 2011
Tuesday, May 10, 2011
Day Zero with PowerShell + SQL
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server
http://www.sqlservercentral.com/articles/powershell/73288/
http://www.sqlservercentral.com/articles/powershell/73288/
Monday, May 9, 2011
Use ACE Drivers and PowerShell to Talk to Access and Excel
Quit using deprecated JET drivers to talk to Microsoft Access and Excel. Learn how to use Windows PowerShell and ACE Drivers...
http://blogs.technet.com/b/heyscriptingguy/archive/2011/05/04/use-ace-drivers-and-powershell-to-talk-to-access-and-excel.aspx
http://blogs.technet.com/b/heyscriptingguy/archive/2011/05/04/use-ace-drivers-and-powershell-to-talk-to-access-and-excel.aspx
Thursday, May 5, 2011
Obtaining Identity Column Values in SQL Server
When you enter a new record into a table that contains an identity column, the identity value will be set with the next available identity value. Lots of times your database design requires you to obtain the value that was used to set the identity column. The identity value will be used to populate other tables that need to have a foreign key relationship with the inserted record. Therefore you need to be able to return the identity column value of the newly inserted record.
http://www.databasejournal.com/features/mssql/article.php/3931466/Obtaining-Identity-Column-Values-in-SQL-Server.htm
http://www.databasejournal.com/features/mssql/article.php/3931466/Obtaining-Identity-Column-Values-in-SQL-Server.htm
Tuesday, May 3, 2011
SQL Server Foreign Key Update and Delete Rules
Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?
http://www.mssqltips.com/tip.asp?tip=2365
http://www.mssqltips.com/tip.asp?tip=2365
Tuesday, April 12, 2011
Continuous Integration for SQL Server Databases
When it comes to the subject of putting databases into source control, Troy Hunt is no shrinking violet. “Database source control is no longer negotiable”. In this article, published originally in his Blog, Troy explains how to do Continuous Integration from a database that is in a Version Control System (VCS).
http://www.simple-talk.com/content/article.aspx?article=1247
You’re deploying it wrong!
http://www.troyhunt.com/2010/11/you-deploying-it-wrong-teamcity.html
http://www.simple-talk.com/content/article.aspx?article=1247
You’re deploying it wrong!
http://www.troyhunt.com/2010/11/you-deploying-it-wrong-teamcity.html
Tuesday, October 26, 2010
Top 10 Mistakes When Building and Maintaining a Database
Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.
http://www.databasejournal.com/features/mssql/article.php/3906986/Top-10-Mistakes-When-Building-and-Maintaining-a-Database.htm
http://www.databasejournal.com/features/mssql/article.php/3906986/Top-10-Mistakes-When-Building-and-Maintaining-a-Database.htm
Labels:
administration,
bookmarks,
management,
SQL Server
Subscribe to:
Posts (Atom)