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
- Interests: SQL Server, watching and playing tennis, reading books
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
Daily Coping 28 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
The DBA as a helpdesk.
Every one and again you will see people asking What skill do you think...
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Update table FirstName & LastName from Email addresses
I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...
SQL Instance Aliases - Urgent assistance needed please
I have a migration problem. I cannot get my SQL Server instance aliases to...
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
Ask SSC