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....
2010-03-18
2,663 reads
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...
2010-02-08
1,703 reads
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...
2010-02-01
2,483 reads
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...
2009-12-16
2,636 reads
Blogs
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Forums
Cannot UtilizeConnection via SSH from MS Sql Server to Postgresql DB (SSMS, SSIS
I have an SSIS project that I am trying to deploy. When I run...
Help to optimize select query
Need help to rewrite the query for faster result. use ABC_DB; SELECT c.otherID, a.shortname,...
Help to optimize select query
Need help to rewrite the query for faster performance. use ABC_DB; SELECT c.otherID, a.shortname,...
Ask SSC