SQLServerCentral / Anything that is NOT about SQL! / SQLServerCentral.com

Are the posted questions getting worse?

Michael Earl-395764 — Tue, 18 Nov 2008 06:31:49 GMT

Is 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?

Today's Random Word!

paglamolom — Tue, 03 Nov 2009 04:00:13 GMT

HI 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]

can we get this guy banned from the forums?????

michael vessey — Thu, 24 May 2012 04:31:47 GMT

<RANT>can we get this guy banned from the site?k.subramanyam1017 I for one see the value in people asking the most basic questions. I have gained by looking at simple problems other people ask and learning from the responses. Nowadays i do more responding than asking.but this guy takes the biscuithttp://www.sqlservercentral.com/Forums/Topic1303209-391-1.aspxhttp://www.sqlservercentral.com/Forums/Topic1293145-391-1.aspxhttp://www.sqlservercentral.com/Forums/Topic1292352-391-1.aspxhttp://www.sqlservercentral.com/Forums/Topic1292298-391-1.aspxhe is openly admitting that he is putting stuff on his CV and then when he goes for an interview he's asking the forums for the answers to questions that even the most basic junior dba/dev would be able to googlemy favourite was "how to fail over primary in log shipping then witnes is involved" , "please requirements for install sql 2005" and most spectacularly "difference between 2005 and 2008"can't we just get rid of this time waster pleeeeeaaaaaaaase ? it means the active threads screen becomes clogged with rubbish and the people who really need help get overlooked.</RANT>

I left all my scripts at my previous employer

8kb — Wed, 23 May 2012 23:48:49 GMT

During the three years at my last job, I wrote hundreds of scripts to assist in development. I had code snippets for basic syntax, examples of SQL injection, custom string functions, Powershell scripts, test harnesses, and so forth. I didn't take these with me because they were developed at my employer and I assumed that even though most of them were not ever part of an actual product, they were still source code that belonged there.At my new position, I doing this all over again. Some things I'm rewriting from scratch, but most of it is new work because I'm dealing with a completely different system. I'm finding many of these scripts extremely useful and already bemoaning the fact that they don't belong to me. How do other SQL Server professionals deal with this? Do they have scripts they take from job to job? Do they write the scripts at home, post them on a blog, and then use them for work that way? Or is the loss of useful scripts just an accepted part of having a steady job?

VB.net error - Unable to cast object of type 'WebProxyWrapper' to type 'System.Net.WebProxy'.

pwalter83 — Tue, 22 May 2012 02:56:39 GMT

Hi,I get an error when I run this code - Unable to cast object of type 'WebProxyWrapper' to type 'System.Net.WebProxy'.:----------------------------------------------------------Dim restRequest As WebRequest Dim restResponse As HttpWebResponse Dim rXML As StreamReader Dim sXML As String Dim myProxy As New WebProxy myProxy = WebRequest.DefaultWebProxy() 'use default proxy setting restRequest = CType(WebRequest.Create("http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml"), WebRequest.DefaultWebProxy) restRequest.Proxy = WebRequest.DefaultWebProxy restRequest.Proxy.Credentials = CredentialCache.DefaultCredentials restResponse = DirectCast(restRequest.GetResponse(), HttpWebResponse)---------------------------------------------------------------------------------------Does someone have any idea of what could be wrong ?Thanks,Paul

SO fast!

icedream89 — Mon, 21 May 2012 02:50:44 GMT

I am in China now,but I found I can visit the website so fast. Is the server of the website in China?:-D

Talking baseball

Ray K — Wed, 16 Dec 2009 12:42:42 GMT

Okay, 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)!

This forum vs. Ask SSC

Thomas Stringer — Wed, 16 May 2012 19:14:43 GMT

I tried searching for some explanation before posting, but I found nothing close to what I'd like to know. Ask SSC seems to be a board-type question site here on SSC. My question is, what is supposed to be the differences between this forum and Ask SSC (besides the obvious layout and asking/answering structure)? In other words, why post/answer here as opposed to Ask SSC and vice versa? Why do both exist?Thanks! And again, if this has been hashed out before I apologize for the copy.

XSLT CODE USING Muenchain Grouping (Very Urgent)

sam-1083699 — Thu, 17 May 2012 16:42:03 GMT

Hi all , I'm a SQL Guy but i was asked to look into this following java script .js file and xslt code. Currently i have performance issue with my xslt code.Let me explain you everthing in detail. I have a .js file when i double click .js file it will take the .csv in that folder and uses the xslt and gives me an .xml output file. /* code for my .js file */ (Please copy this to note pad and save it as InvoiceAdjustment.js) [code="plain"]showAbsolutePath("InvoiceAdjustment.js");function showAbsolutePath(path){ var fso = new ActiveXObject("Scripting.FileSystemObject"); var s = ""; s += fso.GetAbsolutePathName(path); var foldername = s.substring(0,s.indexOf(path,0)); showFolderFileList(foldername);}function showFolderFileList(foldername){ var fso, f, fc, filename; fso = new ActiveXObject("Scripting.FileSystemObject"); f = fso.GetFolder(foldername); fc = new Enumerator(f.files); for (; !fc.atEnd(); fc.moveNext()) { filename = ""; filename += fc.item(); if (filename.slice(-4) == ".csv") { convertCSVtoXML(foldername, filename); } } fso = null;}function convertCSVtoXML(foldername, filename){ var objDOMDocument = new ActiveXObject("MSXML2.DOMdocument.4.0"); objDOMdocument.async = false; //Create Header objDOMdocument.appendChild(XMLHeader(objDOMDocument)); var objXMLDOMNode = objDOMdocument.documentElement.selectSingleNode("//Document"); // Declare XML object -- this makes it easier to pass as a parameter var objXML = new Object(); // Open the extracted csv from zip file var fso = new ActiveXObject("Scripting.FileSystemObject"); var csvFilename = filename; var tso = fso.OpenTextFile(csvFilename, 1); var strInput; // Loop through the file while(!tso.AtEndOfStream) { strInput = tso.ReadLine(); var vInputLine = strInput.split(","); objXML.a = vInputLine[0]; objXML.b = vInputLine[1]; objXML.c = vInputLine[2]; objXML.d = vInputLine[3]; objXML.e = vInputLine[4]; if (objXML.a != 'RebateInvoiceID') { objXMLDOMNode.appendChild(XMLFileNode(objDOMDocument,objXML)); } } tso.Close(); // Load Transform file var TransformXSL = new ActiveXObject("MSXML2.DOMdocument.4.0"); TransformXSL.async = false TransformXSL.load(foldername + "\\InvAdj.xsl"); // Load XML file and transform it var TempStagingDoc = new ActiveXObject("MSXML2.DOMdocument.4.0"); TempStagingDoc.async = false; TempStagingDoc.loadXML(objDOMdocument.xml); var FinalStr = TempStagingDoc.transformNode(TransformXSL); // Grab just the file name minus any extension var fn = filename.substring(0, filename.indexOf(".csv")); tmpxml = fn + ".xml"; // Write out the transformed file. If writing out just the xml file before transform // FSObject.WriteLine(objDOMdocument.xml); var FSObject = fso.CreateTextFile(tmpxml, true); FSObject.WriteLine(FinalStr); FSObject.Close(); /* // Create empty .flag file then rename it tmpxml += ".flag"; var fsoEmptyFile = fso.CreateTextFile(tmpxml, true); fsoEmptyFile.Close(); // Rename the .flag file to .done var donefilename = tmpxml.substring(0,tmpxml.indexOf(".flag",0)); donefilename += ".done"; fso.MoveFile(tmpxml, donefilename); // Delete the corresponding .csv file fso.DeleteFile(csvFilename); */ // Clear all objects objDOMDocument = null; fso = null; TransformXSL = null; objXML = null; TempStagingDoc = null;}function XMLHeader(objDOMDocument){ var XMLHead; XMLHead = objDOMdocument.createNode(1, "Document",""); var objXMLDOMAttribute = objDOMdocument.createAttribute("Version"); objXMLDOMAttribute.text = "1.0"; XMLHead.attributes.setNamedItem(objXMLDOMAttribute); var objXMLDOMAttribute = objDOMdocument.createAttribute("CreationTimestamp"); objXMLDOMAttribute.text = getTimestamp(); XMLHead.attributes.setNamedItem(objXMLDOMAttribute); return(XMLHead);} function XMLFileNode(objDOMDocument,objXML){ var objXMLDOMNode = objDOMdocument.createNode(1, "RawXMLRow",""); objXMLDOMElement = objDOMdocument.createElement("RebateInvoiceID"); objXMLDOMElement.text = objXML.a; objXMLDOMNode.appendChild(objXMLDOMElement); objXMLDOMElement = objDOMdocument.createElement("RebateEventID"); objXMLDOMElement.text = objXML.b; objXMLDOMNode.appendChild(objXMLDOMElement); objXMLDOMElement = objDOMdocument.createElement("BusinessUnitCode"); function getBusinessUnitCode(){ var r = String(objXML.c).length; if(r == 4) return String(objXML.c); if( r == 3) return "0"+String(objXML.c); if(r == 2){ return "00"+String(objXML.c); } else return "000"+String(objXML.c); } objXMLDOMElement.text = getBusinessUnitCode(); objXMLDOMNode.appendChild(objXMLDOMElement); objXMLDOMElement = objDOMdocument.createElement("CategoryID"); objXMLDOMElement.text = objXML.d; objXMLDOMNode.appendChild(objXMLDOMElement); objXMLDOMElement = objDOMdocument.createElement("PaymentAmount"); objXMLDOMElement.text = objXML.e; objXMLDOMNode.appendChild(objXMLDOMElement); return(objXMLDOMNode);}function getTimestamp(){ var d = new Date(); var mm = padZeros(d.getMonth()+1); var dd = padZeros(d.getDate()); var hh = padZeros(d.getHours()); var mn = padZeros(d.getMinutes()); var ss = padZeros(d.getSeconds()); return d.getFullYear()+"-"+ mm +"-"+ dd +"T"+ hh +":"+ mm +":"+ ss;}function padZeros(s){ if (s < 10) { s = "0" + s; } return(s);}function getDate(stringDate){ var a = String(stringDate).split( "/" ); var strXML ; strDate = "" ; for ( var i = 0 ; i < a.length; i++ ) { if (a[i].length == 1) strDate += "0" + a[i]; else strDate += a[i]; } strDate += "" ; return strDate;}[/code]/* code for xslt */ ( make an xslt using below code and save it as InvAdj.xsl)[code="xml"]<?xml version="1.0"?><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:script="script" exclude-result-prefixes="msxsl"> <xsl:output omit-xml-declaration="yes"/>  <xsl:template match="/"> <EnterpriseDocument> <xsl:attribute name="InterfaceName">RebateInvoiceAdjustmentImport</xsl:attribute> <xsl:attribute name="ClientID"> <xsl:choose> <xsl:when test="normalize-space(ClientID)"> <xsl:value-of select="//Document/RawXMLRow/ClientID"/> </xsl:when> <xsl:otherwise>1000001</xsl:otherwise> </xsl:choose> </xsl:attribute> <xsl:attribute name="ClientName">XXXX</xsl:attribute> <xsl:attribute name="Version">1.0</xsl:attribute> <xsl:attribute name="CreationSource">File</xsl:attribute> <xsl:attribute name="CreationTimestamp"> <xsl:value-of select="script:getTimestamp()"/> </xsl:attribute> <xsl:call-template name="InvAdjData"/> </EnterpriseDocument> </xsl:template> <xsl:template name="InvAdjData"> <xsl:for-each select="//Document/RawXMLRow[not(RebateInvoiceID=preceding-sibling::RawXMLRow/RebateInvoiceID)]"> <xsl:sort select="RebateInvoiceID"/> <RebateInvoice> <xsl:attribute name="RebateInvoiceID"> <xsl:value-of select="RebateInvoiceID"/> </xsl:attribute> <xsl:variable name="InvoiceID"> <xsl:value-of select="RebateInvoiceID"/> </xsl:variable> <xsl:for-each select="//Document/RawXMLRow[not(RebateEventID=preceding-sibling::RawXMLRow[RebateInvoiceID=$InvoiceID]/RebateEventID)]"> <xsl:if test="RebateInvoiceID=$InvoiceID"> <xsl:variable name="EventID"> <xsl:value-of select="RebateEventID"/> </xsl:variable> <RebateProgram> <xsl:attribute name="RebateEventID"> <xsl:value-of select="RebateEventID"/> </xsl:attribute> <xsl:for-each select="//Document/RawXMLRow[not(BusinessUnitCode=preceding-sibling::RawXMLRow[RebateInvoiceID=$InvoiceID and RebateEventID=$EventID]/BusinessUnitCode)]"> <xsl:if test="RebateInvoiceID=$InvoiceID and RebateEventID=$EventID"> <xsl:variable name="BUCode"> <xsl:value-of select="BusinessUnitCode" /> </xsl:variable> <BusinessUnit> <xsl:attribute name="BusinessUnitCode"> <xsl:value-of select="BusinessUnitCode"/> </xsl:attribute> <xsl:for-each select="//Document/RawXMLRow[not(CategoryID=preceding-sibling::RawXMLRow[RebateInvoiceID=$InvoiceID and RebateEventID=$EventID and BusinessUnitCode=$BUCode]/CategoryID)]"> <xsl:if test="RebateInvoiceID=$InvoiceID and RebateEventID=$EventID and BusinessUnitCode=$BUCode"> <ItemCategoryPayment> <xsl:attribute name="CategoryID"> <xsl:value-of select="CategoryID"/> </xsl:attribute> <xsl:attribute name="PaymentAmount"> <xsl:value-of select="PaymentAmount"/> </xsl:attribute> </ItemCategoryPayment> </xsl:if> </xsl:for-each> </BusinessUnit > </xsl:if> </xsl:for-each> </RebateProgram > </xsl:if> </xsl:for-each> </RebateInvoice > </xsl:for-each> </xsl:template>  <msxsl:script language="JScript" implements-prefix="script"> <![CDATA[function getTimestamp(){ var d = new Date(); var m, dy, hr, mn, se; if (d.getMonth()+1 < 10) { m = "0"+(d.getMonth()+1); } else if (d.getMonth()+1 > 9) { m = d.getMonth()+1; } if (d.getDate() < 10) { dy = "0"+(d.getDate()); } else if (d.getDate() > 9) { dy = d.getDate(); } if (d.getHours() < 10) { hr = "0"+(d.getHours()); } else if (d.getHours() > 9) { hr = d.getHours(); } if (d.getMinutes() < 10) { mn = "0"+(d.getMinutes()); } else if (d.getMinutes() > 9) { mn = d.getMinutes(); } if (d.getSeconds() < 10) { se = "0"+(d.getSeconds()); } else if (d.getSeconds() > 9) { se = d.getSeconds(); } return d.getFullYear()+"-"+ m +"-"+ dy +"T"+ hr +":"+ mn +":"+ se;}]]> </msxsl:script></xsl:stylesheet>[/code]Now copy this records into an excel sheet and save it as .csv [code="plain"]RebateInvoiceID RebateEventID BusinessUnitCode CategoryID PaymentAmount1001878 1003042 402 1000057 891001878 1003042 405 1000057 94.421001878 1003043 406 1000057 147.51001878 1003048 423 1000057 97.361001879 1008042 433 1000057 891001879 1008042 434 1000057 70.241001879 1008942 435 1000057 53.081001978 2003042 437 1000057 127.851001978 2003042 438 1000057 180.041001978 3003042 446 1000057 146.611001978 3003042 448 1000057 76.56[/code]Now place the .csv input file and .js file and xslt in to one folder and double click the .js file it will generate an .xml file. now i need the same result using muenchain grouping method in xslt code. Can you help me please. Thanks.

Question on WordPress Preferences

Brandie Tarvin — Thu, 17 May 2012 06:40:00 GMT

I totally have biased motives in asking these questions, BTW. @=)What is your favorite theme(s)?What are your favorite plugins (and why)?And does anyone know of a plugin that adds IF Codes like the ones we use here on SSC?

Forgotten Tipples

L' Eomot Inversé — Thu, 17 May 2012 05:47:21 GMT

I suspect that almost everyone (other than those who eschew alcohol absolutely) will have had an occasion where they partook of some new (to them) alcoholic drink, loved it, and forgot it and never tasted it again for years.So the idea here is for everyone to tell of us such an occasion (which they can only do, of course, if the lapse of memory mentioned above has miraculously [or otherwise] unlapsed). Ideally, the occasions related should have some connection (perhaps a remote, or vague, or drunken one) with relational databases, but an adequately loose connection with SQL instead would be acceptable despite the forum's title. Here's my own story.A couple of decades ago, a number of people got together for a week at a hotel in St Pierre (not far from Grenoble) to talk about massively parallel databases and how we would move forward. Weekdays in the conference room, weekends on the hills (much ice, much snow). In the conference room we drank water and soft drinks, of course, but we were in France so lunch and dinner were accompanied by wine; and some (most) of the evenings were spent in the bar. As we were in St Pierre, only a few miles from the Chartreuse monastery, the bar had a good range of chartreuse, both green and yellow, in strengths from 40% up to (if I remember correctly) something over 70%. My wife, who dislikes big hills and intensely hates ice-covered hills as anything other than a backdrop to the scenery and wasn't with me on this business trip, is a green chartreuse since her teens, so I was familiar with that, but I hadn't tasted yellow chartreuse before. I discovered that I like the yellow as well as the green. Naturally I brought some of both home with me; but it didn't last long, and with the price of chartreuse in the UK (and three expensive children living at home and a vast debt on our house) it was pretty rare that we could afford to buy any, so we dropped it from our drinking. So until yesterday I hadn't touched chartreuse for 18 or 19 years.Last night, on returning home from a reunion of local former ICL High Performance Systems people, I was looking for something to drink before going to bed. That was probably a mistake, after the reunion, which had taken place in a hostelry with excellent beers at fairly low prices, but I failed to realise that at the time. I couldn't find anything I felt like drinking until I discovered, at the back of a cupboard, an unopened bottle of yellow chartreuse. I don't know how it got there - the cupboard has existed only for six years, we acquired it (definitely empty) just after we moved house, and I don't recall the bottle moving with us. I decided a small glass of that might be just the thing. It was. I had quite forgotten how good the stuff was. I don't think that bottle will last very long now, but with all the children now doing their own thing, all debts cleared, and the big fall in the euro, I can maybe afford to start buying the stuff again.

Can anyone recommend an Active Directory forum

440692 I am just a number — Tue, 15 May 2012 08:56:51 GMT

Can anyone recommend an Active Directory forum?I have an ongoing issues with connectivity[url]Can anyone recommend an Active Directory forum[/url]Thanks in advanceIan

DevConnections / SQL Server Connection event worth the time?

jasona.work — Tue, 15 May 2012 09:49:33 GMT

So, I'm an accidental DBA, and I'm looking to improve myself. I "play" with SQL a little, and am on the lookout for seminars and conventions to attend to pick up more knowledge.I was looking at trying to get the company to pick up the tab for me to go to TechEd in Orlando this year, but my schedule wouldn't cooperate to open up the time.I'm looking at DevConnections in Las Vegas this fall, and I see a few sessions that sound promising in the schedule. So, my question is, has anyone here gone (likely a silly question) and if so, how was it?Thanks,Jason A.

ODBC SQL Server Driver Error: Invalid object name

pwalter83 — Tue, 15 May 2012 06:12:10 GMT

Hi,I get an error when I try to run a VB6 application. What happens is the application tries to access a SQL Server table and inspite of the correct login and user permissions on the database, I get this error:2147217865 : [Microsoft] [ODBC SQL Server Driver][SQL Server] Invalid object name 'KKK_CURR_PERD_RATE'The surprising thing is the same application works okay when connected to another server which has the same level of login and user permission settings in SQL Server.Does someone know the cause of this error ?Thanks,Paul

Creating Statement Report

tbauia — Tue, 08 May 2012 15:18:25 GMT

I am a newbie to database and part of my project is to create a billing system, because I am not familiar with SQL I start using Access just to create a database. I got this table relations, a customer table, payment table, meter table, meter rate table, meter reading tables and a customermovement table or tenant table (this is for rental houses or non-permanent owners).To get the customer bill, is to check customer id at the customermovement, get meter serial and the date he/she moved in the house and the initial reading then get the present reading from the reading table according to that meter serial times the rate and that his or her bill. But I got a problem on how to generate or create a report statement that is going to list his/her monthly bill and his/her payment according to the date of payment and his/her brought forward balance.Has anyone knows how to do this kind of statement, I really need help on this please.Thank you

SSC Points System?

Thomas Stringer — Sun, 29 Apr 2012 18:51:29 GMT

I have searched, as I'm guessing this has probably been asked before. But I'm curious as what contributes to the "points" here on SSC. Any articles, links, or descriptions available?Thanks!

Callin' all - HTML,CSS experts. CSS HTML Firefox Issue

thunderousity — Fri, 04 May 2012 12:54:28 GMT

Hi CSS/DBA experts,I'm a DBA by day and a website hobbyist by night. I've posted this on another forum but thought I would try here as I know I'll get a positive, professional response.I have an issue near the top of a websites homepage where the table/div is not rendering how I expected in Firefox 12.0.As you can see in IE7/8 the table of statistics appears in the centre of the page and below the horizontal menu.Whereas in Firefox the table appears directly after the menu but renders at the right of the page.It works fine in IE7 and IE8. For what it's worth, the CSS validates ok via the W3C validator.I'm not quite sure if it is a CSS or a HTML issue so I didn't want to post a pile of irrelevant code up in the forum.The homepage: http://www.autosnout.com/

Network infrastructure

SeanF-708538 — Thu, 26 Apr 2012 19:23:41 GMT

Hi All,I've joined a company that had to relocate offices very quickly last year, the Network was "created" overnight, and the network admin is out of their depth, so when I query the speeds witnessed during simple tasks such a copying a PDF from one location to another all I get is the Network speed should be 1Gb/sec, so.....Are there any decent forums/books/websites out there for the 'Accidental Network Admin'??Thanks for your time

I am so sad.... :-(

SQL_ME_RICH — Thu, 26 Apr 2012 16:43:13 GMT

I may have to become a MySQL DBA instead of a Microsoft SQL Server DBA.:crying:

PolyServe replacement options

Charlotte Bentley — Thu, 21 Apr 2011 10:00:00 GMT

While it seems HP still has not made the official announcement, some of us have had conversations with HP representatives confirming that PolyServe for SQL Server is now on the End Of Life path. SQL Server 2008 R2 will not be supported. I would appreciate tips from anybody about what they are considering for a replacement. A couple of people on the HP forum mentioned Sanbolic Melio FS.

Thanks

Bex — Tue, 24 Apr 2012 08:12:27 GMT

I don't post much, don't ask many questions, mainly because what I do is pretty low-level DBA/T-sql stuff, and I can find answers either myself or by coming here or Googling. I'm sure there must be others like me out there - we don't ask much, and therefore maybe don't get the chance to say thanks too often, so I thought I'd do just that. So thank you everyone who has asked a question that has left behind answers for those of us who are asking the same thing, and to all who have posted answers/discussions.What brought me here today was a very, very simple thing (I knew how to format the date/time in SSRS, but wasn't sure how to get the minutes in 24 hour clock instead of 12 hour - got it, thanks), and it just occurred to me that the thread where I found the answer was so old that posting "thanks" would be somewhat meaningless, but I still wanted to say it.Guess I'm in a bit of a reflective mood.Bex

SkyDrive

anthony.green — Tue, 24 Apr 2012 02:13:56 GMT

Hi AllJust a quick one to anyone who uses SkyDrive and doesnt know already.Microsoft are reducing the free storage down from 25GB to 7GB for new and existing users.You can stop Microsoft from doing this by logging into SkyDrive and using the manage storage section. This is an opt-in basis and from what I have heard will only be availiable for a limited period so I would recommend changing it as soon as you can if you wish to keep your free 25GB SkyDrive.ThanksAnt

Sharepoint Dashboard Designer -- need to remove just one page from breadcrumbs

lduvall — Mon, 23 Apr 2012 08:16:39 GMT

I've got a VERY simply Dashboard that consists of 5 SSRS reports. The user navigates among the reports using either drill-through functionality from SSRS itself or by using the breadcrumbs at the top of the dashboard. I am wanting to hide one particular report from the breadcrumb section, though. I only want my users to access that one via drill-through from another report. How can I accomplish this? When I'm in Dashboard Designer, the "Include page list for navigation" option in Deployment Properties appears to be an "all-or-nothing" option. I can't un-check it for one report versus another. Help, please!

Earth Day - Help Monitor Mother Earth

Krista Olson — Thu, 19 Apr 2012 20:54:26 GMT

You pick up garbage, plant a tree and celebrate Earth day, but did you ever think about helping Mother Earth with data? Each year citizen volunteers help monitor lakes, oceans, deserts, weather - you name it, and over time we are collecting a lot of data about Mother Earth. Unfortunately a lot of these programs are powered by citizen volunteers, and not enough volunteers are available to cover the roles. I just received my Wisconsin Citizens Lake Monitoring kickoff and again sadly there are only a few of us to cover a county full of lakes. How about helping our environment by collecting measurements and supplying data to these databases that have been set up in the monitoring networks? If you are a database geek its easy to get hooked at reviewing and comparing the data you collected, and it helps local officials with making decisions on the small area of the world that you love or call home. Many states have different monitoring networks - get involved and help Mother Earth (or at least have a good excuse to get outdoors) http://dnr.wi.gov/lakes/CLMN/

Tech Recruiters That Don't Understand the Tech

drew.allen — Wed, 18 Apr 2012 12:10:24 GMT

I'm currently looking for a job and a tech recruiter refused to consider my application for a job, because they were looking for SQL 2008 experience and my experience is mostly with SQL 2005. How do you get the recruiter to understand that the differences between SQL 2005 and SQL 2008 are inconsequential?Drew

Read Progress Database Backup

Tom Brown — Fri, 11 May 2007 11:54:00 GMT

A potential customer of mine has given me a backup file containing what I think is a progress database. It contains a .DB file, a .LG file and a .BI file. The machine was running it on has crashed - and he has no backup of the software - he has been running a mail order business since the early 1990's with this PC! (Seems incredible I know), but I'd like to help him out read the backup and get him onto some more modern equipment. Currently he's having to employ someone to re-key the data from print-outs - slow and costly. Does anyone know of any software that may be able to read an old Progress Database?

Thanks in advance for any suggestions

Happy easter every one

capn.hector — Sat, 07 Apr 2012 09:19:02 GMT

To every one on the forums i want to wish you a happy easter.Have a good weekend

Resume font ?

SQL Guy 1 — Wed, 22 Dec 2010 13:59:00 GMT

Hi all, Here I want to ask a question about font for resume. What font is more impressive? I always used Time New Roman, but recently saw another guy's resume which had Arial. What fonts are you using and why ?Thanks

What Helpdesk software you are using and is it good?

Enigma475 — Wed, 09 Mar 2011 07:56:23 GMT

My company is looking at different options for Helpdesk software so I wanted to find out what's out there and what works.

SQL PASS 2012 - Code for After-Hours Party?

Jay Kusch — Fri, 06 Jan 2012 12:12:30 GMT

Getting ready to register and wanted to see if the code I need to append to the registration is available?I am talking about the code for attending the After-Hours party during the conference.Thanks!

Dallas Tornados

capn.hector — Tue, 03 Apr 2012 17:57:06 GMT

WOW. i used to work for schneider. (the trucking companies yard at the start of the clip.)[url]http://video.foxnews.com/v/1545530363001/tornadoes-strike-near-dallas-fort-worth-area/[/url]any one down in dallas? hope your ok

so I found a file with a zillion email addresses...

Lowell — Thu, 05 Apr 2012 10:20:03 GMT

I was helping someone update their web site, and tripped accross a big old file tucked away in a deep subdirectory; basically a 100 meg text file with more than 1.4 million emails, with most of them having a link to their firstname,lastname and facebook profile link.I'm not a facebook-er or a twtter-er, so my question us really basic; if you join, is your email out there for people to scrape and spam you?

SQL Bits X...

Gazareth — Fri, 30 Mar 2012 03:37:30 GMT

... who's here?

C# vs VB

SQL Guy 1 — Wed, 07 Mar 2012 15:37:40 GMT

Are there any benefits of C# vs VB ? In other words, can C# do sometheing that VB cannot do ? Assuming same version of .NET for both, of course.

Giving developers local admin access on their workstations

msmithson — Fri, 23 Mar 2012 13:23:27 GMT

I am a developer (SSRS/SSIS) and I recently got tired of having to complete a work order every time I wanted to change something on my local workstation (2012 eval install, developer edition install, various changes to config files, etc). I asked our systems administrator and was told it was too big of a security risk. I used to do server administration at a previous job so its not like I am going to hose my machine. I also have access to a local admin account on our PRODUCTION SSRS/SSIS server :blink:. Just curious what other people's opinions are. :Whistling:

Universal ID Project

Brandie Tarvin — Tue, 27 Mar 2012 04:41:52 GMT

This thread is to start a fun project to design a Universal ID Card (UIC) system, based on the following news article from CNN:[url=http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7]http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7[/url]In addition to designing the system and database to support a UIC, this thread's purpose will be to give newer DBAs / SQL Devs something to refer to for how project design actually works. Since people can get passionate about certain techniques and procedures in database design, I do ask that everyone remember that there is rarely such a thing as "the one right answer." The discussion will start with tech specs and business rules. We will assume there is an unlimited budget, and we can have whatever hardware we request. To get us started, here are the things that come to my attention.Based on the news article above, there are a few things we know:1) Cards will have ONLY picture and name on front2) All other personal identifying information (PII) is secured via electronic strip or digital chip and unreadable by the human eye3) Our system should NOT present PII to the business user4) As this is a Universal system, with multiple businesses, government agencies, and other customers hooking into it, we can assume our connections / thread counts will be high.We can make the assumption that the UIC information will be (or should be) encrypted.What thoughts do you have?

Are the posted answers getting worse?

RBarryYoung — Wed, 21 Jan 2009 17:02:28 GMT

OK, we've had fun bashing frustrating posters & topics.But to be fair, we should hold ourselves much more accountable than them (after all, we [i]do[/i] know better). So this topic is devoted to pointing out our own mistakes, blunders and bloopers.The rules: You can only point out your own flaws and failings (or someone's whom you are are on good enough terms to get away with it :) ). No mere typos or grammar errors either. This is for really dumb, stupid things that either: 1) Make you look like an idiot, or 2) Leaves everyone scratching their heads, saying "what the heck was that?", or 3) Completely contradict your own point, or 4) Is the opposite of what you tell everyone else to do.And yes, I'll go first...-------------------------------------------------------------------------Who does this guy "RBarryYoung" think he is? He can't even get a simple query right. Check this out: [url=http://www.sqlservercentral.com/Forums/Topic641210-359-1.aspx][u]here[/u][/url].Man, what a bonehead!(Edit: Believe it or not, I got the link wrong too!)

How to retrieve permanently deleted mail in outlook

Sakthivel Chidambaram — Wed, 23 Apr 2008 23:23:47 GMT

How to retrieve permanently deleted mail in outlook.Check out the attachment. Really useful one... From outlook 2007 this option is enabled by default..Update: Sorry guys... MHTML was not allowed.. now i hav uploaded as zip...

Which DB does Google uses??

aravind-305595 — Thu, 15 Nov 2007 01:39:25 GMT

Which DB does Google uses??

Can anyone recommend good course/event management software

Bex — Wed, 21 Dec 2011 07:43:16 GMT

It has to handle secure, online payments and preferably not be SaaS. Ideally with a SQL Server backend? We have fairly complex needs in terms of the data we capture at time of registration (by complex I mean more than most packages offer as standard).Maybe my Googling skills are lacking, but anything decent I can find funtionality wise seems to be SaaS (often with the datacentre in the USA, which is not ideal as we are UK based), which, as a DBA, doesn't fill me with joy.Many thanksBex