Duluth, GA
+ 678-753-4494
contact@datahills.us

Compare features in different High Availability options in Sql Server.

  • Posted by Sqltimes
  • On September 20, 2011
  • 0 Comments
Since Sql Server 2005, High Availability (HA) has become very easy to implement in a Sql Server environment. Also, starting Sql 2005, there are 4 methods to implement HA. Failover Clustering Database Mirroring Replication Log Shipping Though, Failover clustering still is the most popular option, my guess is the other options might make it a […]
Read More
 

Use Backup Stripe to improve backup performance

  • Posted by Sqltimes
  • On September 20, 2011
  • 0 Comments
Recently, I used this very powerful backup method and have seen significant improvement in backup speed. So I wanted to share it with everyone. When I did backups, I used to take entire backup to one backup disk location using the standard BACKUP command shown below. If the database is large the backup process could […]
Read More
 

Use Query Governor to Prevent Long Running Queries

  • Posted by Sqltimes
  • On September 20, 2011
  • 0 Comments
Today I learned about a new instance level option, its called Query Governor. Looks like its been an available feature for a while, but I never heard of it before. This setting allows you to prevent any queries running longer than a predetermined set value. Any query that has a running cost value more that […]
Read More
 

Sql Server 2008 new features Compression, FILESTREAM and TDE compatibility with with all High Availability (HA) options

  • Posted by Sqltimes
  • On September 18, 2011
  • 0 Comments
Some of the new features in Sql Server 2008 are very useful (and long over due). Features like: Compression FileStream TDE (Transparent Data Encryption). Though they have their own limitations, they are very useful when available natively. Here we’ll look into their compatibility with existing High Availability (HA) features. FailOver Clustering Database Mirroring Replication Log […]
Read More
 

Sql Server 2008 new features Compression, TDE and FILESTREAM compatibility with each other.

  • Posted by Sqltimes
  • On September 18, 2011
  • 0 Comments
In previous two posts, (comparison with HA and other features) we looked at the new features compatibility with other existing features like Replication, Database Mirroring, Database Snapsho, etc.. Now we look at their compatibility with each other. Can you configure FILESTREAM filegroup on a database set of Compression? Is Compression allowed on a database encrypted […]
Read More
 

Sql Server 2008 new features TDE, FILESTREAM and Compression compatibility with other features.

  • Posted by Sqltimes
  • On September 18, 2011
  • 0 Comments
In the previous post we saw the compatibility of new features like TDE, FILESTREAM and Compression with High Availability (HA) options. Now we continue the compatibility matrix with other existing features.   Compression FileStream TDE Database Snapshot Y No Y Full Text Indexing Y Y Y Note: Sql Server does not support Database Snapshot for […]
Read More
 

Generate Numbers in a Sequence using one T-Sql Query

  • Posted by Sqltimes
  • On September 4, 2011
  • 0 Comments
I have always found myself in need to generate numbers in a sequence. But as a DBA, I did not want to do it procedurally with a ‘WHILE loop with increment’. So I wrote this cool script that uses receurice CTEs. Hope it is helpful to you as it’s been for me. DECLARE @n INT […]
Read More
 

DBA Interview Question

  • Posted by Sqltimes
  • On September 4, 2011
  • 0 Comments
A few days ago, I saw a set of good interview questions to ask a DBA. I want to post answer to “10. Solve the FizzBuzz problem with SQL code“ DECLARE   @n  INT = 25 ;WITH MyCTE (Num) AS ( SELECT 1 AS [Num] UNION ALL SELECT Num + 1 AS [Num] FROM MyCTE WHERE Num […]
Read More