Pretty much we all know that you can use SSRS to manage your reports, but when it comes to transfering rdls that (2005/2008) limits you to one rdl at a time. Were you aware that the RDL files are actually stored as XML inside the Reports database? and you can query them straight out of the database: SELECT [Path] , [Name] , SourceCode = CAST ( CAST ( content AS VARBINARY ( max )) AS XML ) FROM ReportServer . dbo . Catalog WHERE Type IN ( 2 , 6 ) ORDER BY Path , Type , Name You can also use some ...
Read More
I ran across a server that has backups being generated and it doesn’t have any maintenance plans created on the server itself. The backups are being created from some external source. The disk drives are being filled up as there is nothing that is deleting these backup files that keep getting created each night. So I had to solve two issues; 1. Delete the old backups 2. Find out what is causing backups to be created each night. (I'll post another blog and how I find what cuasing those back...
I do a lot of builds during the week and once in a blue moon, I select the wrong collation setting But thats not an issue with the following script that will rebuild the master database. Just replace the [] brackes with you own path and set a very strong SA password. start /wait [path to your sql 2005 sofwtare]\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[Enter a very stong passwrod here] SQLCOLLATION=SQL_Latin1_General_CP850_BIN Use this start /wait setup...
Recently I got this error while installing SQL Server 2005 64 bit on a machine where previously SQL Server 2005 32 bit was installed: 1. Open Administrative Tools \ Component Services 2. Go to Component Services\Computers\My Computer\COM+ Applications 3. Delete Microsoft.SqlServer.MSMQTask Full credit to Vivek Thakur at codeasp.net for his orginal blog post : http://codeasp.net/blogs/vivek_iit/microsoft-net/440/sql-server-install-error-one-or-more-of-the-components-being-installed-are-already-re...
This collection of notes/scripts orginally came from SQLTeam ( http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187 ) EXEC sp_attach_single_file_db @dbname = 'DBNAME', @physname = 'location\DBNAME.mdf' OR 1. Create a new database with the same name and same MDF and LDF files 2. Stop sql server and rename the existing MDF to a new one and copy the original MDF to this location and delete the LDF files. 3. Start SQL Server 4. Now your database will be marked suspect 5. Update the sysdatabases to...
How does one get started in a technical field? One thing that I see from time to time is someone who just keeps taking class after class hoping that a resume full of classes will make their resume took impressive enough that a hiring manager will take a chance on them. And that is a key phrase you DON'T want 'take a chance on me', this signifies risk. Please don't use those words during a job interview. What entry level people should do is focus on three key areas only: education, experience, an...
So I've been seeing a few funny videos about the IPhone4 VRS EVO on youtube. I thought I could make a video.. here is my first stab. Sql Super Hero’s Cave of Best Practices http://www.youtube.com/watch?v=SZRWAaDVmAs Thanks to Brent Ozard for letting me know the link did'nt go to you tube. :-) It is fixed now.
If you didn’t catch Patrick's post on SQL Saturday Wiki , I'd suggest you give it a quick read. The SQL Saturday Wiki will be an excellent tool to help first time and repeat organizers of SQL Saturday events. We really did pour as much as we could into a one day "Lock Down / Brain dump" event at "The GodFather's" lab of evil, but I think the real value of this Wiki will be when more and more event organizers put down their lessons learned into this tool. Not ever SQL Saturday is the same but the...
So the big, really-bad, cry-yourself to sleep, "you'll get automatically fired if you do this" thing happened at work this week. Here is a snippet of the back ground story... [on second thought.. I've removed the details of what happened, but from the opening sentence.. you can imagine] A few of the people that work for me were a bit confused as to why I didn’t auto-fire the person that made the mistake. I even surprised myself by how quickly I made the decision that I was not going to fire this...
Brain, Devin, Myself, great speakers, and an army of volunteers are all gearing up for Jacksonville's 3rd annual SQL Saturday! May 8 th at UNF http://www.sqlsaturday.com/38/eventhome.aspx We’d ask that if you have signed up and are not able to attend, please remove yourself from the list so that people on the waiting list will be able to get name badges and we won’t have any food waste. Some really smart and energetic speakers will be presenting their best sessions. Please be sure to check the s...
If your building a new sql server, you'll need to move the SQL user accounts and their passwords to the new server. This works for sql 2005 and sql 2008 servers. Here is the link to the orginal article http://support.microsoft.com/kb/918992 This article describes how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. For more information about how to transfer the logins and the passwords between instances ...
Recently Paul Randal posted What three events brought you here ? He bascially ask "what three life-direction-changing-events" have brought you to where you are today? Which is a very interesting question that comes up from time to time at the 'After Event' for the Jacksonville SQL Server Users Group. I'm always interested in people's stories of how they became DBAs. While most of the stories I hear are of Accidental DBAism, the details of the story are never the same and are very intresting. Aft...
Configure Group Policy to keep RDP session to a minimum on your SSIS boxes Active Directory Group Polices overwrite local policies on a windows server. With that fact in mind, if you know that here are no AD policies for RDP Session time limits, and you have admin privileges to the local box, and you need to introduce some type of time restrictions on the RDP session; this might be exactly what you are looking for. Before we begin, I do need to bring up the old warning: Don’t implement this in p...
Where are my “Indent” and “Un Indent” icons within Bids “Script Task Editor”? On the default toolbar, you have comment and uncomment code, but Indent and Un Indent are missing. You'll have to customize your tool bar and add them. From the Menu click thru View -> Toolbars -> Customize… Within your Customize Window, select “Edit” from the Categories: window and then scroll in the Commands window until you see “Line Indent” Now click and Drag the “Line Indent” icon up to your Standard tool ba...