tag:blogger.com,1999:blog-8546553846815627122023-06-20T15:17:50.714+03:00My Online AreaComputer related informations, articles, tutorials and general support for hardware and software.Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.comBlogger121125tag:blogger.com,1999:blog-854655384681562712.post-49684762740515240582011-06-17T10:48:00.002+03:002011-06-17T10:48:48.922+03:00SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;">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</span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"> </span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"><a href="http://www.databasejournal.com/features/mssql/article.php/3651571/SQL-Server-2005-Integration-Services---Part-40---Web-Service-Task.htm" style="font-family: verdana, arial, helvetica; font-size: 13px;">covered in detail on this forum</a></span><span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;">. 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.</span><br />
<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"><a href="http://www.databasejournal.com/features/mssql/sql-server-2008-web-services-script-task.html">http://www.databasejournal.com/features/mssql/sql-server-2008-web-services-script-task.html</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-37004225105849904482011-05-10T10:39:00.000+03:002011-05-10T10:39:03.177+03:00Day Zero with PowerShell + SQL<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;">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</span><br />
<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;"><br />
</span><br />
<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;"><a href="http://www.sqlservercentral.com/articles/powershell/73288/">http://www.sqlservercentral.com/articles/powershell/73288/</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-40087413917021619292011-05-09T18:20:00.000+03:002011-05-09T18:20:30.231+03:00Use ACE Drivers and PowerShell to Talk to Access and Excel<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;">Quit using deprecated JET drivers to talk to Microsoft Access and Excel. Learn how to use Windows PowerShell and ACE Drivers...</span><br />
<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;"><br />
</span><br />
<span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt; mso-ansi-language: RO; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: RO; mso-fareast-theme-font: minor-latin;"><a href="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</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-85991815555736588662011-05-05T18:09:00.000+03:002011-05-05T18:09:22.243+03:00Obtaining Identity Column Values in SQL Server<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;">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.</span><br />
<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: verdana, arial, helvetica; font-size: 13px;"><a href="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</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-32971541597188871652011-05-03T11:08:00.000+03:002011-05-03T11:08:32.147+03:00SQL Server Foreign Key Update and Delete Rules<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">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?</span><br />
<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 13px;"><a href="http://www.mssqltips.com/tip.asp?tip=2365">http://www.mssqltips.com/tip.asp?tip=2365</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-85577731385878769122011-04-12T11:16:00.000+03:002011-04-12T11:16:15.958+03:00Continuous Integration for SQL Server Databases<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">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).</span><br />
<a href="http://www.simple-talk.com/content/article.aspx?article=1247">http://www.simple-talk.com/content/article.aspx?article=1247</a><br />
<br />
<span class="Apple-style-span" style="color: #545454; font-family: Verdana, 'Lucida Grande', 'Lucida Sans Unicode', 'Lucida Sans', Helvetica, Arial, sans-serif; font-size: 13px; line-height: 18px;">You’re deploying it wrong!</span><br />
<a href="http://www.troyhunt.com/2010/11/you-deploying-it-wrong-teamcity.html">http://www.troyhunt.com/2010/11/you-deploying-it-wrong-teamcity.html</a>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-54734787726939262802010-10-26T12:08:00.000+03:002010-10-26T12:08:38.165+03:00Top 10 Mistakes When Building and Maintaining a Database<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: small;"><em>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.</em></span><br />
<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: small;"><em><br />
</em></span><br />
<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: small;"><em><a href="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</a></em></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-1327343558590370132010-09-29T08:29:00.000+03:002010-09-29T08:29:38.136+03:00Partition offset and allocation unit size of a disk for SQL Server<span class="Apple-style-span" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px;">SQL Server performance is dependent on the server resources available and disk performance is probably the most important resource. To maximize disk performance for SQL Server, I've always been told that the drive's partition offset must be set to 32K and the allocation unit size set to 64K for partitions that hold data and 8K for partitions that hold logs. How do I find out the allocation unit size and partition offset for my drives?.</span><br />
<span class="Apple-style-span" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px;"><a href="http://www.mssqltips.com/tip.asp?tip=2119">http://www.mssqltips.com/tip.asp?tip=2119</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-25974339171820182602010-09-02T11:09:00.000+03:002010-09-02T11:09:35.155+03:00How Old Are Your Database Statistics?<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;">Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having issues with poor query performance on a SQL Server 2005 instance on very good hardware. After having them run my standard SQL Server 2005 Diagnostic Information queries, nothing glaringly obvious was jumping out at me. Sure, there were a couple of missing indexes that needed to be added, but overall query performance was still pretty bad. The server as a whole was not under obvious CPU, memory, or IO pressure.</span><br />
<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"><br />
</span><br />
<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"><a href="http://www.sqlservercentral.com/blogs/glennberry/archive/2010/8/30/how-old-are-your-database-statistics_3F00_.aspx">http://www.sqlservercentral.com/blogs/glennberry/archive/2010/8/30/how-old-are-your-database-statistics_3F00_.aspx</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-54224992122446322692010-07-07T09:50:00.000+03:002010-07-07T09:50:27.260+03:00Restoring Exchange Server 2010 using Windows Server Backup<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">In my</span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"> </span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><a href="http://www.simple-talk.com/sysadmin/exchange/backing-up-exchange-2010-for-free/" style="color: #cc6633; text-decoration: none;" target="_blank">last article</a></span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"> </span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">we discussed how to benefit from the built-in</span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"> </span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><em>windows server backup </em></span><span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">feature of Windows 2008 and 2008 R2 and perform healthy backups of your Microsoft Exchange databases for free, without the need for any 3rd party tool. Today, we are going to go over the restore process by looking at two different situations; the first one is when we have experienced a complete loss of one database, and the second is when we need to recover just a single item from a mailbox.</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><br />
</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><a href="http://www.simple-talk.com/sysadmin/exchange/restoring-exchange-server-2010-using-windows-server-backup/?utm_source=simpletalkExchange&utm_medium=email-sysadmin&utm_content=Restoring-20100706&utm_campaign=Exchange">http://www.simple-talk.com/sysadmin/exchange/restoring-exchange-server-2010-using-windows-server-backup/?utm_source=simpletalkExchange&utm_medium=email-sysadmin&utm_content=Restoring-20100706&utm_campaign=Exchange</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-70888832516943198252010-06-07T08:47:00.000+03:002010-06-07T08:47:17.798+03:00Backing up Exchange 2010 For Free<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">It's hardly surprising that many SysAdmins are willing to pay over the odds for sophisticated backup solutions which they don't necessarily need, just to make sure their data is safe ASAP. Thankfully, Antoine Khater is here to give you a short and sweet walkthrough on how to keep your Exchange 2010 Server backed up for free. And the best news? You've already got everything you need.</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><br />
</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><a href="http://www.simple-talk.com/content/article.aspx?article=1040">http://www.simple-talk.com/content/article.aspx?article=1040</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-85482533042410094892010-06-03T17:13:00.000+03:002010-06-03T17:13:16.125+03:00High Performance Storage Systems for SQL Server<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">Rod Colledge turns his pessimistic mindset to storage systems, and describes the best way to configure the storage systems of SQL Servers for both performance and reliability. Even Rod gets a glint in his eye when he then goes on to describe the dazzling speed of solid-state storage, though he is quick to identify the risks.</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><br />
</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><a href="http://www.simple-talk.com/sql/performance/high-performance-storage-systems-for-sql-server/">http://www.simple-talk.com/sql/performance/high-performance-storage-systems-for-sql-server/</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-47702889342864455722010-06-03T12:32:00.000+03:002010-06-03T12:32:17.881+03:00Reliable Storage Systems for SQL Server<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;">By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><br />
</span><br />
<span class="Apple-style-span" style="color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px;"><a href="http://www.simple-talk.com/content/article.aspx?article=1027">http://www.simple-talk.com/content/article.aspx?article=1027</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-22635975934955712552010-05-19T11:35:00.000+03:002010-05-19T11:35:27.582+03:00Geocode Addresses in T-SQL<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"></span><br />
<div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.sqlservercentral.com/articles/geocode/70061/">This article shows how you can "geocode" street address information natively in T-SQL</a> with MS SQL 2005, and as a byproduct, how you can validate, normalize, and parse address information.</div><div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><em>Note that this approach will work in SQL 2008 as well, though SQL 2008 provides geospatial types and functions that could be used in lieu of the numeric data type used here.</em></div><div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">Geocoding is the process of converting a geographical address into latitude and longitude (GPS coordinates). Geocoding address information has a number of benefits:</div><ul style="list-style-position: outside; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-left: 1.3em;"><li>Means to interoperate with web-based mapping services</li>
<li>Means to interoperate with GPS devices</li>
<li>Makes it possible to calculate distance between addresses</li>
<li>Makes geospatial analysis possible (i.e. identifying geographically similar addresses, etc.</li>
<li>Compact way to represent a geographical location</li>
<li><em>And more...</em></li>
</ul>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-41896597069790187662010-04-26T17:06:00.002+03:002010-04-26T17:06:47.060+03:00Map IP Address to a Geographical Location<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;">On the Internet there is the concept of web site analytics that helps track all the visitors' activities and usage patterns. One of the dimensions to track is the geographical information of the visitors, which can be obtained by using the IP address information that is collected when a user lands on a Website.<a href="http://www.sqlservercentral.com/articles/SQL+Server/67215/"> In this article, I will describe a simple process that enables your reporting system to display the geographical information of the visitors.</a></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-75215453686239324432010-04-23T08:37:00.000+03:002010-04-23T08:37:43.974+03:00Help, my database is corrupt. Now what?<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"></span><br />
<div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">A corrupt database is probably one of most DBA's worst nightmares. It results in downtime, managers shouting and all other sorts of unpleasant things</div><div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.sqlservercentral.com/articles/Corruption/65804/">In this article, I'm going to explain some of the things not to do to a corrupt database, and then go through some of the things that should be done, some of the scenarios and the fixes for those.</a></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-43510624480775178842010-04-21T16:02:00.000+03:002010-04-21T16:02:44.058+03:00Reporting Services Disaster Recovery<span class="Apple-style-span" style="color: #2a2a2a; font-family: Arial, Helvetica, sans-serif; font-size: 13px;"></span><br />
<div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">Many organizations now rely on their reporting solutions for day-to-day business as much as the underlying OLTP systems. For some organizations, being able to report on data in real time can be as important as the availability of their underlying OLTP systems. So like any important database solution, you need to plan on how to recover your reporting solution quickly and efficiently, to keep your business running smoothly. For most medium and small companies, that will mean using the tools available to you with SQL Standard Edition.</div><div style="margin-bottom: 0.6em; margin-left: 0px; margin-right: 0px; margin-top: 0.6em; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"><a href="http://www.sqlservercentral.com/articles/Reporting+Services/69699/">In this article I will show you how to setup a Reporting Services solution that will allow you to quickly switch from one server to another, should your primary report server / report server database fail or should you need to switch your service to allow you to carry out server maintenance tasks, reducing downtime of the live system.</a></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-20721624092398306452010-02-03T18:20:00.001+02:002010-02-03T18:20:54.653+02:00Managing Data Growth in SQL Server<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; "> 'Help, my database ate my disk drives!'. Many DBAs spend most of their time dealing with variations of the problem of database processes consuming too much disk space. This happens because of errors such as incorrect configurations for recovery models, data growth for large objects and queries that overtax TempDB resources. Rodney describes, with some feeling, the errors that can lead to this sort of crisis for the working DBA, and their solution.</span><div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; "><br /></span></div><div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; "><a href="http://www.simple-talk.com/sql/database-administration/managing-data-growth-in-sql-server/?utm_source=simpletalk&utm_medium=email&utm_content=DataGrowth-20100125&utm_campaign=SQL">http://www.simple-talk.com/sql/database-administration/managing-data-growth-in-sql-server/?utm_source=simpletalk&utm_medium=email&utm_content=DataGrowth-20100125&utm_campaign=SQL</a></span></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-21055195644683011922010-02-03T18:17:00.002+02:002010-02-03T18:20:15.558+02:00Eating SQL Server Installations for Breakfast<div><span class="Apple-style-span" style=" color: rgb(51, 51, 51); line-height: 17px; font-family:Arial, Helvetica, sans-serif;font-size:12px;">Here you will find wholesome SQL Server installations on the menu, complete with Express, Continental and Deluxe breakfast choices, depending on your application’s appetite. This is the article where your new SQL Server installation is completely yours, having not as yet been turned over to the general populace of developers or users. Enjoy it while you can: From the <a href="http://www.amazon.com/SQL-Server-Tacklebox-Rodney-Landrum/dp/1906434255" style="text-decoration: none; color: rgb(204, 102, 51); ">SQL Server Tacklebox</a></span></div><div><a href="http://www.simple-talk.com/sql/database-administration/eating-sql-server-installations-for-breakfast/">http://www.simple-talk.com/sql/database-administration/eating-sql-server-installations-for-breakfast/</a></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-56468353822252227332010-01-29T10:33:00.000+02:002010-01-29T10:35:14.636+02:00Laying out SQL Code<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; ">It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?</span><div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; "><br /></span></div><div><span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); line-height: 17px; "><a href="http://www.simple-talk.com/sql/t-sql-programming/laying-out-sql-code/">http://www.simple-talk.com/sql/t-sql-programming/laying-out-sql-code/</a></span></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-73103522453827129522010-01-22T17:27:00.000+02:002010-01-22T17:28:46.333+02:00Uncovering Exchange 2010 Database Availability Groups (DAGs) (Part 2)<span class="Apple-style-span" style="font-family: Arial, sans-serif; color: rgb(51, 51, 51); font-size: 11px; line-height: 14px; ">In this part of this multi-part series, I will provide the steps necessary in order to prepare two servers to be used in a two DAG member solution. Both Exchange 2010 servers are placed in the same Active Directory site in the same datacenter. </span><div><span class="Apple-style-span" style="font-family:Arial, sans-serif;font-size:100%;color:#333333;"><span class="Apple-style-span" style="font-size: 11px; line-height: 14px;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:Arial, sans-serif;font-size:100%;color:#333333;"><span class="Apple-style-span" style="font-size: 11px; line-height: 14px;"><a href="http://www.msexchange.org/articles_tutorials/exchange-server-2010/high-availability-recovery/uncovering-exchange-2010-database-availability-groups-dags-part2.html">http://www.msexchange.org/articles_tutorials/exchange-server-2010/high-availability-recovery/uncovering-exchange-2010-database-availability-groups-dags-part2.html</a></span></span></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-65838530817285112722010-01-22T17:26:00.000+02:002010-01-22T17:27:51.115+02:00Uncovering Exchange 2010 Database Availability Groups (DAGs) (Part 1)<span class="Apple-style-span" style="font-family: Arial, sans-serif; border-collapse: collapse; color: rgb(51, 51, 51); font-size: 11px; line-height: 14px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">What an Exchange 2010 Database Availability Group (DAG) is all about and how this high availability feature may fit into your Exchange 2010 organization. Providing also step by step instructions on how to deploy DAG and other best practice recommendations.</span><div><span class="Apple-style-span" style="font-family:Arial, sans-serif;font-size:100%;color:#333333;"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 11px; line-height: 14px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:Arial, sans-serif;font-size:100%;color:#333333;"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 11px; line-height: 14px; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><a href="http://www.msexchange.org/articles_tutorials/exchange-server-2010/high-availability-recovery/uncovering-exchange-2010-database-availability-groups-dags-part1.html">http://www.msexchange.org/articles_tutorials/exchange-server-2010/high-availability-recovery/uncovering-exchange-2010-database-availability-groups-dags-part1.html</a></span></span></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-4020310334485772262010-01-22T08:19:00.000+02:002010-01-22T08:20:23.851+02:00Free Tools for the SQL Server DBA Part 2<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: rgb(42, 42, 42); "><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0.6em; margin-right: 0px; margin-bottom: 0.6em; margin-left: 0px; ">Welcome to the second edition of "Free Tools for the SQL Server DBA". It has been a while since the <a href="http://www.sqlservercentral.com/articles/Miscellaneous/2959/" target="_blank" style="text-decoration: none; color: rgb(34, 85, 136); ">original</a> article was published in May 2007. Since that time, the number of free tools for SQL Server has continued to grow even though some have disappeared. This article covers tools not included in the original article.</p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0.6em; margin-right: 0px; margin-bottom: 0.6em; margin-left: 0px; ">All tools listed are free with no known expiration date. In order to download them, some sites will require you to register which might result in a phone call or e-mail from the vendor. Some tools are free versions of vendor's purchasable software with features disabled. While others tools are on par or better than what you can purchase.</p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0.6em; margin-right: 0px; margin-bottom: 0.6em; margin-left: 0px; "><br /></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0.6em; margin-right: 0px; margin-bottom: 0.6em; margin-left: 0px; "><a href="http://www.sqlservercentral.com/articles/Tools/64908/">http://www.sqlservercentral.com/articles/Tools/64908/</a></p></span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-85596606047721801642010-01-15T11:39:00.000+02:002010-01-15T11:40:48.094+02:00Database Indexing Development Lifecycle...Say What?<span class="Apple-style-span" style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: small; "><a href="http://www.databasejournal.com/features/mssql/article.php/3855556/Database-Indexing-Development-LifecycleSay-What.htm">This is the first article of a series where I’ll be exploring Indexing Guidelines</a>. Having appropriate indexes on your database is critical in making sure your application is retrieving records quickly. However, having too many indexes can also slow down your application. In this series of articles, I hope to help you understand how to determine what columns you should consider for indexes, and how those columns should be used in indexes to optimize performance. In this first article, I will be discussing the indexing development lifecycle.</span>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0tag:blogger.com,1999:blog-854655384681562712.post-40437147302046414582010-01-04T15:56:00.000+02:002010-01-04T15:57:29.644+02:00Using SSIS to zip files and email the zipped files<span class="Apple-style-span" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: rgb(42, 42, 42); ">This article makes use of global variables throughout and shows how they can be used in SSIS, you can adapt these to make a package that can be made as flexible as you want. The package described here zips all files in a folder to a single archive zip file.</span><div><span class="Apple-style-span" style="font-family:Arial, Helvetica, sans-serif;font-size:100%;color:#2A2A2A;"><span class="Apple-style-span" style="font-size: 13px;"><br /></span></span></div><div><span class="Apple-style-span" style="font-family:Arial, Helvetica, sans-serif;font-size:100%;color:#2A2A2A;"><span class="Apple-style-span" style="font-size: 13px;"><a href="http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/">http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/</a></span></span></div>Doru Apostolescuhttp://www.blogger.com/profile/15060734097929561736noreply@blogger.com0