Search Results

Search found 28930 results on 1158 pages for 'sql ce'.

Page 860/1158 | < Previous Page | 856 857 858 859 860 861 862 863 864 865 866 867  | Next Page >

• Thinking in DAX (#powerpivot and #bism)

  - by Marco Russo (SQLBI)

  Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot . Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each item at a given point in time starting from a transactions table) by using a single DAX formula. I suggest you to read his post to understand the technical details of that. What is inspiring of this example is that we can look at Vertipaq and DAX from several...(read more)

  Read the article

• mysql single database relocation

  - by asdmin

  I would like to know if it's possible to operate different databases on different filesystem locations. Background: we are a hosting service, which hosts mysql, web, and smtp to it's customer, but all our services (sql, smtp, http) are located in a different place. We are going to assign a single logical volume to a customer, which will accommodate the customer's mailing, weppages and (hopefully) sql database. Web pages and mailing are already covered, but I am not able to find a configuration setting which would enable me to specify the location of a database (the directory where mysql stores the DB). Let me please highlight, the target here is to relocate different databases to different locations in the filesystem, not moving them from a single place to an another (single) place. Also please do not bother answering with soft and hard symbolic links. ;) Thanks

  Read the article

• L'authentification forte par Token compromise ? Victime d'une cyber-attaque, RSA se fait dérober des informations sur sa technologie

  L'authentification forte par Token compromise ? La société RSA victime d'une cyber-attaque se fait dérober des informations sur sa technologie La société RSA est bien connue dans le monde de la sécurité d'entreprise. Elle fournit les fameux « Token », ces petits récepteurs qui permettent une authentification forte. [IMG]http://ftp-developpez.com/gordon-fowler/Token.gif[/IMG] Le principe est simple. Une identification « classique » repose sur un identifiant et un mot de passe. Une authentification forte repose, en plus, sur un numéro changeant en permanence (au moins une fois par minute). Ce numéro est envoyé en continue sur ...

  Read the article

• High memory utilization by sqlservr.exe process

  - by abdul samad

  Sub:High memory utilization by sqlservr.exe process. When I look into task manager --processes or by using perfmon memory counters(Sqlserver:memory manager:Target server memory and Total server memory) I am getting high memory utilization by sqlservr.exe process nearly 8 GB (Target server memory counter) and 7.95 GB (Total server memory). and when I restart the MSSQLSERVER service it again shoots up to the same size. I am getting this issue quite frequently. Please help me out in identifying why sql server is using so much memory and how to find out what query , stored procedure etc is making sql server use that much memory. * I am not using any triggers or cursors in my code. Thanks

  Read the article

• Un site lance une "Taxe Internet Explorer 7" pour pousser à migrer vers des navigateurs plus récents, bonne ou mauvaise méthode ?

  Un site australien lance une "Taxe sur Internet Explorer 7" Pour pousser ses utilisateurs à migrer vers des navigateurs plus récents, bonne ou mauvaise idée ? Un site australien de vente en ligne de produits électroniques (TV, caméra, APN, etc.) vient de lancer une nouvelle taxe. L'initiative est peu courante, les taxes étant le plus souvent imaginées par les pouvoirs publics, et les entreprises communiquant plus sur la recherche du meilleur prix. Mais cette fois-ci, ce site ? Kogan.com ? a voulu frapper les esprits de ses clients : tous les visiteurs qui achèteront des produits en utilisant Internet Explorer 7 verront leur facture majorée de 6.8 %. Pourquoi ? Par...

  Read the article

• Le projet Quaero s'impose dans l'analyse des contenus multimédia, et apporte de nouvelles technologi

  Le projet Quaero s'impose dans l'analyse des contenus multimédia, et apporte de nouvelles technologies innovantes Le projet franco-allemand Quaero s'impose dans l'analyse des contenus multimédias depuis 2008. Ce programme de recherche, décrit comme un «*accélérateurde l'innovation en Europe*», est en pleine ébullition depuis deux ans. Financé à hauteur de 40 millions d'euros annuel, il a généré*230 publications,*19 distinctions*dans des conférences ; et ses laboratoires ont produit 45 nouvelles technologies.* Des industriels partenaires financent et portent certains projets de la recherche vers l'industrie. Certaines technologies sont donc déjà en service, comme par exemple celle développée par Exalead permettant de ...

  Read the article

• SSIS Denali CTP1 Source Assistant

  - by andyleonard

  I like the new Data Flow Source Assistant in SSIS Denali. The default view is shown above, with the "Show installed only" checkbox checked. When not checked, the list of Source types changes: In previous versions of SSIS, I rarely created connections in the Connection Managers pane - I usually hit a New button in either a Source or Destination Adapter, or in a task. It was just easier letting the task or adapter pick the proper Connection Manager editor. This is handy and a time-saver. :{>...(read more)

  Read the article

• Education and Career Resources from Microsoft and the Community

  - by KKline

  Sometimes I'm timely in getting the news out on useful resources. And, other times, I'm a bit slower on the draw. As I told my friends back at New Year's Day, "As an official member of the Procrastinators Club, welcome to 2008!" On the other hand, it's always good to remind folks of great resources that are still available and on the shelf. Why? Well, the Internet hits us with such a deluge of constantly new material, that we often forget about the old(ish) stuff that's still really useful. Darth...(read more)

  Read the article

• CIOs: Stop Mandating Training

  - by merrillaldrich

  I love to learn about new technology, and I especially love a long deep-dive technical session with a real expert or a well-crafted, inches thick technical book. Even if either one is expensive. Learning is probably my favorite thing to do. Yet I stand before you with an appeal: Stop “sending people to training.” Why would I say such a thing? Because failure is baked right into that very phrase: “sending people to training.” Death by Training Most of us in the IT world have probably experienced this...(read more)

  Read the article

• PowerPivot: editing measures when you reach 45

  - by AlbertoFerrari

  I have always been used to small fonts but now, as I am getting older, I’d better admit that a greater font is much more relaxing. Editing PowerPivot measures has always been a pain, since all you have available is a small text box and I hate to admit that I got used to leverage ZoomIt for a long time to edit measures. Today I ran into a great Windows feature that I did not know about: ctrl-wheel on the mouse inside a textbox increases the font size of the text box. It seems to work with most textboxes...(read more)

  Read the article

• Terrible Performance with SATA Drives on Dell PowerEdge, steps to troubleshoot?

  - by Tom

  I had asked this question earlier and the question went missing so here it is again. Bought a DELL Poweredge 2950 to use as in-house QA Server. Disk performance is beyond terrible, 1000-4000 ms response time on the drive with our SQL Server database .mdf. Sql Server disk queue upwards of 300 at times. I'm a software guy, can anyone help me with steps to determine the issue? I don't know what RAID controller it has, how can I determine that? I'm speculating it could be BIOS issue. Perhaps the server used to have another kind of drive in it and when I added SATA the ??? buffer size is wrong??? Perhaps I chose wrong options (chose defaults) when setting up the RAID 1 arrays? I thought RAID 1 was a performance array?

  Read the article

• Windows Server 2003 network boogey men every DBA should know

  - by merrillaldrich

  Recently I was again visited by my old friends TCP Chimney and SynAttackProtect . (Yeah, sometimes I feel like I mostly blog about 5-year old problems, but many of us as DBA's have to work on older versions or older systems, and so repeat older problems :-). This has been written about before, but as I BinGoogled around I noticed you are more likely to find the documents if you search for the cause, and not the symptoms. Most people who face a problem, of course, know the symptoms but not the cause....(read more)

  Read the article

• Install Base Transaction Error Troubleshooting

  - by LuciaC

  Oracle Installed Base is an item instance life cycle tracking application that facilitates enterprise-wide life cycle item management and tracking capability.In a typical process flow a sales order is created and shipped, this updates Inventory and creates a new item instance in Install Base (IB).  The Inventory update results in a record being placed in the SFM Event Queue.  If the record is successfully processed the IB tables are updated, if there is an error the record is placed in the csi_txn_errors table and the error needs to be resolved so that the IB instance can be created.It's extremely important to be proactive and monitor IB Transaction Errors regularly.  Errors cascade and can build up exponentially if not resolved. Due to this cascade effect, error records need to be considered as a whole and not individually; the root cause of any error needs to be resolved first and this may result in the subsequent errors resolving themselves. Install Base Transaction Error Diagnostic Program In the past the IBtxnerr.sql script was used to diagnose transaction errors, this is now replaced by an enhanced concurrent program version of the script. See the following note for details of how to download, install and run the concurrent program as well as details of how to interpret the results: Doc ID 1501025.1 - Install Base Transaction Error Diagnostic Program  The program provides comprehensive information about the errors found as well as links to known knowledge articles which can help to resolve the specific error. Troubleshooting Watch the replay of the 'EBS CRM: 11i and R12 Transaction Error Troubleshooting - an Overview' webcast or download the presentation PDF (go to Doc ID 1455786.1 and click on 'Archived 2011' tab).  The webcast and PDF include more information, including SQL statements that you can use to identify errors and their sources as well as recommended setup and troubleshooting tips. Refer to these notes for comprehensive information: Doc ID 1275326.1: E-Business Oracle Install Base Product Information Center Doc ID 1289858.1: Install Base Transaction Errors Master Repository Doc ID: 577978.1: Troubleshooting Install Base Errors in the Transaction Errors Processing Form  Don't forget your Install Base Community where you can ask questions to help you resolve your IB transaction errors.

  Read the article

• DTLoggedExec 1.1.2008.4 Released!

  - by Davide Mauri

  Today I've relased the latest version of my DTExec replacement tool, DTLoggedExec. The main changes are the following: Used a new strategy for version numbers. Now it will follow the following pattern Major.Minor.TargetSQLServerVersion.Revision Added support for Auto Configurations Fixed a bug that reported incorrect number of errors and warnings to Log Providers Fixed a buf that prevented correct casting of values when using /Set and /Param options Errors and Warnings are now counted more precisely. Updated database and log import scripts to categorize logs by projects and sections. E.g.: Project: MyBIProject; Sections: Staging, Datawarehouse Removed unused report stored procedures from database Updated Samples: 12 samples are now available to show ALL DTLoggedExec features From this version only SSIS 2008 will be supported http://dtloggedexec.codeplex.com/releases/view/62218  It useful to say something more on a couple of specific points: From this version only SSIS 2008 will be supportedYes, Integration Services 2005 are not supported anymore. The latest version capable of running SSIS 2005 Packages is the 1.0.0.2. Updated database and log import scripts to categorize logs by projects and sectionsWhen you import a log file, you can now assign it to a Project and to a Section of that project. In this way it's easier to gather statistical information for an entire project or a subsection of it. This also allows to store logged data of package belonging to different projects in the same database. For example:  Updated SamplesA complete set of samples that shows how to use all DTLoggedExec features are now shipped with the product. Enjoy! Added support for Auto ConfigurationsThis point will have a post on its own, since it's quite important and is by far the biggest new feature introduced in this release. To explain it in a few words, I can just say that you don't need to waste time with complex DTS configuration files or options, since a package will configure itself automatically. You just need to write a single statement as a parameter for DTLoggedExec. This feature can simplify deployment *a lot* :)   I the next days I'll write the mentioned post on Auto-Configurations and i'll update the documentation available on theDTLoggedExec website:   http://dtloggedexec.davidemauri.it/MainPage.ashx

  Read the article

• Human Resources Sucks

  - by andyleonard

  Introduction This post is the twenty-seventh part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, Part 1 Metaproblem: Terror I Don't Work On My Car A Turning Point Human Doings Everything Changes Getting It Right The First Time One-Time...(read more)

  Read the article

• Stock Analysis and Moving Average with PowerPivot

  - by Marco Russo (SQLBI)

  One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement calculations that might be useful when you want to implement some stock analysis using PowerPivot and Excel! As you might know, in PowerPivot it is important having a Dates table containing all the days, without exceptions. But when you manage stock...(read more)

  Read the article

• Geek City: What gets logged for SELECT INTO operations?

  - by Kalen Delaney

  Last week, I wrote about logging for index rebuild operations. I wanted to publish the result of that testing as soon as I could, because that dealt with a specific question I was trying to answer. However, I actually started out my testing by looking at the logging that was done for a different operation, and ending up generating some new questions for myself. Before I starting testing the index rebuilds, I thought I would just get warmed up by observing the logging for SELECT INTO. I thought I...(read more)

  Read the article

• Worst code I've written in a while

  - by merrillaldrich

  Here's a nice, compact bit of WTF-ery I had to write for a prod issue today: Again: UPDATE TOP ( 1 ) dbo . someTable SET field3 = 'NEW' WHERE field2 = 'NEW' AND field3 = '' IF @@ROWCOUNT > 0 GOTO Again Can you guess from the code what awesomesauce issues I was working around? This was a reminder for me that sometimes there is time to do it right, but sometimes you just have to do it now. I need that lesson sometimes, as I tend to be a perfectionist. If you are trying to do it right , please don't...(read more)

  Read the article

• Developpez.com passe la barre des 8000 followers sur Twitter : merci !

  Developpez.com passe la barre des 8000 followers Sur Twitter [IMG]http://windows.developpez.com/images/logo-twitter.png[/IMG] Et tous les 3 mois 1000 followers nous rejoignent. Alors que dire de plus ? A part que ce succès est entièrement dû à nos lecteurs et à nos membres toujours plus nombreux et toujours plus fidèles. Des lecteurs et des membres (vous quoi !) à qui nous adressons un immense : [IMG]http://ftp-developpez.com/gordon-fowler/Merci.jpg[/IMG] Création de woodleywonderworks sous licence CC Et pour ceux qui so...

  Read the article

• Raw Materials - The World at Your Fingertips

  For the geek who has everything

  Read the article

• BI Evening @ Hitachi Consulting

  - by tsutha

  Next BI Evening is hosted by Hitachi Consulting. Please register ASAP as there are only limited number of spaces available. Of course there will be free beer and pizza. Great place to network with industry experts. If you are looking for job don't feel shy to talk to us . ThanksSutha

  Read the article

• Fuite d'une vidéo de Windows Phone 8.1, l'OS apportera un nouveau centre de notifications, des changements de l'IU et le support du quad-core

  Fuite d'une vidéo de Windows Phone 8.1 la mise à jour apportera un nouveau centre de notifications, des changements pour l'IU et le support des puces quad-coreMicrosoft va apporter à ses produits une série de mises à jour majeures connue sur le nom de « Blue ».Si Windows 8.1, la mise à jour pour Windows 8 a été confirmée et quelques nouveautés pour l'OS ont été dévoilées, le floue règne encore sur la mise à jour pour l'OS mobile Windows Phone 8.1.Une fuite d'une vidéo d'un smartphone Nokia 920 lève le voile sur les améliorations qu'apportera l'OS, notamment en ce qui concerne l'interface utilisateur et le centre de notifications.L'écran de démarrage de l'OS dans la vidéo présente un nou...

  Read the article

• TechEd 2010 Day Four: Learning how to help others learn

  - by BuckWoody

  I do quite a few presentations, and teach at the University of Washington, and also teach other classes. But I'm always learning from others how to help others learn. At events like TechEd I have access to some of the best speakers around, so I try to find out what they do that works. I attended a great session by allen White, in which he demonstrated a set of PowerShell scripts. He said that Dan Jones of the Microsoft Manageability team told him while he demonstrated a script he needed to provide some visual way to represent the process. Allen used one of the oldest visualizations around - a flowchart. It was the first time I'd seen one used to illustrate a PowerShell script, and it was very effective. I'm totally stealing the idea. All of us are teachers - we help others on our team understand what we're up to. Make sure you make notes for what you find effective in dealing with you, and then meld that into your own way of teaching. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

  Read the article

• SIMD Extensions for the Database Storage Engine

  - by jchang

  For the last 15 years, Intel and AMD have been progressively adding special purpose extensions to their processor architectures. The extensions mostly pertain to vector operations with Single Instruction, Multiple Data (SIMD) concept. The motivation was that achieving significant performance improvement over each successive generation for the general purpose elements had become extraordinarily difficult. On the other hand, SIMD performance could be significantly improved with special purpose registers...(read more)

  Read the article

• Une nouvelle version de Google Docs arrive, axée sur le travail collaboratif en temps réel

  Mise à jour du 13.04.2010 par Katleen Une nouvelle version de Google Docs arrive, axée sur le travail collaboratif en temps réel Google Enterprise a annoncé ce matin une refonte de l'infrastructure de Google Documents lui permettant d'offrir des fonctionnalités plus riches plus rapidement, telles que les fonctionnalités de mise en page (fidélité de l'import d'un document). Cette mise à jour signe l'arrivée de la collaboration en temps réel pour le traitement de texte, ainsi que d'un tableur plus réactif et d'un nouvel éditeur de dessins. La suite bureautique en ligne intègre désormais un module de messagerie instantanée et un système de modification en temps réel dans son traite...

  Read the article

< Previous Page | 856 857 858 859 860 861 862 863 864 865 866 867  | Next Page >