InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:56:29 GMT20http://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxIs it me, or are the posted questions getting worse these days?I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server.It seems like the general feeling of a lot of DBA's (term used loosely) these days is that they do not need to learn anything by reading or studying and they should simply post questions without doing any work themselves. I would expect that they can click the search button at least once before posting a question in a forum.Anyone else disappointed lately, or am I just getting bitter?Tue, 18 Nov 2008 06:31:49 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic1453886-61-1.aspxGuys, by far, any chance any one of you know about any such great user friendly forums for sybase ? I have tried searching many but no one is half as cool as sqlservercentral. There are few but those are dead forums with either you not getting any response for weeks and/or months.Also is it possible to extend this forum for sybase as well (because it is pretty similar to our love sql server) ? Though I know it's a competitor.Fri, 17 May 2013 01:52:25 GMTsqlnaivehttp://www.sqlservercentral.com/Forums/Topic835391-61-1.aspxOkay, a topic that has NOTHING to do with SQL . . .Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions, and it got me thinking . . .I am a HUGE baseball fan!!! To me, Cooperstown is Mecca. I have been known to schedule vacations around MLB schedules. (Seriously!)So, just curious: any other baseball fans here?I, personally, am an unashamed follower of the Evil Empire (a.k.a. NY Yankees)!Wed, 16 Dec 2009 12:42:42 GMTRay Khttp://www.sqlservercentral.com/Forums/Topic812849-61-1.aspxHI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene or a word running through your mind...Jump on that word...And.Post it here by it's thumbs! :hat: Quickly! Before it becomes a number![url=http://www.tech-loisir.com/piscine-bois-g.asp]piscine en bois[/url] - [url=http://www.formationsdistance.com/Formation-distance-France.asp]Formation à distance en France[/url]Tue, 03 Nov 2009 04:00:13 GMTpaglamolomhttp://www.sqlservercentral.com/Forums/Topic1452880-61-1.aspxIs SQL becoming outdated soon ??? AS new LINQ is all around us....Tue, 14 May 2013 16:59:15 GMTGoGreenhttp://www.sqlservercentral.com/Forums/Topic1308613-61-1.aspxOn popular request - at least one! - a dedicated topic about beer. I shall start with my favorite beer: Duvel.It is of course a Belgian beer, as I am from Belgium and it's really the only thing we can be chauvinistic about.[img]http://www.sqlservercentral.com/Forums/Attachment11651.aspx[/img]The name is Dutch slang for "devil". Probably because it looks innocent with it's blonde look, but it's alcohol percentage can kick you right off your feet if you're not careful. :-)[img]http://www.sqlservercentral.com/Forums/Attachment11654.aspx[/img]I welcome everyone to post their favorite beer as well, perhaps accompanied with a small explanation.p.s.: anyone menioning Corona, Desperado or Heineken gets -10000 points :-)edit: fixed image sizesWed, 30 May 2012 14:26:16 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1445140-61-1.aspxI am looking for a Crystal Reports version 8 user guide. I have done an exhaustive google search with no luck. Anyone have a link or a copy on a 3.5 floppy somewhere?Mon, 22 Apr 2013 13:23:28 GMTAlan.Bhttp://www.sqlservercentral.com/Forums/Topic1449893-61-1.aspxI am a growing DBA fanatic, and i am looking to get very involved with databases in the future. I am transferring to a university in the upcoming months, and looking for advice for degrees.I am look at a couple choices either a Computer Information System(CIS) degree.I already have my associates in this major, and in universities it seems to be more business oriented. And then there is a Computer Science(CS) degree. Im not sure if either one is geared more toward databases or not. I am hoping to get some opinions from all ranges of DBA, professional, growing, and barely starting. Thanks!MarcelloMon, 06 May 2013 15:00:38 GMTdroogies_cahttp://www.sqlservercentral.com/Forums/Topic1392724-61-1.aspxAnyone using this tool, and if so - is anyone using this tool at verion 1.9.1.619 with SQL Authentication, successfully? If you are - can you please tell me what the database engine service is using to login with? I am having a devil of a time getting it to work in anything other than my local instance. I need it for some other instances that I attach to, but it isn't working on any of those - getting login errors leading me to believe that I need to set the database engine service up with something else.SQL Server 2005, and 2008 R2 are having this issue. No issue in SQL 2012,but that uses a login for the database engine called [b]NT Service\MSSQL$SQL2012_DEV[/b] and I do not have anything equivalent to that in either of the other 2 (from what I can tell).Thanks!Tue, 04 Dec 2012 15:12:14 GMTSQL_ME_RICHhttp://www.sqlservercentral.com/Forums/Topic1443958-61-1.aspx...but this made me laugh today...Seen in some production code:[code="sql"] LEFT OUTER JOIN [highlight="#ffff11"]Northwind[/highlight].dbo.orders_actioned ON scheme.opheadm.order_no = [highlight="#ffff11"]Northwind[/highlight].dbo.orders_actioned.order_no[/code]...just WOW!Thu, 18 Apr 2013 09:43:06 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1442917-61-1.aspxHi,How can i check whether "Microsoft visual source safe" is installed or not on my machine?? I have Microsoft visual studio 2005,2008 already installed on my machine. does visual source safe come along with visual studio ?? or shall i have to install it separately ??I googled this but not got any credible answers, so i came here!!please suggest!!Tue, 16 Apr 2013 12:12:31 GMTtinnusqlserverhttp://www.sqlservercentral.com/Forums/Topic1415691-61-1.aspxI want to hear some comments on "Featurs of NO SQL" from the mouth of actual sql developers / sql world (Sql Server Central).Tue, 05 Feb 2013 03:43:09 GMTkarthik Mhttp://www.sqlservercentral.com/Forums/Topic1437204-61-1.aspxWhile this is not related to sql server I imagine that many database administrators have had to deal with this scenario. My company just switched banks and we have to meet security requirements to upload check files to their SFTP site. We have finished the formatting for the flat text file and once the accounting department has created the file they will need to upload. To make the process simple for the accounting department users I have created a virtual machine with a secured share that they can dump the file into. Every 15 minutes I have a scheduled task that will run and move the files to a directory where the files will be further secured and encrypted. Once every hour a scheduled sftp job will run using an application called cuteftp to the new bank. The problem I am having is getting the files in the directory encrypted. I have tried using Symantec's PGP encryption software but keep coming across problems. Can someone recommend a command line pgp tool where I can generate my own public and private keys and also sign the files we will be uploading to the bank with the public keys they have provided?Any other thoughts are also welcomed. Thank you.Sat, 30 Mar 2013 10:11:13 GMTkwoznicahttp://www.sqlservercentral.com/Forums/Topic1433154-61-1.aspxThis thread has been long overdue. Post anything related to snowboarding: your number of days, your gear, new purchases, upcoming trips...Wed, 20 Mar 2013 06:01:35 GMTGrumpy DBAhttp://www.sqlservercentral.com/Forums/Topic338319-61-1.aspxDoes anybody have an Access database, or SQL Server database that has been created to house baseball statistics ?Fri, 19 Jan 2007 12:49:00 GMTEd Heinsiushttp://www.sqlservercentral.com/Forums/Topic1438578-61-1.aspxHi,So, even though my company has nothing to do with telemarketing, we've been asked to bump phone numbers for one project up against the national DNC list. It's a whopper. I'm running into some issues, and I was hoping someone here has either worked with it, or maybe has some pointers in working with a file this large (2.5gb text file :w00t:)I guess first off, here's how I'm trying to load it, though the create table syntax isn't set in stone:[code="sql"]CREATE TABLE blah.dbo.nationaldnc (area nvarchar (3) NOT NULL, phonenumber varchar(8000) NOT NULL) BULK INSERT blah.dbo.nationaldnc FROM '\\myserver\Sample\2013-4-3_Global_18B81869-3F4C-4C1F-BF46-FF33984D9900.txt' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '', BATCHSIZE = 100000)[/code]This is how the file is set up, per donotcall.gov[quote]The Full List in a Flat Text File has one three-digit area code, a comma, and a seven-digit telephone number per line, with a linefeed at the end of each line:123,4567890 123,4567890 123,4567890[/quote]My problems are:When I use anything other than nvarchar(max) for the second column, I get truncation errors. That makes me think that I'm using the wrong row terminator. However I'm not sure how to use char(10) for it, since just writing in char(10) doesn't seem to work.The other will likely be when bumping the phone list up against it, how to write the least harsh query. I have stored procedures that do it with our internal do not contact list, but it's so much smaller than this that I'm not sure they'll scale. I'll post those second, as it's somewhat long.Any ideas or suggestions would be welcomed.ThanksWed, 03 Apr 2013 14:42:28 GMTerikdhttp://www.sqlservercentral.com/Forums/Topic1428671-61-1.aspxOnce a year I help out a local non profit promote their annual event. This is the third year for doing it, and I just wanted some peer review to see if you'd have recommendations to do it differently.Right now, the whole thing is a full on DBA process, which requires my well rounded skills. I'd like to change this to a process where any end user could send out an eblast without it being a html developer + DBA required to do the grunt work.Does anyone use a program for sending stuff out like this? How do YOU do it? homemade app? web page? off the shelf app? I'd like to hear some suggestionsHere's my current process, the gory details are not really needed as far as script examples, i think:We've got a typical contact database with a few thousand contacts.We have a meeting where non-technical people say what they want in the email, and i will create a nice looking html email, with images and nice design, blah blah, but with placeholders for find-and-replace for personalizing the emails.ill stick the html into a table via a basic insert.Later, when we are ready to actually send it out: I select the html into a varchar(max) @HTMLBody for the body of the email. I create a cursor to loop thru the rows of the contacts to be spammed....er asked for donations. Find and replace placeholders to personalize the message to the contact int eh cursor ie REPLACE'[FirstName],@Firstname) for things like firstname/lastname/email/phone/etc. each email is sent via sp_send_dbmail to send out individualized messages.After it's all done,I'll end up reviewing msdb.dbo.sysmail_allitems and sysmail_faileditems for progress and issues. Contsantly rerunning the same query to see the unsent items dwindle down to zero.Fri, 08 Mar 2013 09:59:26 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1436490-61-1.aspxFor MS SQL Server, what does the Microsoft Update tool actually update?I had assumed that it would update the version of SQL server installed to the latest service pack. It turns out I was wrong - very wrong.Here's what Microsoft has to say:[url=http://update.microsoft.com/microsoftupdate/v6/about.aspx]Link[/url][quote][b]Which products does Microsoft Update support?[/b]In addition to Windows updates, the Microsoft Update website offers updates for some Microsoft products, including Microsoft Office 2003, Office XP, Microsoft Exchange Server, and Microsoft SQL Server. Typically, only updates for the latest version of each product are offered.[/quote]What does "Typically" mean here? Does it mean ONLY the latest service pack of each major version (e.g. 10.50.4000+, 11.0.3000+, etc.) or only the latest service pack of the latest version (11.0+)?Thu, 28 Mar 2013 08:14:36 GMTJon Cooneyhttp://www.sqlservercentral.com/Forums/Topic637018-61-1.aspxHaving only ever done MS SQL I don’t know a great deal about Oracle. There are a few Oracle DBAs where I work and I'm sick of them telling me its better.I Wanted to ask you guys which in your personal opinion is a batter database?Based on performance, usability, reliability, support based on same hardware spec.versions - Oracle 11g or sql 2k5thanks in advance..Thu, 15 Jan 2009 06:05:06 GMThb21l6http://www.sqlservercentral.com/Forums/Topic1434577-61-1.aspxI am working in a electronics company in sql reporting from past 6 month .we here generate small reports of running hrs of machinery,material consumption.i use sql server 2008 and display report in visual studio.will this type job can help me in future.because i am working in electronics company is it difficult to move to software because its diff than what we do here.please guide meSat, 23 Mar 2013 01:07:38 GMTgurjer48http://www.sqlservercentral.com/Forums/Topic1431346-61-1.aspx[url]http://googlereader.blogspot.com.au/2013/03/powering-down-google-reader.html[/url]Sign up to the petition to keep it:[url]https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader[/url]I use it daily to keep track of several SQL blogs and it keeps RSS feeds synchronised between my phone, desktop, laptop, work pc etc. It's going to be a pain if they kill it.Thu, 14 Mar 2013 21:44:23 GMTfoxxohttp://www.sqlservercentral.com/Forums/Topic1428661-61-1.aspxI was reading Steve's article on [url=http://www.sqlservercentral.com/Forums/Topic1427798-263-1.aspx][b]Productivity and Accountability[/b][/url] and his observation "that people that don't want to work hard, don't" reminded me of a discussion I was in a couple weeks ago: "is it possible to gauge work ethic based on a random sampling of someone's code?" Curious to see which way people lean on this.Fri, 08 Mar 2013 09:45:15 GMTRP_DBAhttp://www.sqlservercentral.com/Forums/Topic1428814-61-1.aspxWe can roll our own but I suspect there must be commercial products that do this. Suppose a Developer needs temporary access to a Production database. We need to track the Dev name, the reason for the access, the access termination date, and since it is production data, the request for that Dev needs to be digitally signed by their Dev's Manager. Also some of our Business Analysts need read-only access to database from Management Studio. But not forever. As they change projects they may no longer need that access. Then there is the ever fun question was access does Dev "x" have to our databases. And I'm only addressing Prod not dev, stage, or qa environments. This simple-seeming task can become a real nightmare and is easy to screwup. If you know of any 3rd party software that deals with this type of matter please tell me. If not, how do you manager your DB access permissions? SharePoint? Excel? Seat of pants? Home grown program?TIA,barkingdogFri, 08 Mar 2013 16:41:21 GMTBarkingdoghttp://www.sqlservercentral.com/Forums/Topic1422172-61-1.aspxHi everybody,I didn't really know where to post this question, but I guess this sub-forum could do. I apologise in advance if I missed the right forum for it.for the TL;DR; people out there, I need some advice on how to promote my SQL Server skills apart from MS Certifications. Just to give you a bit of background, I started years ago (13) as junior SQL developer (Oracle, but that doesn't really matter), and over the years I gradually moved towards software/web development and other tasks, reducing the exposure to SQL Server to little.I tried to keep up to date with the latest features and improvements (I'm MCTS SQL 2005 and I'll be taking the 70-461 exam for SQL 2012 in a couple of weeks) and I did (and do now) develop and administer various DBs and instances for my company and its clients, but since I work for a web development agency the DB-side-of-things is not really "challenging".After a years of meditation I think it's time for me to go back to full time DB development since web development is not "my thing", but of course I have no hands on experience in BI and my times on Datawarehouse are long gone. Since I'm out of the loop a while, I can't find a job in those positions that easily since most of them require X years of experience (in order to maintain the salary level consistent to my current one) and I don't really want to start as Junior again.Also, given all the new features that SQL Server ships with now, I don't think my years spent as C# (and asp.net for that matters) and sysadmin should go wasted either. The question is, apart from certifications (which don't really mean much I guess - don't take me wrong, I value them but I don't think they can be my only "selling point") is there a way to further promote my skillset?Many friends recommended to "work on some side project". In the world of web development people seeking for a new job would roll out some cool website or collaborate on some other project to display their skillset. But DBDs & DBAs are different breeds (at least, I reckon so) and I reckon I can't make up a database from nothing (and for no reason). And even pretending I could, how could I showcase it? This doesn't seem like a viable way... or maybe I'm wrong?What's the best way to get "back in the loop" according to you?I hope this makes sense :)Thanks in advance!Cheers,MattWed, 20 Feb 2013 10:04:36 GMTmatteduehttp://www.sqlservercentral.com/Forums/Topic1421873-61-1.aspxWhy, oh why do so many people looking for help think that "query help" is a good title to get people interested in their topic?If you have a pain in your chest, do you go to the doctor and shout "body help" ?Come on people, make your topic title relevant and informative, please!Tue, 19 Feb 2013 15:22:05 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1421372-61-1.aspxI have [u]Delivering Buiness Intelligence with Microsoft SQL Server 2008[/u] by Brian Larson and its been a great resource for building my first dimensional datamart and cube but I think I need something more in depth. I like the "Unleashed" series books pretty well but was wondering what book you guys would recommend?:w00t:Mon, 18 Feb 2013 16:31:49 GMTmsmithsonhttp://www.sqlservercentral.com/Forums/Topic1420857-61-1.aspxHas anyone out there used Parallels Desktop 8 on their Macs to run Windows and SQL Server 2012? I am just looking to use it for my personal development. All I have access to right now is a MacBook Pro (i7 processor, 16gb ram, 750gb hdd). Unfortunately, the workstation my job provided me with runs Windows XP, and we have to use software that is approved by my job. As you can imagine it makes it impossible to install a virtual machine on my workstation.On a side note if you think another program like VMWare Fusion 5 would work better, I am open to all suggestions. Thanks!Fri, 15 Feb 2013 21:30:03 GMTcstg85http://www.sqlservercentral.com/Forums/Topic1420614-61-1.aspxHi allI am working mostly with SQL Server and the BI tools, and have the 2008(R2) and 2012 MS SQL Client tools installed on my workstation. Now i have a requirement to develop a small ASP.Net application, so i have to have VS with ASP.net templates on my workstation. In the past i have had bad experiences installing VS together with MS SQL Client Tools, so my question is: Since i have already BIDS and SSDT based on VS, is there any way to install the ASP.Net templates into one of these? any help are greatly appreciated.Best regards TorbenFri, 15 Feb 2013 09:10:58 GMTtorben_bhttp://www.sqlservercentral.com/Forums/Topic1418761-61-1.aspxHi all :-DSo I have been on a self-edification kick lately. There are so many big concepts surrounding business disciplines these days its hard to keep track of them all! So, what I am trying to do (and praying I am not pioneering this!) is get some sort of high level (and possibly hierarchical) outline of the major business disciplines surrounding data in general. I have spent the last few years improving my understanding things like Data Modeling methodology and concepts, DR and High Availability, Data Profiling/Discovery, Master Data Management, Change Management, etc etc. What I am wondering, is if there is any reference material out there that lists out the major business disciplines surrounding data, and possibly gives at least a rudimentary explanation of each facet. I feel lately that I need to locate my 'unknown unknowns' as to improve my overall mastery and understanding of things, and I think this is really the direction I need to be going in! Thanks to all in advance for any help!Mon, 11 Feb 2013 23:33:06 GMTshannonjkhttp://www.sqlservercentral.com/Forums/Topic1418199-61-1.aspxHowdy folks,I'm trying to setup a demonstration of how to download from FTP sites using T-SQL. The problem is, I don't know of any FTP sites that the general public has free access to. Do any of you know of such a site? Preferably, it would be a US site that's likely to be around for a good long time, probably some government site.I could spend the time on Google looking for such a thing but I thought I ask you good folks first. Thank you for your help.Sun, 10 Feb 2013 22:16:29 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1418003-61-1.aspxYep, I got a new job! :w00t:The scary part, I'm expected to help the Sharepoint team with the SQL side of Sharepoint. So I've loaded up SP2010 on my home lab, starting to get a feel for it (never used it / saw it before) but I want something that might help quicker.Any suggestions on a Sharepoint book that will help me on the DB side of things?Even if it's more aimed at the Sharepoint admins, but has information about managing the DBs, if you think it would be helpful, list it...Thanks all!Jason A.Sat, 09 Feb 2013 06:00:24 GMTjasona.workhttp://www.sqlservercentral.com/Forums/Topic1406424-61-1.aspxI've never experienced this but found it bizarre. If I was ever asked to provide access to my social media accounts I would treat it the same as a request for my banking information: 1) No ! and 2) You'll be hearing from my attorney.http://www.infoworld.com/t/internet-privacy/new-laws-keep-employers-out-of-worker-social-media-accounts-210150Sat, 12 Jan 2013 16:46:08 GMTIndianrockhttp://www.sqlservercentral.com/Forums/Topic1409684-61-1.aspxSo, I'm car shopping for a second car and got curious what everyone else is driving. Some time back, I recall reading an article that mentioned many IT professionals tended to drive Subarus, specifically the WRX in its various incarnations.I know I probably missed a few brands (Rolls Royce, Lamborghini come to mind,) and I know I'm missing brands that are common outside the US (Vauxhall, Holden,) but the polls only allow up to 15 options, and I couldn't get a Holden if I wanted to...:-)JasonMon, 21 Jan 2013 12:56:23 GMTjasona.workhttp://www.sqlservercentral.com/Forums/Topic1414440-61-1.aspxAnd no, it didn't go missing. It just died with a loud pop. Could be the power supply, the system is 8 years old.Question for those more hardware savvy, if I replace both the motherboard and the power supply, would it boot up with the current hard drives?Thu, 31 Jan 2013 22:20:05 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1414868-61-1.aspxGood evening! Let me start by saying that I'm not sure if I put this in the right section of the site, so my apologies if I got it wrong. So at my job, I'm trying to position myself to be more of a DBA and less of a general Systems admin. I spoke with my boss about this and he approved, he gave me a lab at work to play with. Now, unfortunately, I don't have free reign over the lab, as it's all on the same Domain, etc., as our production environment. I have no issue with this and I was actually thinking of building out a PC at home to use as a test server. I already have a TechNet subscription that will cover the licensing. I am just stumped on the hardware, as the last time that I built a PC was probably when the Athlon 64 was brand new, lol. Can anyone provide me with suggestions? I do know that I am looking to get 24GB of ram on this box, as I will end up having at least 5 VM's that I know of powered on most of the time (1xAD, 2X Server 2008 r2 w/SQL 2008r2, 2x Server 2012 w/SQL 2012) running as well as my main OS install. Any suggestions would be appreciated, I am not tied to a specific architecture.Thanks for putting up with the long post, Thanks for feedback.Fri, 01 Feb 2013 16:17:57 GMTdrottfromspacehttp://www.sqlservercentral.com/Forums/Topic1412343-61-1.aspxHello,I am new to web application designing and using .net (MS Visual Studio 2010) to design an application.The issue I have is to display information on a table based upon the 2 values selected by the user in the drop down lists. When the user presses the Find button, the results should be displayed in the form of a table from a table. Could someone please tell what component (table or ???) I need to select from the list and what code would need to be written to associate the 'Find' button to the table. Thanks inadvance for your help. Please find the screenshot for the application attached.Thanks,PaulMon, 28 Jan 2013 04:34:21 GMTpwalter83http://www.sqlservercentral.com/Forums/Topic1413069-61-1.aspxHas anyone used Ignite for SQL Server monitoring? I have it installed for my SQL Servers but not allot of informaton how how to set up alerts that are not default? Anyone have any ideas?Thanks! :-)Tue, 29 Jan 2013 08:10:49 GMTIt's the Database!!!http://www.sqlservercentral.com/Forums/Topic1408937-61-1.aspxWe currently host our own (aging) hardware on site and are considering moving to the cloud. Our consultant suggested a data center in Germany for cost reasons. While there are no legal impediments, I'd like to know anything else I should be concerned with having our data a continent away. The center would host our SQL Server, Citrix farm, Exchange, file system, and BDC. We're told we need to keep the PDC on our premises.Thanks.Fri, 18 Jan 2013 08:11:52 GMTmtrachttp://www.sqlservercentral.com/Forums/Topic1410639-61-1.aspxCan any one help me.............Please tell me what is the best way for getting data in production server.If possible tell me step by step with example..or else give the ref links for that...The way is ...I am getting the data from production server like day wise.and that should be stored in another server like local server.Please help me...........Wed, 23 Jan 2013 08:50:31 GMTkalivaraprasadmhttp://www.sqlservercentral.com/Forums/Topic1408718-61-1.aspxis asksqlservercentral a sister of sqlservercentral? can I use my login there? :-)Thu, 17 Jan 2013 22:53:12 GMTBryansky