Browsing articles tagged with "sqlserver2008r2 - Admins Goodies"
Jan 23, 2013
tom

What’s the difference between shrinking files or database in SQL Server?

I need more space in my development environment and need to shrink my database (or files) in SQL Server. Should I chose “shrink files” or “shrink database” to free most disk space? Asked by Benny Skogberg If the database contains more than one data file, with the “Shrink Files” options you can choose which file you want to shrink; “Shrink Database” will shrink all of them. Answered by Massimo Check more discussion of this question. […]

Continue Reading »
Nov 8, 2012
tom

Advised auditing method for MS SQL to track changes made to a specific table by a specific user?

What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio? I’m using 2008 R2 Express Edition and want to specifically track a single user who logs in through Management studio and runs queries to make changes manually. I want to see what query was run and thus determine what was changed and how. I am not interested in […]

Continue Reading »
Oct 12, 2012
tom

Database Engine Services Required to install ssrs?

I have already installed sql server 2008 express and ssms on my vm… now I am trying to install ssrs on the same machine and keep getting “database engine error”. Should I skip this (click here please) I have tried to uninstall and reinstall several times… even with administrator’s mode, I get that error. Asked by Jackson Sunuwar (I am summarizing the comments in this answer so that it can be accepted. Thx.) The “default […]

Continue Reading »
May 31, 2012
tom

Parallel Processing in SQL Server 2008 R2

I want to run my 2(two) SQL Server 2008 R2 Enterprise Edition as if one server. If one server is too busy, system should direct the requests to other server. How can I do this? Thanks.. Asked by user741319 SQL Server does not support scale out functionality out of the box. Doing so is actually quite complex and typically requires a lot of application redesign in order to be done correctly. Are you sure that […]

Continue Reading »
May 25, 2012
tom

Is start-process supported in a powershell step on SQL Server 2008 R2?

With the described configuration, I have a SQL Agent Job that includes a Powershell step. That step throws an error when it gets to the line $app = start-process -passthru $program $program_args saying – “The error information returned by PowerShell is: ‘The term ‘start-process’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path […]

Continue Reading »
May 25, 2012
tom

What is the safest way to set up SQL Server for remote access?

I’d like to be able to make my dev database server accessible over the internet. I and half a dozen dev applications will be the only users. I have a hosting account that includes SQL Server, but I prefer to keep this for staging and production instances. FYI My set-up at home is an HP ML server with a 60MB (reasonably fast upstream) cable connection to the net. I’m using an Apple Extreme wifi router. […]

Continue Reading »
May 21, 2012
tom

Updating SQL Server 2008 R2 using slipstreamed source

I have a requirement to create a SQL Server 2008 R2 SP1 setup media. I have done this using slipstream method as recommended by Microsoft. I can only use this to create new installation. But is there a way I can use this media to update an existing SQL Server 2008 R2 instance? Asked by Dheena For an existing instance just apply the service pack, if you want to do this without user interaction, do […]

Continue Reading »
May 9, 2012
tom

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don’t want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL Server 2008 R2 Standard Evaluation to Web Edition? Obviously I need to put a licence on it. Can I just put the Web edition licence on it and it will become a Web Edition server or does it require […]

Continue Reading »
May 3, 2012
tom

SQL Server 2008 R2 Cluster with HOSTS file entries to active node on the application servers

I questioned the decision of a colleague concerning the use of a HOSTS file entry on an application server (standard SQL database backed .NET solution), which I think would cause connections to the SQL Cluster to connect only a single node in the SQL Cluster. In other words, the by using a HOSTS file entry like this…. 10.10.0.100 SQLCLUSTER …when the IP address above is the IP address of the active node in the SQL […]

Continue Reading »
Apr 24, 2012
tom

Backup for SQL & Server 2008 R2?

What’s the best/easiest backup solution for my use case? Windows Server 2008 R2 Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database Stores user’s files for them (i.e. it’s also a file server) We want to be able to rotate 2 external disks (one on-site, one off-site; swapped weekly) Asked by David Going to assume the data is less than 2TB. If so you could […]

Continue Reading »