SQL Server Central

Scripting database objects in SQL Server 2008

In this article, we would go through the steps to script the objects in a database using SQL Server 2008. This might be required when we need to setup a database similar in structure to your existing database and move the data at a later time. Situations... Read More...

By Bru Medishetty in Full Throttle | 03-15-2010 5:38 AM | Categories: Filed under: SQL Server 2008, Tips

Rating: |

Discuss | 2,916 Reads | 9 comment(s)

Performing SSAS Database Backup

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in the object explorer, select the database that needs to be backed up. Right click the database and from the pop-up menu choose... Read More...

By Bru Medishetty in Full Throttle | 02-01-2010 6:03 AM | Categories: Filed under: Backups, SSAS

Rating: |

Discuss | 2,259 Reads | 4 comment(s)

Concatenating Strings to NULL values

We recently ran into this situation of reports containing nothing but blank spaces. When investigated the reason was that the String concatenation statement was written as a general statement. There is nothing wrong in the statement, it works fine when... Read More...

By Bru Medishetty in Full Throttle | 01-25-2010 8:04 AM | Categories: Filed under: NULL, T-SQL, Strings

Rating: |

Discuss | 3,986 Reads | 14 comment(s)

Microsoft Baseline Security Analyser

Recently I had a task to check all SQL Servers from security perspective and ran into Microsoft Baseline Security Analyser. It is a tool that is easy to install and use, find the Security vulnerabilities on all Windows Servers. The latest version of this... Read More...

By Bru Medishetty in Full Throttle | 01-11-2010 10:08 AM | Categories: Filed under: vulnerability, Security

Rating: (not yet rated) Rate this |

Discuss | 1,025 Reads | no comments

Quick look at Table Compression in SQL Server 2008

SQL Server 2008 has introduced many enhancements and one of them is table compression. In this blog, we shall look at how to enable compression on an existing table in as few steps as possible. Right click on the table. From the pop up menu go to Storage... Read More...

By Bru Medishetty in Full Throttle | 12-30-2009 12:54 AM | Categories: Filed under: SQL Server 2008, Compression, New Features in SQL 2008

Rating: |

Discuss | 1,601 Reads | 1 comment(s)

Perform a Striped Backup

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to perform a backup to a single file. In such cases, a striped database backup can be performed, that enables user to choose to place the backup... Read More...

By Bru Medishetty in Full Throttle | 12-14-2009 2:30 PM | Categories: Filed under: Striped backups, Database Administration, Backups

Rating: |

Discuss | 2,960 Reads | 12 comment(s)

Search

Scripting database objects in SQL Server 2008

Performing SSAS Database Backup

Concatenating Strings to NULL values

Microsoft Baseline Security Analyser

Quick look at Table Compression in SQL Server 2008

Perform a Striped Backup