January 21, 2010 10:00 AM
Posted by: Colin Smith
Cluster,
MS SQL,
MSSQL Administration,
ReplicationI have a customer who would like to have a couple things. They would like to have, above all, HA. Secondly they would like to be able to configure the application to write to one database and read from another. They want to do this to boost performance as they feel that IO may be an issue. I...
January 8, 2010 7:19 PM
Posted by: Colin Smith
MS SQL Server,
MSSQL Administration,
MSSQL Instance,
Powershell,
ScriptingAs I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...
October 27, 2009 3:30 AM
Posted by: Colin Smith
Cluster,
MSSQL,
MSSQL Administration,
MSSQL Install,
MSSQL Server,
SQL Server 2008Last week I got the chance to work on an Active, Active, Active SQL Server 2008 Cluster install. This was new to me and very fun. We have three physical hosts all using SQL Server 2008 Enterprise Edition. The Servers are also running Windows Server 2008 Enterprise Edition. I worked with one of our...
October 26, 2009 4:26 PM
Posted by: Colin Smith
MS SQL Admin,
MS SQL Server,
MS SQL Troubleshooting,
MSSQL Administration,
SQL Server 2005Just got a call that three databases on an instance where many reside were not accessible. Users were getting errors about not enough disk, memory, or the files were inaccessible. I logged into the server and found that the databases were not offline but could not be accessed. I looked into the...
September 16, 2009 3:23 PM
Posted by: Colin Smith
MSSQL,
MSSQL Administration,
MSSQL Install,
MSSQL ServerYesterday I had to install SQL Server 2008 for the first time. I went through it on a development server first before installing on a production server. As I went through the setup process I noticed one thing that I think is long overdue. The Database Configuration step is a great addition to the...
August 28, 2009 7:12 PM
Posted by: Colin Smith
MS SQL Server,
MSSQL Administration,
PowershellI have been asked to write a script that will allow users to connect to a server, get a list of only the jobs that I want them to see, and execute only those jobs. No options to do anything other than execute the job. This is what I have come up...
August 27, 2009 3:13 PM
Posted by: Colin Smith
Answers,
MS SQL,
MS SQL Server,
MSSQL Administration,
Powershell,
Powershell Tips,
SQL ServerI recieved a comment that contained a question about my previous post about writing a script to output a health check of SQL Server.
http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/
The following is the question:
should we make anychanges for this do...
July 28, 2009 10:18 PM
Posted by: Colin Smith
Database Administration,
MSSQL,
MSSQL Administration,
MSSQL Server,
Reporting ServicesI have been asked to help with Migrating a SQL Server 2005 Reporting Services server from one host to another. I set up a couple VM's and away I went. I found that it is pretty straight forward though. I did run into a couple little hickups along the way but nothing to dificult. I did have a...
July 21, 2009 3:29 PM
Posted by: Colin Smith
Database Administration,
Education,
MSSQL Administration,
MSSQL Server,
SQL ServerI found this nice article that I thought I should pass on regarding Learning SQL Server 2008.
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1361184,00.html?track=sy41
The article talks about key features and enhancments from SQL Server 2005, BI, Security, and more good...
