Save info   Get password
Home Submit your blog Edit Account Rules RSS-Archive Contact
    • SQL




      Online sql query execution with SQLzoo
      In Software Development we can find lot of programmers end with issues like, a sql query written specific to a particular database. Some end up with encountering this problem only at production and may face up difficulties in the last minute. In any application it is generally a good practice to write sql queries [...]

      Written by: Digital Compedium


      Vaga: DBA SQL Server Pleno no RS
      DBA SQL Server - Pleno (01)Requisitos : Experiência mínima de 2 anos na função.Conhecimento de Banco de Dados SQL Server, Replicação de dados entre bases SQL Server , Integração entre bancos SQL Server e Oracle, migração de bancos, criação de objetos,alteração de objetos (DDL), Procedimentos de Backup e recuperação, avaliação de performance, leitura de documentação. Ensino Supe

      Written by: Vagas na web


      SQL SERVER - Deferred Name Resolution
      One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP with incorrect column name it [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL Injection Attacks
      ...::SQL Injection Attacks::... ::What is SQL Injection?:: -SQL Injection is defined by Code: as: "The act of entering malformed or unexpected data (perhaps into a front-end web form or front-end application for example) so that the back-end SQL database running behind the website or application executes SQL commands that the programmer never

      Written by: W@rezTehStuff?


      SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2
      Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see some of the advantage and disadvantage [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Software Support Executive (SQL, VB, .NE, MSCE)
      MARG INFOTECH Private Limited requires: Software Support Executives: Should have knowledge of SQL, VB, .NET, MCSE & Installation. Trouble shooting of SoftwareApply immediately at: hrd@marginfotech.comor205, Bhagwati Building, Commercial Complex, Wazirpur Delhi - 52Ph: 47095461

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      SQL SERVER - SP_CONFIGURE - Displays or Changes Global Configuration Settings
      It is very good to know our server and its feature which are available for configurations. SQL Server 2008/2005/2000 always have many feature which can be enabled or disabled. One should atleast know what are the options SQL Server provides. If advanced settings are not enabled at configuration level SQL Server will not let user change [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Onsite .Net Openings : Sr Devp : Australia PR visa - ASP.Net, C#, SQL Server
      Here is an oppurtunity for settling in Australia. A 4 year family visa will be done and will also assist you in Perm Resident Visa. This is for major Consulting firm in Austarlaia. All communication... For more info on latest job openings and other career related information visit my site

      Written by: ITJobs and Career site


      Microsoft SQL Server 2008 Management and Administration (Paperback)
      Microsoft SQL Server 2008 Management and Administration (Paperback)By Ross Mistry Buy new: $29.99$29.99 First tagged “microsoft” by Ross Mistry Customer tags: sql computer 2008, sql server, sql, ross mistry, microsoft Technorati [...]

      Written by: All About Softwares


      SQL SERVER - 2008 - User Account - sa or sysadmin
      Just a day ago, I noticed ’sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ’sa’ account. ’sysadmin’ is actually replacement for legacy ’sa’ account. ’sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL SERVER - 2005 - Two Important Security Update
      If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. Security Update [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Developers: Visual Foxpro on SQL Server/ Oracle/ MySQL: Kolkata
      Standard Software Pvt. Ltd. 699F, Block P, New Alipore, Kolkata – 700053 INDIA Off: (033) 24008804/9240 Requirement for Visual Foxpro on SQL Server/ Oracle/ MySQL: Good Knowledge of Microsoft ArchitectureShould be MCSD/MCAD/MCTS/MCPD WITH 3-4 yrs experience in object Oriented Programming in Visual Foxpro on SQL Server/Oracle/mySQL

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      SQL SERVER - 2008 - Introduction to SPARSE Columns
      I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason I like this feature because [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Microsoft to deliver SQL Server 2008 in August
      The long wait for SQL Server 2008 is nearly over. At its Worldwide Partner Conference in Houston on July 9, Bob Kelly, Microsoft Corporate Vice President of Infrastructure Server Marketing, told attendees that SQL Server 2008 will be on the August price list. He said that Microsoft will keep pricing the same for the new release as it is for SQL Server 2005. Microsoft released the near-final Re

      Written by: Geek Valley


      SQL SERVER - 2008 - Two Convenient Features Inline Assignment - Inline Operations
      Sometimes things just go very convenient and we wish that how come it was not available in earlier versions. Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small example with only one variable demonstrates [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Apostila Microsoft SQL Server 7.0 ( Instalacão, configuração e gerenciamento )
      O SQL Server é um sistema de gerenciamento de bancos de dados cliente/servidor de alto desempenho com alta integração com o Windows NT. Apostila completa com mais de 240 paginas de informaçoes no formato Word. [+] Faça veja já as especificações completas do produto![+] Veja os mínimos requisitos para rodar o pr

      Written by: Baixe Turbo


      Problem Installing SQL Server 2005 from Files Copied Off CDs
      The SQL 2005 installer expects the installation media to be in a specific layout.  If the directory structure is incorrect the error message you receive during setup is: "There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information." The behavior I saw was that the SQL server itself would install, but the

      Written by: CoNetrix Blog


      iGate requirements - Bangalore, Chennai - C#, .NET, IIS, SQL Server 2000 - Technical Lead
      We have an immediate opening with one of our reputed client "iGATE Global Solutions (www.igate.com) " Bangalore. Given below the job details - iGATE Global Solutions, an SEI CMMI Level 5 Company, is... For more info on latest job openings and other career related information visit my site

      Written by: ITJobs and Career site


      SQLAuthority News - Thank You to Awarding Author SQL MVP
      I received award from Microsoft for SQL Server Most Valuable Professional a week ago. I have received many many congratulations messages from many readers for getting this award. I thank all of you for sending me messages and your wishes. Honestly, I think this is all of yours award and I am just receiving this award [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Windows and SQL Server Licensing under Virtualization
      Since SAP more or less supported the usage of VMWare and Hyper-V as Software Virtualization layer for Windows (see SAP OSS note #674851 and ) one question came up more and more. Which is: How do I license Windows and SQL Server in typical SAP scenarios where processor licenses are used? View Full Article: MSDN Blogs

      Written by: Geek Valley


      SQL SERVER - 2008 - Introduction to Row Compression
      In my previous article SQL SERVER - 2008 - Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers. Row Compression feature apply to zeros and [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL SERVER - Difference Between Database Mail and SQLMail
      In recent user group meeting in my city Ahmedabad, I have found that not every user knows difference between these two features of SQL Server. I do not blame any user for not knowing difference between Database Mail and SQLMail as this is very confusing sometime. I will try to explain this concept here. Database mail [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Sony PlayStation site victim of SQL-injection attack
      Some visitors to the Sony PlayStation site may have been prompted to download an antivirus scanner. Pages promoting the PlayStation games SingStar Pop and God of War contained SQL-injected code. Visitors to those specific game pages would see a fake antivirus scan , then a message that their computer was infected with different viruses and

      Written by: Tech FanaTic Blog


      SQL SERVER - Deprecated DataType vardecimal
      I received following email yesterday from Satnam Singh- Computer Programmer from Bangalore. “Dear Pinal, Congratulations for being MVP. You truely deserved it. I wonder why have you never written newly introduced feature of vardecimal. Keep up good work! Satnam Sign Developer - Bangalore.” In SQL Server 2005 SP2 they have introduced new concept of vardecimal, which reduces the size of

      Written by: Journey to SQL Authority with Pinal Dave


      How to escape text in SQL statements
      Two things got me thinking about escaping text in SQL statements recently. I had previously thought it was a simple topic that everybody already knew about but given that these two things occurred I can only assume that not everybody knows about why escaping text in SQL is important and how to do it. First people keep ending up on the FreeFlow website because one of the methods in the class librar

      Written by: Bell End


      SQL SERVER - 2008 - Introduction to New Feature of Backup Compression
      Backup and Data Storage is my most favorite subject and I have not written about this for some time. I was experimenting with new feature of SQL Server 2008 and I come across very interesting feature of Backup compression. Let us see example of Database AdventureWorks with and without compression. After taking backup with compression enabled [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL SERVER - 2008 - Insert Multiple Records Using One Insert Statement - Use of Row Constructor
      I previously wrote article about SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL. I am glad that in SQL Server 2008 we have new feature which will make our life much more easier. We will be able to insert multiple rows in SQL with using only one SELECT [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SEO e SQL injection: é importante se proteger
      No fim do meu post anterior, comentei sobre o problema de deixar sua versão do WordPress desatualizada. Alguns espertalhões tem aproveitado vulnerabilidades para inserir códigos em páginas de sites. Estes códigos tem diversas funções. Uma é a de esconder links nas suas páginas para passar o PageRank da vítima para páginas escolhidas pelo invasor. Outra [...]

      Written by: Marketing de Busca


      JoSQL (SQL for Java Objects)
      Recently I made a post on Language Integrated Query (LINQ) in C#. Since I like that feature very much I did a search for finding some similar libraries for Java. There is one project in sourceforge... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

      Written by: Some Java, J2EE and WebSphere stuffs


      SQLAuthority News - Microsoft Most Valuable Professional Award for SQL Server - MVP
      I am very glad to announce that Microsoft has awarded me Most Valuable Professional Award for SQL Server. I would like to thank Microsoft and MVP Lead Abhishek for awarding this honor to me. MVP is most prestigious award and I am very pleased to receive it. I thank all of my readers for their [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Accelerated SQL Server 2008 (Accelerated)
      The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize

      Written by: Share it to everyone


      SQL SERVER - 2008 - High Availability - Hot Add Memory
      After reading my previous article about SQL SERVER - 2008 - High Availability - Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory. Yes, there are few restictions to Hot Add Memory as well. I am listing them here. 1) Underlying hardware is always [...]

      Written by: Journey to SQL Authority with Pinal Dave


      VB & VB.net : SQL Server Connection Problem?
      Author: jituacSubject: SQL Server Connection Problem?Posted: 29 Jun 08 at 6:13amHi,  I need to run a vb.net application in workgroup.My sql server is installed in XP system,my application is also in same system in a sharing folder.For other system can access the application in sharing folder.But while accessing from other system,sql server is nt connecting.I got security excpetions also,i use

      Written by: ITGalary Forum


      SQLAuthority News - Rise in SQL Injection Attacks Exploiting Unverified User Data Input
      Microsoft is aware of a recent escalation in a class of attacks targeting Web sites that use Microsoft ASP and ASP.NET technologies but do not follow best practices for secure Web application development. These SQL injection attacks do not exploit a specific software vulnerability, but instead target Web sites that do not follow secure coding [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Pesquise por uma string em todos os campos de uma tabela SQL Server
      As vezes necessitamos, pesquisar por uma string eventualmente em todas as colunas de uma tabela. Para isso podemos utilizar uma procedure como essa: CREATE PROCEDURE sp_FindStringInTable @stringToFind VARCHAR(100), @schema sysname, @table sysname AS DECLARE @sqlCommand VARCHAR(8000) DECLARE @where VARCHAR(8000) DECLARE @columnName sysname DECLARE @cursor VARCHAR(8000) BEGIN TRY SET @sqlComman

      Written by: Blog Infomaroto


      SQL SERVER - 2008 - High Availability - Hot Add CPU
      One of team member suggested that we should upgrade to SQL Server 2008 because its new feature is very cool “Hot Add CPU”. Yes, I agree it is very cool feature. I am eagerly waiting for RTM of SQL Server 2008 so I can upgrade our servers to SQL Server 2008. However, to use the feature [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Ro is officially ORACLE SQL AND PL/SQL CERTIFIED
      On an unrelated note, I am officially ORACLE SQL AND PL/SQL CERTIFIED. Just a little thing I did on the side. I know the IT certifications are pretty B.S. but its nice to have them on the side on top of experience & university. Yay me!

      Written by: Roland's Blog


      SQL SERVER - Difference Between DBMS and RDBMS
      What is difference between DBMS and RDBMS? DBMS - Data Base Management System RDBMS - Relational Data Base Management System or Relational DBMS A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Minimize Blocking in SQL Server 2008
      At a Glance: Why lock escalation occurs Avoiding unnecessary blocking Optimizing your queries Monitoring the impact of locking on performance Read More: -us/magazine/cc434694(TechNet.10).aspx

      Written by: Geek Valley


      SQL 2008: What’s New
      At a Glance: More powerful management Improved performance and scalability Better security and availability Changes for developers Read More: -us/magazine/cc434690(TechNet.10).aspx

      Written by: Geek Valley


      SQL DBA Specialist - Capgemini
      Job Description Database Environment ReplicationCreating Schema Creating Test Data Migration Process if required Performance monitoring and tuning Will be functioning as a production DBA offshore and working in 24X7 enviroment. Will be responsible for managing the process of the project and for defining / managing the assignment of tasks and prioritization. Will be involved in client interaction a

      Written by: INDIAN JOB MELA


      Microsoft gets more pro-active against SQL injection attacks
      Turning up the volume on its vigilance against perhaps the easiest exploit in the world, Microsoft yesterday unveiled a new beta of an overdue security tool for IIS 7, bolstered by two new SQL injection vulnerability seeker tools. Download Microsoft UrlScan filter 3.0 Beta from FileForum now. Last April, the vulnerability spotlight was turned once again on Microsoft, as it found itself answe

      Written by: Geek Valley


      Cross table update for Ms SQL T-SQL
      Yesterday I make some mistake on accidentally update the data in the table. But lucky we have a daily backup of database in our server. So try to restore back the backup to a new database and the do a cross database and cross table update to recover back the latest possible data. Try to google and MSN with some of my experience friend and found out this, just to upload to here in case may need

      Written by: David World...


      SQLAuthority Download - SQL Server Cheatsheet
      I think this is most popular question I receive in email, if I have SQL Server cheatsheet. Well, SQL Server is very wide subject and covering all the main topics of SQL Server will take 100 pages book as cheatsheet. I have tried to create one page cheatsheet which I use for my daily use. [...]

      Written by: Journey to SQL Authority with Pinal Dave


      New Information on SQL Injection Attacks
      I just wanted to make sure that you have seen the Advisory (Rise in SQL Injection Attacks Exploiting Unverified User Data Input) where we added some additional information. This is especially important as we did not "only" publish guidance but tools as well: Detection – HP Scrawlr (a free scanner from HP) Defense – UrlScan version 3.0 Beta Identifying – Microsoft Source Code Analyzer for S

      Written by: Roger\'s Security Blog


      SQLAuthority News - Release Notes for SQL Server 2008 Release Candidate 0
      All product should be documented. Particularly when any release happens product must have release notes because release notes educates people about product and its usage. Microsoft has also release notes for SQL Server 2008. This Release Notes document contains information for Microsoft SQL Server 2008 Release Candidate 0 (RC0) that supplements the SQL Server 2008 RC0 [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL SERVER - Create Check Constraint on Column
      I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before it enters in the database. Let [...]

      Written by: Journey to SQL Authority with Pinal Dave


      SQL*Plus command line history completion
        The rlwrap (readline wrapper) utility provides a command history and editing of keyboard input for any other command. This is a really handy addition to SQL*Plus and RMAN . Download the latest rlwrap software from the following URL.~hlub/uck/rlwrap/ Unzip and install the software using the following commands. gunzip rlwrap*.gz tar -xvf rlwrap*.tar cd rlwrap* ./

      Written by: Oracle Apps Blog


      SQL STAR hiring Device Driver developers
      To introduce us, SQL Star International has been in the business of delivering business solutions through technology since its inception in 1987. Headquartered in India with wholly owned subsidiaries in US, Singapore and Australia with over 1100 professionalsCurrently we are looking for Embedded Software Engineers for Hyderabad location with the following skillsSkills/Experience• 3-10 years of s

      Written by: JobHolic.Com


      SQL SERVER - Find Current Identity of Table
      Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity. USE AdventureWorks GO SELECT MAX(AddressID) FROM Person.Address GO However, I prefer following DBCC command to figure out current identity. USE AdventureWorks GO DBCC CHECKIDENT (‘Person.Address&

      Written by: Journey to SQL Authority with Pinal Dave


      SQLAuthority News - White Paper: SQL Server 2008 Compared to Oracle Database 11g
      Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g. Included in This Document *      Executive Summary *

      Written by: Journey to SQL Authority with Pinal Dave


      VB.Net, SQL Server , J2EE, Oracle in Kolkata
      American Company needs Software developers for Kolkata branch Office having 2-5 years of Experience in: C#, VB.Net, ASP.Net, AJAX, SQL Server 2005 responsible for understanding specifications , designing and developing Software SoloutionsJ2EE , J2ME (Favored), Oracle PL/SQLCandidates having BCA, MCA, BE, BTech or similar qualifications and who can take ownership and pride in their work, who are

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      SQL SELECT Command
      SQL SELECT Command is without a doubt the most frequently used SQL command that’s why we are starting our tutorial with it. The SQL SELECT command is used to retrieve data from one or more database tables. To illustrate the usage of the SELECT command we are going to use the Users table defined in the previous... Oracle certification: Offering services of providing oracle certification materi

      Written by: Oracle Certification Material


      PM Guru Inc.: ASP / SQL Programmers : NOIDA
      PM Guru Inc., USA & Centre for Excellence in Project Management (P) Ltd., is looking for the following Software Professionals: Location : NOIDA Qualifications: BE/ B.Tech /MCA /M.Sc.(IT) Send resume to : hr@cepm.com (Quote position applied in Subject) Sr. Programmers / Team Lead - (Experience 5+ years) : proficient in ASP, ASP.net 1.1 & 2.0, .Net Framework, C#, MS SQL Server 2000/05, AJAX

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      Troubleshooting SQL Server Cluster Installations
      On a Windows Cluster it is possible to install a SQL Server Cluster, which will be a separate entity with disctinct Virtual Server Name, IP address, and pipe name. The nodes of the SQL Cluster must be able to communicate with one another. This communication may fail if the TCP port on which SQL Server is listening is not excepted from firewalls on the machines. This port can be found by using the

      Written by: Geek Valley


      SQL Data Definition Language (DDL)
      The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables. The most important DDL statements in SQL are: CREATE TABLE - creates a new database table ALTER TABLE - alters (changes) a database table DROP TABLE - deletes a database table CREATE INDEX..

      Written by: Oracle Certification Material


      SQL Data Manipulation Language (DML)
      SQL (Structured Query Language) is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records. These query and update commands together form the Data Manipulation Language (DML) part of SQL:SELECT - extracts data from a database table UPDATE - updates data in a database table DELETE - deletes data from a database table INSERT INTO - inserts...

      Written by: Oracle Certification Material


      SQL Database Tables & SQL Queries
      SQL Database Tables A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data SQL Queries With SQL, we can query a database and have a result set returned. A query like this: SELECT LastName FROM Persons Note: Some database systems require a semicolon at the end of the SQL statement. We don't use...

      Written by: Oracle Certification Material


      SQL is a Standard - BUT....
      SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Unfortunately, there are many different versions of the SQL language, but to be in compliance with...

      Written by: Oracle Certification Material


      What is SQL?
      SQL is a standard computer language for accessing and manipulating databases.SQL stands for Structured Query Language SQL allows you to access a database SQL is an ANSI standard computer language SQL can execute queries against a database SQL can retrieve data from a database SQL can insert new records in a database SQL can delete records from a database SQL can update records in a database SQL...

      Written by: Oracle Certification Material


      SQL SERVER - 2008 - SQL Server Start Time
      I have been playing with SQL Server 2008 recently. There are many new features which SQL Server 2008 have. One of the interesting addition to SQL Server 2008 is system table field which records when SQL Server was started. This field has data type as datetime that is why it is precise to 3 milisecond. Note [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Require B.Sc. Freshers Oracle, PL/SQL & SQL Server, PHP professionals
      Immediate openings for B.Sc. Freshers also Oracle, PL/SQL & SQL Server and PHP Programmers at Bangalore Intrested candidates can directly come for the face to face discussion: Venue: CRM Consultancy Universal Business Centre , TNR Chambers, 1/A Chruch street, Brigade Road, (Landmark:opposit to nokia showroom,nasa pub) Bangalore - 560 001 Mobile: 9741111362 E-mail Resume at: manohar@

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      SQL SERVER - Introduction to SERVERPROPERTY and example
      SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name etc. Run following script to see all the properties of server. SELECT ‘BuildClrVersion’ ColumnName, SERVERPROPERTY(‘BuildClrVersion’) ColumnValue UNION ALL SELECT ‘Collation’, 

      Written by: Journey to SQL Authority with Pinal Dave


      SQuirreL SQL Client - Datenbank-Verwaltung wird zum Kinderspiel
      Das in Java geschriebene, quelloffene SQuirreL (installierte Java Runtime vorausgesetzt) ist der ideale Helfer für Datenbank-Nutzer. Es bringt JDBC-Treiber für alle gängigen Datenbanken mit über die sich sich mit Ihrer Datenbank verbinden können. Weiterhin können Sie SQL-Kommandos direkt im Programm ausführen und sich Relationen sowie deren Beziehungen zueinander grafisch anzeigen lassen.

      Written by: freeware-blog


      SQL SERVER - 2008 - Inline Variable Assignment
      I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable. —- SQL Server 2005 Way DECLARE @MyVar INT     SET @MyVar = 5 SELECT @MyVar

      Written by: Journey to SQL Authority with Pinal Dave


      Modificare/vedere un database SQL graficamente
      Un database SQL, non è bello da vedere in formato testo, si, è professionale, ma, è molto freddo e monotono, ecco un programma gratis, che permette di vederlo e modificarlo graficamente, e, ha molte... consigli e trucchi,per poter conoscer meglio,personalizzare,velocizzare il computer (hardware,programmi,linux e windows).

      Written by: tips and triks di computer


      SQL SERVER - 2008 - Introduction to Policy Management - Enforcing Rules on SQL Server
      I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario. If our company policy is to create all [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Jobs (Vacancy) In iflex solutions AS A Software Developer - Oracle, PL/SQL with Unix
      Position: Software Developer - Oracle, PL/SQL with UnixDescription: * Develop and test the modules and units associated with the project * Responsible for adhering to the internal quality processes, production support and enhancements and on-site maintenanceEducation: Post Graduate/B.E/MCA/MBA Experience: * 4-6 years of hands-on experience in software development * Experience in Oracle

      Written by: GOVERNMENT JOBS | CITYJOBS | ALL TYPE JOBS


      Oracle PL/SQL Programming (Paperback)
      Oracle PL/SQL Programming (Paperback)By Steven Feuerstein 26 utilised and new from $1.15 Customer Rating: First tagged “oracle” by ROBERT S SMILEY Customer tags: relational databases, sql, pl-sql, oracle, database direction systems [...]

      Written by: All About Softwares


      SQL Injection Attacks: The future of mass hacking campaigns (updated)
      SQL injection attacks are evolving as the prime mode of transportation for malicious scripts that hackers wish to insert into legitimate web-sites. Typically the web-site is a vehicle for distributing Trojans through scripts crafted to exploit certain vulnerabilities on visiting PCs.   These scripts are often designed to exploit vulnerabilities that the vendor usually has a patch [...]

      Written by: Panda Security USA Technology Blog


      Hyderabad Openings - Wipro Technologies of Project Manager - ASP.NET, C# , SQL SERVER 2005, SSRS
      As there are Openings for Wipro Technologies of Project Manager. We are not from consultancy; you will be on direct permanent payrolls of Wipro Technologies. Hence, Go through the job description &... For more info on latest job openings and other career related information visit my site

      Written by: ITJobs and Career site


      Requirement - .NET APPLICATIONS TEAM LEAD / SQL Server Database Architect / SENIOR MICROSOFT SOLUTIONS ARCHITECT
      REQUIREMENT : 1 .NET APPLICATIONS TEAM LEAD...This position, which will report to the Associate VP, Delivery Management, will be responsible for the development, enhancement and maintenance of... For more info on latest job openings and other career related information visit my site

      Written by: ITJobs and Career site


      SQL Server Magazine, April 2008
      The Next Generation: Visual Studio 2008 Take a tour of the new features and functionality in Visual Studio 2008. LINQ to Your SQL Server Data Build efficient queries using LINQ, which is included in Visual Studio 2008. Debugging and Logging in SSIS Easily debug packages, Control Flow tasks, and Data Flow tasks as well as log package-execution information using the capabilities in SSIS. SQL

      Written by: Download Center IT Category


      Supervalu, Bangalore openings - SharePoint, C#, .Net and SQL Server
      Career opportunity with one of our client, SUPERVALU Bangalore location for the following skill set: SharePoint, C#, .Net and SQL Server with 5+ years of experience. ABOUT SUPERVALU: 1. Our client... For more info on latest job openings and other career related information visit my site

      Written by: ITJobs and Career site


      Microsoft SQL Server 2008 10.00.1442.32 RC0
      SQL Server 2008 provides a comprehensive data platform that is secure, reliable, manageable, and scalable for your mission critical applications. With it, developers can create new applications that can store and consume any type of data on any device, enabling your users to make informed decisions with relevant insights. SQL Server 2008 RC0 is available in Enterprise, Standard, Evaluation, and E

      Written by: Geek Valley


      SoftGrid: Installation program unable to read SQL. upgrade files for the configuration database
      This was the error message that confronted one of TechNet Forum customers when they were trying to upgrade there VAS from 4.1.2.20 to 4.1.3.16. And its a really interesting issue! All you get when you try and upgrade is an error message saying “The installation program was unable to read the SQL. upgrade files for the [...]

      Written by: D' Technology Weblog


      SQL SERVER - Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
      Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007. The download provides the following functionality: A Report

      Written by: Journey to SQL Authority with Pinal Dave


      Final release of SQL Server 2008 inches closer
      Microsoft made available to select testers on June 5 the near-final Release Candidate (RC) 0 of SQL Server 2008. As of Friday, Microsoft had released the latest test build of its database to TechNet Plus and Microsoft Developer Network(MSDN) subscribers only. The new build wasn’t on the private Connect test site. (Not sure if availability has changed since then.) Microsoft officially “laun

      Written by: Geek Valley


      Vaga: Analista Programador SQL
      Analista Programador SQL Necessário experiência minima de 3 anos com Desenvolvimento SQLInglês avançado/fluenteLocal de trabalho: Região de CampinasContratação CLT + BeneficiosEnviar curriculum por e-mail para cpaz@attps.com.br

      Written by: Vagas na web


      Country Lists In HTML And SQL
      Most of the membership forms include a country list. Urbano Alvarez is presenting ready to use country list data in several languages. The lists are in the HTML format as: <select id="countrySelect" > <option value="AF">Afghanistan</option> <option value="AL">Albania</option> <option value="DZ">Algeria</option>

      Written by: WebResourcesDepot


      copy sql data to anothers fields
      hi,please help.current i have data and sevenpoint fields from the sql database table.i want to use sql query to copy the database from data fields insert to sevenpoint if the the txtcompares.text = 35 or - 35 otherwise the data copy to ...

      Written by: Sushi or Death - for the addicted


      MySQL Pocket Reference: SQL Functions and Utilities (Pocket Reference (O’Reilly)) (Paperback)
      MySQL Pocket Reference: SQL Functions and Utilities (Pocket Reference (O’Reilly)) (Paperback)By George Reese Buy new: $14.99$10.1943 utilised and new from $6.00 Customer Rating: First tagged “mysql” by Aaron Customer tags: rdbms mysql [...]

      Written by: All About Softwares


      SQL BETWEEN: Searching Between Two Specified Values (Range)
      Syntax expression [ NOT ] BETWEEN lower_value AND higher_value The SQL BETWEEN Operator are used to display rows between two specified values. The lower value are placed before AND operator and the higher value are placed after AND operator. For Example you have a table called Articles that contain the following Data: ArticleID Title PageView PublishDate --------- -----

      Written by: Basic and Advance programming tutorial and tips, software tutorial and free e-books


      Using SQL Outer Join
      When you use SQL JOIN/INNER JOIN, the result are rows that only matches in both table based on Join condition you specified in the FROM clause. If you need to display all rows from at least one of the tables mentioned in the FROM clause, you can use SQL OUTER JOIN statement. There are 3 types of SQL Outer Join. Outer joins are specified with one of the following sets of keywords when they are spec

      Written by: Basic and Advance programming tutorial and tips, software tutorial and free e-books


      SQL JOIN : Retrieving Data from many Tables
      Joins are created when we display Data in queries that using more than one tables. we can connect a row in one table to another row in other table using the same value of both rows. Usualy this relation represented as Primary Key and Foreign Key relationship. Joins allow an association between a field in one table or view with a field of the same data type in another table or view. Joins show how

      Written by: Basic and Advance programming tutorial and tips, software tutorial and free e-books


      SQLAuthority News - SQL Server 2008 Release Candidate 0
      Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback. SQL Server 2008 provides a comprehensive data platform that is secure, reliable, [...]

      Written by: Journey to SQL Authority with Pinal Dave


      Programmer for Clipper, VB.Net, ASP.Net / SQL
      Required Computer Programmer: Wanted male programmer with through knowledge of Clipper 5.3 and real time experience in developing Web Applications using VB.NET, ASP.NET / SQL Server / Crystal Reports. Extensive exposure in developing financial and inventory packages will be advantageous. Please apply with detailed CV to: clippercandidates@yahoo.co.in

      Written by: Top IT jobs in India for Freshers & Experienced IT professionals


      How To Find Out Last Month’s Top Commentators - Run This SQL Query
      You might have seen the post coming up on this blog again in last week after I come back from the hospital, everything went well and I am enjoying bed rest since last couple of days until all next week. Due to the blogging break for surgery, there were three pending actions for me here. [...]

      Written by: Life is Colourful


      Uued versioonid: SQL Server 2008, Silverlight ja VSeWSS 1.2
      USA-s toimuva TechEd 2008 ajal, nagu ikka, annab Microsoft välja oma toodete uusi versioone. Viimase nädala jooksul on Microsoft toonud häid sõnumeid andmebaaside, Silverlight’i ja SharePoint’i arendajatele. SQL Server 2008 RC0 SQL Server 2008 väga esimene release candidate, mis kannab millegi pärast numbrit 0, on kättesaadav kõigile MSDN’i ja TechNet’iga liitunud

      Written by: DT blogi


eXTReMe Tracker