Who is online?  0 guests and 0 members
Home  »  Blogs  »  sqlscottgleason

Communifire Blogs

Blogs RSS Feed

sqlscottgleason : Most Recent postings

sqlscottgleason

RDL managment

7/12/2012 by sqlscottgleason  -  Comments: 1  -  Views: [1259]

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

sqlscottgleason

PowerShell to reclusively delete .bak and .txt files older than 5 days.

6/12/2012 by sqlscottgleason  -  Comments: 0  -  Views: [11363]

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...

Read More

sqlscottgleason

Sql 2005 rebuildig the Master Database

3/15/2011 by sqlscottgleason  -  Comments: 0  -  Views: [2489]

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...

Read More

sqlscottgleason

msmqtask.dll left over from a SQL 2005 32 bit install.

10/27/2010 by sqlscottgleason  -  Comments: 2  -  Views: [6388]

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...

Read More

sqlscottgleason

How to attach a database without a log file

9/29/2010 by sqlscottgleason  -  Comments: 3  -  Views: [4626]

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...

Read More

sqlscottgleason

Breaking In (Entry level advice)

9/20/2010 by sqlscottgleason  -  Comments: 5  -  Views: [38179]

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...

Read More

sqlscottgleason

Sql Super Hero’s Cave of Best Practices

8/15/2010 by sqlscottgleason  -  Comments: 2  -  Views: [4597]

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.

Read More

sqlscottgleason

SQL Saturday Wiki by Scott Gleason

7/27/2010 by sqlscottgleason  -  Comments: 1  -  Views: [3752]

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...

Read More

sqlscottgleason

Why didn't I fire that person?

7/1/2010 by sqlscottgleason  -  Comments: 8  -  Views: [1945]

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...

Read More

sqlscottgleason

Jacksonville's Sql Saturday #38

5/5/2010 by sqlscottgleason  -  Comments: 0  -  Views: [1495]

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...

Read More

sqlscottgleason

How to Transfer SQL Logins Between SQL Servers

1/26/2010 by sqlscottgleason  -  Comments: 0  -  Views: [23506]

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 ...

Read More

sqlscottgleason

What three events brought you here?

1/17/2010 by sqlscottgleason  -  Comments: 2  -  Views: [6702]

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...

Read More

sqlscottgleason

Configure Group Policy to keep RDP session to a minimum on your SSIS boxes.

1/4/2010 by sqlscottgleason  -  Comments: 1  -  Views: [5251]

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...

Read More

sqlscottgleason

Where are my “Indent” and “Un Indent” icons within Bids “Script Task Editor”?

12/15/2009 by sqlscottgleason  -  Comments: 3  -  Views: [3465]

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...

Read More

Page 1 of 1 (14 items)