Additional Articles

SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.

by Additional Articles

MSSQLTips.com

SQL Server 2008

SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios.

2010-05-05

3,353 reads

Using REPLACE in an UPDATE statement

by Additional Articles

SQLTeam.com

T-SQL

This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

2010-05-03

7,932 reads

A Perspective on Database Performance Tuning

by Additional Articles

Database Journal

Performance Tuning

Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer or systems administrator.

2010-04-30

5,074 reads

Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2

by Additional Articles

MSSQLTips.com

Security

As I am new to Windows Server 2008 R2 it would be great if you can let me know the step by step approach to enable the default port of SQL Server 2008 Analysis Services in Windows Firewall for user connectivity.

2010-04-29

2,698 reads

Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.

2010-04-28

2,955 reads

SQLCLR function to return free space for all drives on a server

by Additional Articles

MSSQLTips.com

SQLCLR

When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.

2010-04-27

3,390 reads

How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster

by Additional Articles

Database Journal

Clustering

Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.

2010-04-26

2,048 reads

Retrieve Default SQL Server Backup Folder using PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?

2010-04-23

2,763 reads

Basic Defensive Database Programming Techniques

by Additional Articles

SimpleTalk

T-SQL

We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.

2010-04-22

5,476 reads

Using Full Text Search in SQL Server 2008

by Additional Articles

SQL Server Performance

Full-Text Search (2008)

SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in a SQL Server table

2010-04-21

3,143 reads

All authors

Additional Articles

SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.

Using REPLACE in an UPDATE statement

A Perspective on Database Performance Tuning

Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Server 2008 R2

Consolidating SQL Server Error Logs from Multiple Instances Using SSIS

SQLCLR function to return free space for all drives on a server

How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster

Retrieve Default SQL Server Backup Folder using PowerShell

Basic Defensive Database Programming Techniques

Using Full Text Search in SQL Server 2008

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

A Cloud Dependency Failure from Amazon

Deploying AI in logistics (the unfiltered version)

Forums

CDM Bank BCA 9055-Maricaya TLP/WA 08218573837

BCA KCP Bandung Electronic Centre Telp/wa 085169998765

BCA KCP Menara Thamrin Telpon/wa:0813.7887.595

Question of the Day

Creating a JSON Document III