SQL

Introduction I've seen a lot of short tutorials on SQL injections and then again some which rivals the Great Wall of china in length, but I've very rarely seen a SQL injection tutorial based on an actual hack where things aren't always ideal. This guide will attempt to explain the very basics of SQL injections. This tutorial is written from a website created by a friend of mine which was

Andrew Karasev asked: Microsoft Dynamics GP, current version 10.0 as of June 2008 is pretty flexible platform if you are looking for modifications, custom modules programming, add-ons and extensions. As many mid-size ERP GP has multiple customizing tools and you have to get some excurse into each one of them to select the best in [...]

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. One step at a time, you

In molti sanno che Microsoft da qualche anno a questa parte distribuisce alcuni suoi prodotti in versione Express cioè liberi da qualsiasi costo di licenza. Tra questi prodotti troviamo le ultime due versioni di Visual Studio: 2005 e 2008, o le versioni Sql Server 2005 Express e Sql Server 2008 Express. Questi prodotti come è facile intuire presentano però delle limitazioni. Per ese

Mendengar mengenai SQL Injection, kita terkenang lagi dengan kasus KPU yg kebobolan terhdp serangan hacker. Dengan menginjeksi kode-kode yg terhadap di bahasa programming sehingga mampu memanggil... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Few days ago, I have wrote about SQL SERVER - DISABLE and ENABLE user SA I received following email from one of the user who received following error. Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ’sa’, because it does not exist or you do not have permission. Fix/Workaround/Solution: This error had occurred because of [...]

Just a day ago, I received question from blog reader Mike McDonald. “How can I modify permissions for SA user? I tried to modify dbo users permission but now I am having problems.” First of all, there may be no relation between dbo user and SA user. They are different and should be left separate. Modifying the permission [...]

It is quite common myth that SQL Server 2008 Developer Edition is FREE. SQL Server 2008 developer edition has same code base and same features which are available in SQL Server 2008 enterprise edition. Only difference between them is licensing terms. Developer Edition can not be used in production environment and it can be used on [...]

I often receive good question on blog, however, I do not always receive good answer for the questions. Imran Mohammed is one SQL Expert who spend his time helping SQL Community on this blog. I always read his answers as there is something to learn everytime. Recently someone asked on blog about Finding next run [...]

Feature Pack for SQL Server 2005 December 2008 Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005. Microsoft SQL Server Protocol Documentation The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and

Just a day before I wrote about SQL SERVER - Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE AdventureWorks GO /* Create Test Table */ CREATE TABLE TestTable (FirstCol VARCHAR(10)) GO /* Check Database Column 

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The December 2008 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and Updated Books Online Topics” for [...]

A GTCON, consultoria provedora de soluções inovadoras em tecnologia da informação, em parceria com empresa multinacional seleciona profissionais:*Desenvolvedor SQL **Requisitos*Experiência desenvolvimento utilizando SQLConhecimento em UNIXInglês Avançado ou FluenteLocal de Trabalho: HortolândiaForma de contratação: CLT + Benefícios (VR, VA, VT e Plano Saúde\Odonto)Interessados que aten

Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer Standard Workgroup Download Service Pack 3 for Microsoft SQL Server [...]

I really enjoyed users participation in my previous question. Read SQL SERVER - Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users took this test seriously and [...]

Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explainary so I will not explain it much. /* Find Collation of SQL Server Database */ SELECT DATABASEPROPERTYEX(‘Advent

I received following email from Mike Bikkins. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?” No. You can not connect with SQL Server 2005 and higher version using Enterprise Manager. You will need SQL Server Management Studio available with SQL Server 2005 and higher version. Reference : Pinal [...]

PHP-MySQL Clone of my ASP-MS SQL image hosting website, including image editor (GD or imagemagick (I would prefer GD) and Ad Assistant Pro. Ability to select resize image uploads while uploading(resize to be set in admin control)... (Budget: $30-250, Jobs: Linux, PHP)

Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run the script described in email. [...]

Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who have same color as ColorCode or have [...]

This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online. A successful upgrade to SQL Server 2008 [...]

In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of the candidate was able to [...]

Please send your profiles to saikrishna.chiranjeevi@droisys.com   We have a Client hot requirement in Downtown Dallas, TX if you have any consultants for below requirement, Please Send the resumes/Rate and contact details. I really appreciate for your time and help  v Role: Sr. SQL Server DBA that has expertise with Replication and SAN experience Location: Downtown Dallas, TX

When installing service pack 2 for SQL 2005, sometimes a bug presents itself where the installer needs access to some files that are inside the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder. The bug is that these files do not have the correct permissions set. Even the Administrator does not have permission on these files. If you set the permissions for the data folder to th

Posting list of blanked pages, 4 pages Please see User:SQL/PlzFix ← Previous revision Revision as of 02:00, 1 December 2008 Line 3: Line 3: * [[:Bri_Peppers]] * [[:Bri_Peppers]] * [[:List_of_Asian_American_scientists]] * [[:List_of_Asian_American_scientists]]   + * [[:Spanish-American_War]] |- |- |<

O Oracle é um sistema de gestão de base de dados relacionais criado pela empresa Oracle Corporation, fundada e presidida pelo multimilionário Larry Ellison. Este sistema é líder no mercado e é disponibilizado em várias versões: pagas e não pagas. Neste artigo, explicarei como instalar a versão Oracle XE (Express Edition) que, por ser gratuita, [...]

The Default.aspx.vb code:' **************************************************************************' Sample code for deploying a SQL Database to a Remote Host executing a T-SQL ' code using an ASP.NET 2.0 callbacks. Written as a sample with use in conjuction ' with the SQL Server Database Publishing Wizard.' For more information visit ' -----------------------------------------------------------

The web.config code:

Though The Database Publishing Wizard can provide separate scripts for diferent objects and current PCs are pretty powerful, the copy / paste approach is unlikely to handle more than tenths of megabytes of script. But for many developers it would be okay in many cases. In next versions I hope I'll overcome the limitation.You are uploading an .aspx page to a remote host and pointing Internet Explor

Dot Net CLR and all .net realtes application and Sql Server run in same process or we can say that that on the same address because there is no issue of speed because if these two process are run in different process then there may be a speed issue created one process goes fast and other slow may create the problem.

Author: JijoSubject: Access/SQL Query Question-Find Newest RecordPosted: 22 Nov 08 at 6:05pmI think u can do this in a better way. But for that u need a primary key for this table. Or a field with a unique Id. What i would do is add a new field DWGS.Id which is an autonumber. Then i would find the Id of the record with the criteria u specified  select top 1 Id from tablename where D

Suppose that we have a list [10, 20, 4, 6, 9], and we want to write a sql query to get the data for all elements of the list, like SELECT * FROM students WHERE id IN (10, 20, 4, 6, 9) How to do that in Python? Actualy, it is very easy. Below are the list [...]

I love active participation from my readers. Just a day ago I wrote article about SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure. DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT [...]

Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was [...]

What is Godsw SQL Compare? Godsw SQL Compare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. Godsw SQL Compare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name FROM sysobjects s WHERE type = ‘

Author: msmith974Subject: Access/SQL Query Question-Find Newest RecordPosted: 19 Nov 08 at 7:00pmHello,I have an access database application with the following table & fields that I would like to query: Table Name: DWGSFields: DWGS.Discipline, DWGS.Area/Bldg, DWGS.DWGS, DWGS.DWG Number, DWGS.DWG Title, DWGS.DWG Rev Number, DWGS.Issued, DWGS.Date EnteredThe data types of all fields are Text Fie

Introduction This article gives an idea as how to use Crystal report in .Net Windows Application with parametrized queries and Oracle as Database using dataset.I had searched on internet for articles related to Crystal Report with parametrized query with Oracle,but I was unable to find any good article on this topic.So I am posting my article on this topic. There are three main points in this a

SSRS Professionals Client of Infovision Technical Services Quick Apply Customised Apply Experience: 3 - 8 Years Location: Ahmedabad, Gandhinagar, Mumbai, Mumbai Suburbs Education: UG - Any Graduate... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Quieres aprender sobre SQL Injection? Cuales son las tecnicas que utilizan los hackers? Como me puedo proteger?. Estoy organizando un curso en linea sobre SQL Injection. Si estas interesado deja un comentario en este post, publicare mas información en breve.... Update: Si deseas colocarte en la lista de espera para la proxima fecha de este curso enviame un correo a cursos @ hectorminaya.com

Pemprograman C, Visual Basic, Java, Delphi dan lainnya merupakan pemprograman impetarive, yang berbentuk instruksi – instruksi inti. Sedangkan SQL merupakan bahasa pemprograman declarative, yang lebih berbentuk kalimat atau pernyataan. Dalam pengembangannya, SQL terbagi – bagi lagi dalam berbagai extension sehingga melahirkan berbagai sebutan seperti SQL/PSM (Persistent Stored Modules) yang me

Esto es noticia vieja ya, pero es algo que me preguntan mucho, me preguntan donde pueden bajar el SP2 de SQL Server 2005. Lo pueden encontrar en: Post relacionado: -server-2005-service-pack-2.aspx

Please send your profiles to saikrishna.chiranjeevi@droisys.com   We have a Client hot requirement in Ft. Worth, TX if you have any consultants for below requirement, Please Send the resumes/Rate and contact details. I really appreciate for your time and help   Role:  SQL/Access Developer with Health Care experience  Location: Ft. Worth, TX Duration: 12 MONTHS   &n

The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible for that Whether there were any plan changes for a batch during the time when the [...]

Les lectures se suivent mais ne se ressemblent pas... après ma dernière critique sur Harnessing Hibernate (O'Reilly), j'ai tenté un livre sur la Business Intelligence (BI) appliquée, avec les produits Microsoft (SQL Server, SSIS, SSAS, SSRS). Un livre Dunod (j'avais notamment apprécié la collection sur la gouvernance IT, l'urbanisation, le BPM), que j'ai vraiment aimé. Une partie rappelle l

SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to keep history of month. USE msdb GO DECLARE [...]

sqlmap es una herramienta desarrollada en python para realizar inyección de código sql automáticamente. Su objetivo es detectar y aprovechar las vulnerabilidades de inyección SQL en aplicaciones web. Una vez que se detecta una o más inyecciones SQL en el host de destino, el usuario puede elegir entre una variedad de opciones entre ellas, enumerar [...]

Today we will see quick script which will check integrity of all the database of SQL Server. EXEC sp_msforeachdb ‘DBCC CHECKDB(”?”)’ Above script will return you lots of messages in resultset. If there are any errors in resultset they will be displayed in red text. If everything is black text there is no error. Typical output of [...]

It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005. Download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support For connecting SQL Server 2008 to Visual Studio [...]

All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and [...]

Yesterday I received following questions on blog. Ashish Agarwal asked following question. Hi Pinal, Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query? If yes, can you please tell me the query? Thanks, Ashish Agarwal Answer to above question is NO. It is not possible to do [...]

When allowing SQL traffic to flow across an ISA server its good to know what the ports it uses are for. SQL primarily uses two ports: 1433 (the default sql port) and 1434 (the sql browser service’s port). If you specify that you want to connect to a named instance then the traffic will first be sent over port 1434 to the sql browser service. Then the sql browser service will send back the p

When allowing SQL traffic to flow across an ISA server its good to know what the ports it uses are for. SQL primarily uses two ports: 1433 (the default sql port) and 1434 (the sql browser service’s port). If you specify that you want to connect to a named instance then the traffic will first be sent over port 1434 to the sql browser service. Then the sql browser service will send back the p

I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 millions visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 millions visitors. I even missed the anniversary our blog. On November 1st 2008 SQLAuthority.com [...]

Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over. Delete mru.dat file from following location. For [...]

Utilizando GreenSQL un cortafuegos diseñado para bases de datos MySQL. Su funcionamiento se basa en un proxy que evalúa los comandos SQL antes de enviarlos a la base de datos, utilizando una matriz que acumula ordenes y bloquea comandos administrativos como: DROP, CREATE … y así evitar un ataque de “SQL injection” a una base de datos MySQL. El cortafuego GreenSQL se puede utilizar de las

I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database is dropped following error shows [...]

Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those  white papers. Engine Separation of Duties for the Application Developer - Separation of duties is an important consideration for databases and database applications. By properly defining schemas and roles, [...]

Recently I have got two desktop computers at home and both of them are very powerful machine. Machine 1 : Windows Vista SP1 with SQL Server 2008 Machine 2 : Windows 2003 with SQL Server 2005 with SP2 When I was trying to connect from SQL Server 2008 to SQL Server 2005 using Windows Authentication I was getting [...]

This newly created position involves working for one of the countries most established Funds management companies in the country who have recently opened offices overseas. Working within a very dynamic and forward thinking environment this position will give you the chance to fast track your technical and business skills whilst working within a very supportive [...]

There is a known issue with SQL Server 2005 SP2 that occurs if you have moved the system databases to another location. Specifically, the mymssqlsystemresource database. If the mymssqlsystemresource transaction log has been moved from its default location, the installer for SP2 does not recognize this. The installer places the new mymssqlsystemresource.ldf file in the same directory as the mymssq

Stored Procedures are very important and most of the business logic of my applications are always coded in Stored Procedures. Sometime it is necessary to hide the business logic from end user due to security reasons or any other reason. Keyword WITH ENCRYPTION is used to encrypt the text of the Stored Procedure. One SP [...]

If you have multiple SQL Server instances on a server, running the service pack install in ‘default gui’ mode will only apply to the default instance.  To install to all instances at the same time, you need to expand the service pack, then run from the command line with the /allinstances tag: Read More...

Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of Oracle. While discussing he suggested that he wished SQL Server should have feature where multiple variable can be declared in one statement. I requested him to not judge wonderful [...]

SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. You can use SQL*Loader to do the following:Load data across a network. This means that you can run the SQL*Loader client on a different system from the one that is running the SQL*Loader server.Load data from multi

The Discard FileAs SQL*Loader executes, it may create a file called the discard file. This file is created only when it is needed, and only if you have specified that a discard file should be enabled. The discard file contains records that were filtered out of the load because they did not match any record-selection criteria specified in the control file. The discard file therefore contains record

 Please send your profiles to saikrishna.chiranjeevi@droisys.com   We have a Client hot requirement in San Francisco, CA if you have any consultants for below requirement, Please Send the resumes/Rate and contact details. I really appreciate for your time and help   Role: SQL Developer Location: San Francisco, CA Duration: 6 months **Include your consultants CONTACT INFO or

The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities. Feature Bullet Summary: The fo

The CTP version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer Standard Workgroup For a summary list of What’s new in SQL Server 2005 SP3 CTP, review the What’s New document. These packages have been made available for general testing [...]

---------- Forwarded message ---------- From: DBADB2sql@surlin.com <DBADB2sql@surlin.com> Date: Oct 25, 2008 1:46 PM Subject: Huge - DBA- DB2 Unix or linux with DB2 RDBMS architecture 4+ yrs... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Microsoft SQL Server 2008 A Beginner's GuidePDF | 745 Pages | 4 MBGet Started on Microsoft SQL Server 2008 in No TimeLearn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk yo

As a Developer, you would come across a scenario where you would want SQL Server to return DateTime in a particular format to the front end. You can use SQL Server’s built in function GETDATE() to return the current DateTime. But if you need a universal date/time, use the built-in function GETUTCDATE(). SQL Server provides [...]

Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management tools. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores. SQL Server 2008 Express with

SQL Fundamentals (3rd Edition) by John J. Patrick Publisher: Prentice Hall PTR; 3rd edition (September 12, 2008) Language: English ISBN-10: 0137126026 ISBN-13: 978-0137126026 SQL for the Real World Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations on running SQL Server in [...]

Bu makalemizde sql veritabanı bağlantısının açık olup olmadığını yani veritabanına bağlantımızı kontrol edeceğiz. Ayrıca;using System.Data.Sql;using System.Data.SqlClient;ekleyin.Formunuza 1 adet Button ve DataGridView nesnesi ekleyin.Aşağıdaki şekilleri inceleyin.Şekil 1Şekil 2private void button1_Click(object sender, EventArgs e) {System.Data.SqlClient.SqlConne

Bu makalede sql veritabanımızdaki bir kayıtı, tablomuzdaki sütundaki alanlardaki kriterlere göre aratarak bulunan kayıtı, dataGridView nesnesinde göstereceğiz. Aşağıdaki şekilleri inceleyin.Formunuza 1 adet TextBox,Combobox, Button ve DataGridView nesnesi ekleyin.Combobox a girilen tablodaki sütun alanlarında arama yapıyoruz.Şekil 1Şekil 2Şekil 3using System.Data.Sql;using

 Please send your profiles to saikrishna.chiranjeevi@droisys.com   We have a Client hot requirement in San Francisco , CA if you have any consultants for below requirement, Please Send the resumes/Rate and contact details. I really appreciate for your time and help   Role: SQL Specialist Location: San Francisco , CA Duration: 6 Months Interview: F2F ONLY **Include your c

I have seen developer confused many times when they receive following error message. Msg 325, Level 15, State 1, Line 7 Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel. The reason for this error is [...]

This article is inspired from two sources. 1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT 2) Discussion with SQL Server MVP - Jacob Sebastian - SQLAuthority News - Author Visit - SQL Hour at Patni Computer Systems I usually summarize my article at the end, [...]

When the database load increase rapidly it is even hard to log in Enterprise Manager (EM) to see what is the actual cause by seeing top activity or generating AWR report. Most of the time bad SQl is behind such problem. Here is a script which give you Top 20 (sort by elapsed time) SQL quer run on last 30 minutesSELECT x.sql_id,x.sql_text,x.users,x.executions,x.disk_reads,x.buffer_gets,x.cpu_time

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation is the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you'll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching me

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are not possible by [...]

You use ST05, Trace Request, to do a SQL trace. When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another session and turn the trace on. After, or when, the SQL is finished, you can turn the trace off. Then click on List Trace to see the details. This is the way to control the traces. If you just turn the trace on and then execut

1. To see current Oracle Version : SQL> SELECT version FROM v$instance;VERSION-----------------10.2.0.1.02.

A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have discussed two different methods of getting datepart from datetime. Method 1: SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) Method 2: SELECT CONVERT(VARCHAR(10),GETDATE(),111) I have summarized my post suggesting that either method works fine and I prefer to [...]

Are you interested in Sql Servers?  No?  Well, let me start by saying their a Microsoft product, very reliable and efficient as well as being cost effective.  The highest number of searches on Google for SQL Servers comes from India which is surprising, but then again they have a huge number of programmers so that might [...]