Here is a bit of code, adapted from Nigel Rivett's original. You can use this to copy one database over another or restore the most recent database over itself.
WARNING: Use caution in running scripts you find on the internet. You are responsible for the well being of your systems!
We're sitting around waiting for the SAN monkeys to fling some crap our way - not the SAN guys, the SAN monkeys, kinda like gremlins, but not as bad. Our … Continue Reading ››
When a cube fails to process, you don't want to hear it from your customer. As the last step in our datawarehouse load, I was processing a cube, using the script generated from the SSMS dialog. That was working fine most of the time, but sometimes we'd have a development failure after some … Continue Reading ››
I'm getting a little tired of always clicking around in SSMS. Here goes a shot at powershell. I've done a few tutorials on powershell, but don't use it enough to remember. The only thing I remember is Get-Child-Items and it's alias GCI. That's a start. Follow along with me.
This cursor inserts all of the roles and members from each database into your admin database.
USE [SQL_DBA_Sandbox] GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Roles]( [DBName] [varchar](max) NULL, [Role] [varchar](max) NULL, [Member] [varchar](max) NULL ) ON [PRIMARY] END ELSE Continue Reading ››
I've one-upped Brent on one point. We have an SSIS package which restores databases from server to server using our DBA_REP databases which I borrowed from Continue Reading ››
I'm trying to set up reporting services 2005 to use ssl with a 2008 instance also on the same machine also using ssl. I'm trying to use the simple method of changing the ssl port of the 2005 site. The website's ssl certificate seems valid when I go to the /Reports … Continue Reading ››
This weekend I'll be upgrading a copy of our 2005 instance to 2008. Upgrading the copy will let us fall back to the old version if needed. (update: and yes, we had to, see notes below).
I opted to create a new instance on another server - apart from our clustered SQL engine. … Continue Reading ››
IIS reserves port 80. SQL 2008 reporting services is now using it's own 'web server' - HTTP.sys. In reporting services configuration manager change the Report Manager URL advanced settings. In the 'Multiple Identities for Report Manager', edit the entry and change the TCP Port to not be 80. Common alternates are 8080 or 8000. Continue Reading ››