Search Results

Search found 42327 results on 1694 pages for 'microsoft sql t sql'.

Page 335/1694 | < Previous Page | 331 332 333 334 335 336 337 338 339 340 341 342  | Next Page >

• Using ASCMD to run command line scripts for SQL Server Analysis Services

  Sometimes it would be helpful to run scripts from a command line for Analysis Services. This would be useful for things like creating backups, processing data or running other tasks. Is there a command line tool like sqlcmd for multidimensional databases and Data Mining? What are your servers really trying to tell you? Find out with new SQL Monitor 3.0, an easy-to-use tool built for no-nonsense database professionals.For effortless insights into SQL Server, download a free trial today.

  Read the article

• How To Prevent Microsoft SQL Injection in ASP.Net

  This is a two-part tutorial series meant to help beginners understand MS SQL database injection and the problems associated with it particularly when applied to an ASP.NET web form application. It also outlines preventive measures which will be discussed thoroughly in the second part so that you can secure your SQL-based web applications.... ALM Software Solution ? Try it live! Requirements Management, Project Planning, Implementation Tracking & QA Testing.

  Read the article

• Point to Taken Care while Microsoft SQL Patching Testing in Production

  - by AbhishekLohani

  Originally posted on: http://geekswithblogs.net/AbhishekLohani/archive/2013/10/29/point-to-taken-care-while-sql-patching-testing--in.aspx Point to Taken Care while Microsoft SQL Patching Testing in Production It very critical testing like Paching testing  1. Build the Test Environment Parrel to Production Environment i.e Staging Environment2 Check the Version of Application deployed is same as Production Environment if Staging Environment not parrel to production environment then risk of defect in production 3.Check End to End Flow of Appliction 4 Check the Eventlog entries 5 Check the performance of the Application . Thanks & RegardsAbhishek

  Read the article

• SQL Saturday #255 Dallas

  SQL Saturday is coming to Dallas on November 2. This is a free, one day conference for SQL Server training and networking. On November 1, there will be a pre-conference event featuring Andy Leonard, Grant Fritchey, and Drew Minkin. Deployment Manager 2 is now free!The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here

  Read the article

• Creating a comma-separated list (SQL Spackle)

  Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield. NEW! Deployment Manager Early Access ReleaseDeploy SQL Server changes and .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try the Early Access Release to get a 20% discount on Version 1. Download the Early Access Release.

  Read the article

• Cleaning Up SQL Server Deployment Scripts

  Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema can, for valid reasons, contain other conflicting truths that can't easily be captured in source control. Dave Ballantyne explains the problems and suggests a solution. Compress live data by 73% Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.

  Read the article

• Téléchargez les dernières mises-à-jour de Microsoft Access

  Bonjour Afin de faciliter les mises à jour de vos outils de travail, nous avons regroupés pour vous les différentes mises à jour publiées par Microsoft et appliquables à Access (de 97 à 2007) Télechargez les dernières mises à jour de Microsoft Access...

  Read the article

• SQL Server Management Studio keyboard shortcuts - Part 1

  As responsibilities are growing every day, a DBA or developer needs to improve his/her productivity. One way to do this is to use as many shortcuts as possible instead of using your mouse and the menus. In this tip we take a look at common tasks you may perform when using SSMS and the associated shortcut keys. SQL Backup Pro SQL Backup Pro was the smartest kid at school. Discover why.

  Read the article

• Create a Monitoring Server for SQL Server with PowerShell

  At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly. Get Smart with SQL Backup Pro Powerful centralised management, encryption and more.SQL Backup Pro was the smartest kid at school Discover why.

  Read the article

• Microsoft Access Small Business Solutions

  Microsoft Access Small Business Solutions, published by Wiley, proves that Microsoft Access can be used to create valuable business solutions in theory and in practice by providing both the reasoning for the database design and the databases themselves in the CD that accompanies the book.

  Read the article

• How To Support Multiple SQL Server Package Configurations in SSIS

  I have several applications that use SSIS packages and I want to be able to store all the configurations together in a single table when I deploy. When a package executes I need a way of specifying the "application" and having SSIS automatically handle the package configuration based on the application. Compress live data by 73% Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.

  Read the article

• Microsoft soutient Node.js et participe au développement de la bibliothèque JavaScript client/serveur

  Microsoft soutient Node.js Et participe au développement de la bibliothèque JavaScript client / serveur Sur le blog interoperability Claudio Caldato (Principal Program Manager of Interoperability Srategy Team) annonce que Microsoft va participer au développement d'une version Windows de Node.js Le premier objectif consistera à ajouter à Node une API IOCP Windows performante. Cette phase initiale achevée, un programme exécutable (node.exe) sera disponible sur le site nodejs.org et Node.js fonctionnera alors sur Win...

  Read the article

• IBM lancera sa suite bureautique Cloud LotusLive Symphony pour contrer Google, Microsoft et Oracle

  IBM lancera sa suite bureautique Cloud LotusLive Symphony pour contrer Google, Microsoft et Oracle Jusqu'ici, IBM proposait plusieurs outils professionnels en mode hébergé (partage de fichiers, messagerie instantanée et vidéo-conférence, mails, etc.) avec LotusLive. Mais le numéro 2 mondial du logiciel ne proposait pas de suite bureautique. Un problème qui allait devenir stratégique puisque le numéro 1, Microsoft, a lancé l'été dernier ses Office Web Apps, et le numéro 3, Oracle, son Cloud Office en fin d'année. IBM a donc ann...

  Read the article

• Using SQL Server's Output Clause

  When you are inserting, updating, or deleting records from a table, SQL Server keeps track of the records that are changed in two different pseudo tables: INSERTED, and DELETED. These tables are normally used in DML triggers. If you use the OUTPUT clause on an INSERT, UPDATE, DELETE or MERGE statement you can expose the records that go to these pseudo tables to your application and/or T-SQL code.

  Read the article

• Handling Constraint Violations and Errors in SQL Server

  The database developer can, of course, throw all errors back to the application developer to deal with, but this is neither kind nor necessary. How errors are dealt with is dependent on the application, but the process itself isn't entirely obvious. Compress live data by 73% Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.

  Read the article

• SQL Saturday #39 - New York City

  Come to this great one day training event in New York, New York. SQL Saturday comes to the Big Apple and is a great way to get free training on all aspects of SQL Server.

  Read the article

• Management of Windows Azure SQL Databases via PowerShell with REST APIs

  Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly. FREE eBook – "45 Database Performance Tips for Developers"Improve your database performance with 45 tips from SQL Server MVPs and industry experts. Get the eBook here.

  Read the article

• Steps to Rename a Subscriber Database for SQL Server Transactional Replication

  I have transactional replication configured in production. The business team has a requirement to rename the subscription database. Is it possible to rename the subscription database and ensure that transactional replication will continue to function as before? If so, how could we achieve this? Get smart with SQL Backup ProPowerful centralised management, encryption and more.SQL Backup Pro was the smartest kid at school. Discover why.

  Read the article

• Creating Indicator and Gauge Report in SSRS - SQL Server 2008 R2

  SQL Server Reporting Services allows you to embed indicators and Gauges in your report to analyze the data and its state. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent state value of Key Performance Indicator (KPI). New! SQL Monitor 3.0 Red Gate's multi-server performance monitoring and alerting tool gets results from Day One.Simple to install and easy to use – download a free trial today.

  Read the article

• Stairway to T-SQL DML Level 12: Using the MERGE Statement

  The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement. An accidental DBA? Try SQL MonitorUse the 30-day full product free trial to get easy-to-understand insights into SQL Server, and get suggestions on how to solve the type of issues that are uncovered. Begin your free trial.

  Read the article

• Renaming a Published SQL Server Database

  I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration. Get Smart with SQL Backup Pro Powerful centralised management, encryption and more.SQL Backup Pro was the smartest kid at school Discover why.

  Read the article

• New SQL Monitor Metric: Principals with Sysadmin Login

  This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.

  Read the article

• Microsoft confirme « Windows 8.1 with Bing », les premiers dispositifs sous l'OS seront dévoilés le mois prochain

  Microsoft confirme « Windows 8.1 with Bing » les premiers dispositifs sous l'OS seront dévoilés le mois prochainMicrosoft vient de confirmer « Windows 8.1 with Bing », une déclinaison de son système d'exploitation qui avait fait l'objet de plusieurs rumeurs il ya quelques mois. Dans un billet sur le blog Windows, Microsoft a affirmé que l'objectif de cette version de Windows est de permettre à ses partenaires fabricants d'appareils de commercialiser de nouveaux dispositifs à faible coût sous Windows.Windows...

  Read the article

• The Strategic Value of Monitoring SQL Servers

  Why would you ever need to automatically monitor the SQL Servers in your care? What is the business value of doing so? What are the important features that a DBA should look for in a performance-monitoring tool? Rodney Landrum gives answers based on long experience. Get smart with SQL Backup ProGet faster, smaller backups with integrated verification.Quickly and easily DBCC CHECKDB your backups. Learn more.

  Read the article

• Windows Phone passe officiellement la barre symbolique des 100.000 applications, Microsoft remercie les développeurs

  Windows Phone passe officiellement la barre très symbolique des 100.000 applications Microsoft remercie les développeurs L'étape avait été annoncée par la presse américaine au début du mois, elle est cette fois-ci officielle. En marge de la présentation du prochain Windows Phone 8, Microsoft a annoncé que son Maketplace d'applications mobiles proposait aujourd'hui plus de 100.000 références. « Une étape que nous avons atteinte plus vite qu'Android », souligne Joe Belfiore en charge de la plateforme. Ce sont à présent deux cents nouveaux titres qui viennent...

  Read the article

< Previous Page | 331 332 333 334 335 336 337 338 339 340 341 342  | Next Page >