: Unanswered Threads

Intrebare

neo — Fri, 15 Jan 2016 13:45:19 GMT

Salut,

in sys.sysprocesses in SQL 2005 Std. Ed. procesul cu program name-ul "SQLAgent - Alert Engine" este normal sa apara? daca nu care sunt cauzele cele mai probabile ? Eventual modalitati de debug cauze?

Merci.

Ce link trebuie sa fac download pentru a invata SQL?

Anghel Florin — Fri, 17 Jul 2015 19:28:42 GMT

Salut!

Este putin jenant pentru mine cand pun aceasta intrebare,pun o intrebare de amator.
Bineinteles,SQL apartine de Microsoft.
Eu am tastat pe Google o intrebare despre Download SQL si mi-a aparut doua variante de SQL:SQL si Oracle.
Aceasta este linkul-https://www.google.ro/#q=sql+download

Multumesc anticipat!

PASS Business Analytics Conference 2015

xmldeveloper — Wed, 04 Mar 2015 10:30:18 GMT

The PASS BA Conference brings together analysts and IT pros from the world of BI and analytics to connect, share experiences, and learn more about the power of data to transform business.

We have a $150 discount code for you: USNC06 .

The site of the event is: http://passbaconference.com)

rowversion

neo — Mon, 10 Nov 2014 11:53:47 GMT

Salut,

Stiti vre-o metoda de insert intr-o coloana de tip timestamp pentru anumite valori prestabilite in SQL 2008 R2 - altfel decat cu 'default'?

Valorile vreau sa le copii dintr-un alt tabel (mentionez ca in tabelul destinatie acestea nu mai exista - din punct de vedere al duplicatelor).

Mulumesc.

Query

maneaflorin@hotmail.com — Wed, 23 Jul 2014 11:58:07 GMT

Salut,

Am o tabela de analize medicale (id, cod, denumire), una de parametri analize (id, id_analiza, denumire) si una de rezultate (id,id_param, rezultat, codpacient).

Cum fac sa obtin toate analizele care nu au niciun parametru necompletat?

Daca zic

Select A.analiza, R.codpacient from Rezultate R
Inner Join Parametri P On P.id=R.id_param
Inner Join Analize A On P.id_analiza=A.id
where R.rezultat is null

obtin toate valorile necompletate. O analiza poate avea mai multi parametri si ma intereseaza doar analizele care nu au niciun parametru completat.

Exemplu:

Analiza          Parametru      Rezultat
Glucoza          /2h               null
Examen de urina     epitelii         null
Examen de urina     celule             frecvente

Ma intereseaza sa obtin doar Glucoza, nu si Examenul de urina.

Se poate face din Join sau aplic un cursor si parcurg toate inregistrarile?
Multumesc,
Florin

SQL Server DBA

hoinar — Thu, 19 Jun 2014 10:31:08 GMT

Salutare,

Echipa mea are nevoie de un coleg DBA, skill level - incepator/mediu (2-3 ani de experienta in lucrul cu bazele de date ar fi perfect). Nu o sa va spamez cu toate datele, ca gasiti anunturi generale despre pozitii de DBA oriunde.

Tot ce imi doresc e ca persoanele interesate sa aiba un minim de experienta si sa fie dornice sa invete.

Firma e in Bucuresti, se cheama Eminus Software (http://www.eminussoftware.com/About), si lucreaza la o platforma de licitatii de masini SH pt piata din UK (si colaboreaza cu o firma din UK).
Stack-ul de tehnologii e reprezentat de .NET si SQL Server (dar nu e limitat la asta).

Adresa mea (pentru orice fel de intrebari neoficiale) e nospam_hoinar_nospam@gmail.com.

Adresa de email oficiala - nospam_careers_nospam@eminus-software.com.

Va multumesc,
Marian

The initial snapshot for publication 'PublicationName' is not yet available

neo — Thu, 15 May 2014 06:30:08 GMT

Salut,

Am o replicare Tranzactionala (Push) 45 de publicatii (SQL Server 2005 Standard Edition x86) - geografic distribuite si un singur subscriber (SQL Server 2005 EnterpriseEdition x64)

Care este motivul pentru care intr-o replicare tranzactionala, dupa ce un link cade si apoi se ridica relativ repede, agentul de replicare genereaza urmatoarea eroare: 'The initial snapshot for publication 'PublicationName' is not yet available'.

PS:
1. Publicatiile au deja setarea 'Subscription never expire but they can be deactivated until they are reinitialized'
2. Profilul de agent are setarea 'Continue on data consistentcy errors'
3. Max Text Replication Size este acelasi pentru Publicatii cat si pentru Subscriber (131072)
4. Publicatiile au 2 GB, iar subscriberul are 20 GB de memorie

Reinitializarea nu este o solutie care sa se aplice pe modelul de Business.

Multumesc.

PASS BA Conference - discount code

xmldeveloper — Wed, 15 Jan 2014 09:03:20 GMT

The PASS BA Conference brings together analysts and IT pros from the world of BI and analytics to connect, share experiences, and learn more about the power of data to transform business.

We have a $150 discount code for you: BA4M7A.

The site of the event is: http://www.sqlpass.org/bac/2014/Home.aspx

SQL Developer for database performance, in Bucharest

Laura07 — Fri, 25 Oct 2013 14:31:40 GMT

v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

One of our client’s major projects, BitterStrawberry, is focused on optimizing and maximizing the mobile traffic efficiency. They integrate the best-performing affiliate campaigns with publishers who have large volumes of traffic which is not optimized.

At the moment they are searching for 2 competent and innovative developers with experience in high traffic solutions development, to develop and maintain this existing solution. The main focus is on mining, processing and illustrating statistical and salary information, developing the user and backend GUIs and implementing server to server payment APIs.

You will work in a strong team, for one of the big players in the international advertising and affiliate market. The daily tasks will consist of evolving and maintaining the existing system and implementing new features.

This involves:

Maintaining and developing interface for the rapidly growing database;
Improve the backend GUI using PHP (server) and JavaScript (client);
Planning and implementing server to server interfaces together with their partners;
Maintain and develop unit and integration tests;
Working with rapid release schedules;

Requirements

Very good knowledge/experience on relational databases (SQL, database performance, big data);
Good knowledge in web development using PHP;
Knowledge in client site web development using JavaScript;
Basic knowledge in programming with C;
Basic knowledge in HTML/CSS;
Basic knowledge of Linux server systems (Apache, Varnish, Chroot, File Permissions, MariaDB, Redis, load balancing, high availability, DNS, shell scripting);
Very good command of English (German is a plus).

Benefits

· Very competitive salary package, according to your knowledge and experience;

· Challenging and motivating environment where ideas are listened to and promoted;

· An opportunity for career development as part of a dynamic, young and professional team

· Modern, fun and aesthetically pleasing working environment;

Feel free to send your CV at laura.filimon@brainspotting.ro

Normal 0 false false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-ansi-language:EN-GB; mso-fareast-language:EN-GB;}

sql 2008 changetable

crestinul — Wed, 09 Oct 2013 12:27:57 GMT

Buna
A folosit cineva feature-ul asta de sql 2008 in consta,ce performante are?
Multumesc

Senior Database Developer - Bucharest

Nicoleta Mitu — Tue, 02 Apr 2013 07:57:47 GMT

Due to the continuous growth of the business, we are looking for a Senior Database Developer to join our team.

Responsibilities:

•Execute reports and statistics through database queries
•Develop, maintain and optimize SQL queries scripts;
•Help maintain existing IT applications;
•Work closely with IT in other countries to coordinate development and maintenance of applications and to achieve an efficient connection with applications, database and networks;
•Communicate with external providers and follow projects;
•Provide support in creating functional and technical specifications and development timelines;
•Assist in the design of database models;
•Assisting in the planning and scheduling of database and development projects;
•Assess, transform, clean, match and store data in database(s)
Requirements:

•University Degree in the IT field;
•Experience in working with large Databases;
•Excellent knowledge of Microsoft SQL Server;
•Comprehensive knowledge of T-SQL;
•Experience with SQL Reporting Services;
•Skills in designing and implementing data warehouse services;
•Knowledge of MS Excel, MS Access
•Analysis skills and methodologies knowledge;
•Very Good English knowledge

The company offers:

A competitive working environment with international exposure, great colleagues and excellent working place!

Please send your CV at nmitu@icap.ro

All information received will be treated with strict confidentiality

IT Project Manager, Brasov

MihaiBejenariu — Thu, 13 Dec 2012 10:35:21 GMT

Salutare,

Caut un project manager care sa gestioneze o echipa de 7-8 programatori pe un proiect care foloseste tehnologii Microsoft, un profil 70% manager, 30% tehnic, ideal cu experienta solida SQL Server. Pentru mai multe detalii, va rog sa consultati linkul de mai jos:

http://jobs.pentalog.ro/project-manager-brasov/

Cine este interesat imi poate trimite un CV la adresa mbejenariu(at)pentalog.fr.

Multumesc,

Mihai

ROSQL Newsletter 11-12-2012

xmldeveloper — Tue, 11 Dec 2012 18:24:11 GMT

RoSQL Newsletter 11-12-2012
============================================================
English Version follows:

In acest numar:

1. SQL Server Community Event

Romanian SQL Server User Group va invita la o noua intalnire a comunitatii pe 17 Decembrie 2012 incepand cu ora 18:00 la sediul Microsoft Romania.

Pentru inregistrare folositi urmatoarea adresa: http://sqlserver.ro/r.ashx?U

Agenda intalnirii
18:00 - 19:00 Noutati in lumea SQL Server - Cristian Lefter, SQL Server MVP, sqlserver.ro
19:00 - 20:00 Discutie libera moderata pe temele: comunitati, baze de date, tendinte - Cristian Lefter, SQL Server MVP, sqlserver.ro

Va asteptam!
Pentru sugestii sau comentarii privind buletinul comunitatii RoSQL folositi forumul dedicat http://sqlserver.ro sau adresa de email nospam_CristianLefter@hotmail.com

Puteti sa va dezabonati la acest buletin folosind adresa:
http://sqlserver.ro/CS/user/EditProfile.aspx?ReturnUrl=/cs/Default.aspx

============================================================
English Version

In this issue:
1. SQL Server Community Event

ROSQL invites you to a new meeting dedicated to SQL Server, on 17th of December 2012, starting at 18:00, at Microsoft Romania.

For registration please use the following URL: http://sqlserver.ro/r.ashx?U

Agenda

18:00 - 19:00 News in the SQL Server World - Cristian Lefter, SQL Server MVP, sqlserver.ro
19:00 - 20:00 Open Discussion on themes such as community, database servers, industry tendencies - Cristian Lefter, SQL Server MVP, sqlserver.ro

For suggestions regarding the RoSQL newsletter please use the forum http://sqlserver.ro or the email address nospam_CristianLefter@hotmail.com
You can unsubscribe using the next link:
http://sqlserver.ro/CS/user/EditProfile.aspx?ReturnUrl=/cs/Default.aspx

Microsoft BI/Data Warehouse Senior Developer @ Ubisoft Romania

xmldeveloper — Thu, 15 Nov 2012 12:31:31 GMT

Microsoft BI/Data Warehouse Senior Developer

Job type: Full-time
Experience: Senior-level (5 years +)
Location: BUCURESTI
Job Category: Engineering, Software/Technology

About our company:
Come join our world:
A place where creativity and innovation are the driving force
A place as varied in its destinations as in the people who travel there...
A place where the game barrier can finally be broken!

Ubisoft is a leading producer, publisher and distributor of interactive entertainment products worldwide and has grown considerably through a strong and diversified line-up of products and partnerships. Ubisoft has offices in 23 countries and sales in more than 50 countries around the globe. It is committed to delivering high-quality, cutting-edge video game titles to the consumers.

Ubisoft Romania is the first Ubisoft production studio outside France. The Romanian adventure which began 17 years ago has turn into an exciting success story.
Come and join our team of over more than 750 professionals and help us create highly appreciated video games.

Job description:
The IT Department of Ubisoft, is currently seeking a full-time BI senior Developer specialized in designing and developing Data Warehouse solutions. The candidate should be familiar with the Microsoft BI Stack.

Key responsibilities:

DW schema/models/objects/systems design, implementation and optimization
ETL framework design, implementation and management.
Analyze performance bottlenecks and recommend tuning optimizations
Participate in architectural and model decisions during the design and build phases of new projects.
Work closely with application developers and administrators to streamline data flows between internal/external systems and the data warehouse.
Good understanding of user requirements and functional specifications.
Ensure that formal documentation is produced for all development projects.

Experience:
Mandatory:

University diploma in Information Technology or Computer Sciences or equivalent work experience on BI.
Minimum 5 years of experience on implementing ETL for Data Warehouse and Business Intelligence solutions.
Good understanding of general data warehousing concepts.
Full lifecycle experience surrounding large scale DW/BI solutions having Microsoft SQL Server as backend.
Developing ETL processes with Data from various sources: SQL Server, Oracle, Online content etc.
Strong expertise with SQL Server programming objects such as Stored Procedures, Views and Function.
Good communications skills in English (spoken and written).

Nice to have:

Experience on Business Analysis and/or Project Management.
Experience with SAP Business Objects.
Exposure to Microsoft SQL Server 2012 is a plus.
MDM (Master Data Management) knowledge is a plus.
Good communications skills in French (spoken and written).

Other requirements:

Availability to travel abroad
Analytical skills
Responsible and accountable for his/her actions
Persevering, autonomous
Eagerness to learn
Creative / innovative
Good communication skills
Quality and result oriented
Easily adaptable to changes
Good team player, able to accept constructive criticism and give feedback
Facilitates knowledge transfer and mentors other team members.

We offer:

Professional working environment
Career opportunities
Motivating salary
Project bonuses
Meal tickets
Medical services
Gym and relaxing area

If you are interested please send me an email @

Informatica Senior Developer @ Ubisoft Romania

xmldeveloper — Thu, 15 Nov 2012 12:18:19 GMT

Informatica Developer

Job type: Full-time
Experience: Senior-level (5 years +)
Location: BUCURESTI
Job Category: Engineering, Software/Technology

About our company:

Come join our world:
A place where creativity and innovation are the driving force
A place as varied in its destinations as in the people who travel there...
A place where the game barrier can finally be broken!
Ubisoft is a leading producer, publisher and distributor of interactive entertainment products worldwide and has grown considerably through a strong and diversified line-up of products and partnerships. Ubisoft has offices in 23 countries and sales in more than 50 countries around the globe. It is committed to delivering high-quality, cutting-edge video game titles to the consumers.
Ubisoft Romania is the first Ubisoft production studio outside France. The Romanian adventure which began 17 years ago has turn into an exciting success story.
Come and join our team of over more than 750 professionals and help us create highly appreciated video games.

Job description: The IT Department of Ubisoft, is currently seeking a full-time Informatica Developer with a strong Data Warehouse background. Key responsibilities:

Responsible for designing ETL solution to support business requirements by using Informatica.
The ideal candidate would be knowledgeable on the following tasks:

Create ETL flows that respect the standards and best practices, with multiple data source and targets types (RDBMS, flat files, …)
Realize complex transformations by choosing the most adapted one among all the possibilities offered by Informatica
Optimize the flows by taking advantage of both Database Engine and Informatica capabilities
Have a good understanding of Informatica architecture and tune the configuration to reach a high level of performance while managing the concurrency
Build and maintain the monitoring features to raise any data quality alerts

Participate in architectural and model decisions during the design and build phases of new projects.
Work closely with application developers and administrators to streamline data flows between internal/external systems and the data warehouse.
Good understanding of user requirements and functional specifications.
Ensure that formal documentation is produced for all development projects.
Performance tuning, monitoring and troubleshooting.

Experience:

Mandatory:

University diploma in Information Technology or Computer Sciences or equivalent work experience on BI.
More than 5 years of experience on BI developments.
Minimum of 3 years of experience with Informatica.
Knowledgeable in Informatica architecture, design and development.
Experience building both traditional ETL scenarios in Informatica as well as non-traditional integration scenarios.
Working knowledge of one or more BI suite (Business Objects, Cognos, MicroStrategy, ProClarity etc.).
Good understanding of data warehousing concepts; knowledgeable of data warehouse design, automation and implementation at an Enterprise level.
Experience working with VLDBs (Very Large Databases) is a plus.
Good communications skills in English (spoken and written).

Nice to have:

Experience with Microsoft SQL Server
Experience on Business Analysis and/or Project Management.
Good communications skills in French (spoken and written).

Other requirements:

Availability to travel abroad
Analytical skills
Responsible and accountable for his/her actions
Persevering, autonomous
Eagerness to learn
Creative / innovative
Good communication skills
Quality and result oriented
Easily adaptable to changes
Good team player, able to accept constructive criticism and give feedback
Facilitates knowledge transfer and mentors other team members.

We offer:

Professional working environment
Career opportunities
Motivating salary
Project bonuses
Meal tickets
Medical services
Gym and relaxing area

If you are interested please send me an email @

BI Support Analyst – 6 Months Internship @ Ubisoft Romania

xmldeveloper — Thu, 15 Nov 2012 10:46:30 GMT

BI Support Analyst – 6 Months Internship
The IT Support team inside Ubisoft has opened a 6 months internship position of BI Support Analyst – to provide functional and basic technical support for the Business Intelligence solutions (Corporate Data Warehouse, Business Objects, Hyperion Financial Management and Hyperion Planning).
You will have the opportunity to learn BI tools and technology and develop your analytical abilities.
Your tasks Under the responsibility of the Support Team Manager your role as BI Support Analyst is to:

Acquire knowledge about the BI tools
Analyze and understand the customer's needs and the encountered problems/ bugs;
Perform functional analysis on the assigned tickets and handle the communication with the users;
Collaborate closely with the technical analysts in order to identify the best solution for the bug corrections/developments;
Create/Ensure a good understanding of functional specifications;
Perform system testing and different system set-ups related to support activity;
Interrogate SQL databases of Data Warehouse and its source systems in order to troubleshoot issues and identify/ test solutions;
Perform regular system monitoring and data clean-up activities;
Stay updated with the IT support best practices and procedures and suggest improvements;
Contribute to the creation and maintenance of end-user documentation.

Your profile
Essential skills

Last year student or graduate of IT studies;
Oracle or MS SQL knowledge;
Knowledge of Finance and Accounting is a plus;
Good English skills, French is a plus;
Customer facing skills, good communication skills

Desirable personal skills:

Innovative;
Able to assimilate business changes and incorporate them in the IT systems;
Sense of humor, positive approach and team-work orientation;
Enthusiasms for learning new technologies;
Good team player, able to accept constructive criticism and give feedback

We offer:
We have salaries to motivate you, bonuses for your performances, medical services to keep you safe and sound, meal tickets to use them wherever you want and free access to relaxing and fitness room.
But most of all, we guarantee you’ll enjoy our atmosphere and working environment.
Ubisoft is a leading producer, publisher and distributor of interactive entertainment products worldwide. With more than 6700 employees, and 26 studios in 18 countries, Ubisoft has the second largest internal creation force in the world.
Ubisoft Romania is the first Ubisoft production studio outside France. The Romanian adventure, which began in 1992, has turned into an exciting success story where Production, Test and Information Technology Department are its driving force.
Come and join our team of over 900 professionals and help us create highly appreciated video games!

If you are interested please send me an email @

Business Intelligence Support Analyst @ Ubisoft Romania

xmldeveloper — Thu, 15 Nov 2012 10:34:06 GMT

Business Intelligence Support Analyst
The IT Department of Ubisoft is currently seeking a full-time Business Intelligence Support Analyst with middle-level experience, to ensure 2nd level support for Ubisoft's Business Intelligence applications.
Your tasks

Works a queue of tickets (incidents, problems, requests, changes) and provides resolutions within internally defined SLAs, with a focus on long-term solutions, on BI applications (Data Warehouse, OLAP Cubes, Business Objects, Hyperion Financial Management; Hyperion Planning)
Provides status updates and manages customer expectations throughout the lifecycle of the incident/ problem/ request/ change
Demonstrates a sound knowledge across multiple business intelligence products.
Demonstrates ability to see “the big picture” and understand the data flows between internal/external systems and the data warehouse
Collaborates closely with level 1 Front Desk analysts to identify, document and transfer recurrent ticket categories
Collaborates closely with the level 3 technical support analysts and the project teams, in order to identify the best solution for the identified system errors/developments
Provides trainings for the key and end-users
Contributes to the creation and maintenance of end-user documentation
Effectively utilizes support processes and tools (i.e.: self service interface, ticketing tool, internal knowledge base etc.);
Stays updated with the support practices and procedures and suggests improvements
Actively contributes to internal knowledge management through content creation and maintenance
Participates to projects (new functionalities, enhancements etc) – functional analysis, design, system testing, UATs - as needed

Your profile:
Essential skills:

University graduate
Work experience of at least three years within the IT department, with background in the support/ operations or development of IT products
Querying Oracle or MS-SQL databases knowledge
PC skills: Windows, Office (Outlook, Word, Excel) – average level
Good written and oral knowledge of English, French is a plus

Desirable skills:

Knowledge of business terms and processes in areas like Cost Control, Consolidation, Finance and Accounting, Sales, Marketing
Experience with ERP products
Experience with other Business Intelligence products

ROSQL Newsletter 27-06-2011

xmldeveloper — Mon, 27 Jun 2011 09:45:01 GMT

RoSQL Newsletter 27-06-2011
============================================================
English Version follows:

In acest numar:

1. SQL Server Community Events

Romanian SQL Server User Group va invita la o noua intalnire a comunitatii pe 30 Iunie 2011 incepand cu ora 17:30 la sediul Microsoft Romania.

Agenda intalnirii

17:30 - 17:40 Introduction
17:40 - 18:10 New in Microsoft Certifications Cristian Lefter, SQL Server MVP, sqlserver.ro
18:10 - 18:50 SQL Server Code-named "Denali" - Overview Cristian Lefter, SQL Server MVP, sqlserver.ro
18:50 - 19:00 Break
19:00 - 19:50 Managementul unui proiect pentru implementarea unei aplicatii de Business Intelligence Angela Dobrea - Intelprof
19:50 - 20:00 Break
20:00 - 21:00 Transforming the Datacenter Through Private Cloud Computing Sebastian Vijeu, IT Evangelist, Microsoft

Va asteptam!

Pentru sugestii sau comentarii privind buletinul comunitatii RoSQL folositi forumul dedicat http://sqlserver.ro sau adresa de email nospam_CristianLefter@hotmail.com

Puteti sa va dezabonati la acest buletin folosind adresa:
http://sqlserver.ro/CS/user/EditProfile.aspx?ReturnUrl=/cs/Default.aspx

============================================================
English Version

In this issue:
1. SQL Server Community Events

ROSQL invites you to a new meeting dedicated to SQL Server, on 30 June 2011, starting at 17:30, at Microsoft Romania.

Agenda

For suggestions regarding the RoSQL newsletter please use the forum http://sqlserver.ro or the email address nospam_CristianLefter@hotmail.com

You can unsubscribe using the next link:
http://sqlserver.ro/CS/user/EditProfile.aspx?ReturnUrl=/cs/Default.aspx

Free SQL Server Tools

B_gd_n[ ]Sahlean — Mon, 29 Nov 2010 23:59:56 GMT

Best Free Tool

Editors' Best

Gold: SP_WhoIsActive • Adam Machanic • sqlblog.com

Silver: SSMS Tools Pack 1.9 • Mladen Prajdic • www.ssmstoolspack.com

Bronze: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com

Why It Won: SP_WhoIsActive is mentioned in the SQL Server community as the epitome of a fantastic free tool. Adam Machanic updates the tool frequently, it’s well explained and supported by great internal documentation, and its code is considered to be the best of the best.

“To say I like SP_WhoIsActive is an understatement,” SQL Server Magazine author Kevin Kline said in “SP_WhoIsActive” (June 2010, InstantDoc ID 125107). “This is probably the most useful and effective stored procedure I’ve ever encountered for activity monitoring. The purpose of the SP_WhoIsActive stored procedure is to give DBAs and developers as much performance and workload data about SQL Server’s internal workings as possible, while retaining both flexibility and security.”

Community Choice

Gold: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com

Silver: SQL check 2.6 • Idera • www.idera.com

Bronze: Tableau Public • Tableau Software • www.tableausoftware.com

"Ola Hallengren's tools are justly famous."

Other hot vote-getters in this year's survey …

* Quest Software's Toad Data Modeler Freeware Edition
* Red Gate Software's SQLSearch 1.0
* LessThanDot's SQLCop

Sursa: http://www.sqlmag.com/article/sql-server/2010-SQL-Server-Magazine-Editors-Best-and-Community-Choice-Awards/4.aspx

+

[1] SQL Sentry Plan Explorer
[2] Toad for SQL Server FREEWARE

SQL Tutorial For Beginners

chloegreen — Thu, 18 Nov 2010 13:08:08 GMT

This SQL tutorial is designed just to serve as an introduction to the things you can do with SQL (i.e. add data, remove data, modify data and query your data). It is not designed to be a complete guide to the language and its syntax as that would take a whole book! The first thing we need to do in this sql tutorial is to define SQL. SQL (pronounced either seequel or esscuell) is the language used to communicate with the database and to retrieve/update/delete data stored in the database as well as maintaining the data structures (tables, indexes, constraints etc). The name SQL is an acronym for Structured Query Language. It is a non-procedural language designed to allow end-users to be able to retrieve or modify their data (and data structures) in a database without having to worry about how this is achieved. In other words it concentrates on what is being done rather than how to it is done. As already hinted at, there are two types of SQL statements.

DML (data manipulation language) for querying and updating data
DDL (data definition language) which is used for the maintenance of the data structures.

This introductory SQL tutorial will just cover data manipulation, as this is what SQL is used for most of the time.The most common SQL statements are database queries. The simplest form of the syntax for queries is

SELECT columns FROM my_table;

Where columns represents the list of data items in the table that you are interested in with each column separated from the next by a comma. If all columns are required this can be abbreviated with "*". Therefore a very simple example would be:- SELECT * FROM customers;

This query would retrieve every attribute of every customer whose details are held in the customers table in our mythical database. The rows selected from the table can be restricted with an optional where clause which has the syntax WHERE conditions.

The conditions are a comma separated list of conditions that a record must meet in order to be returned to the user as part of the results. Each condition can be defined as value_or_column operator value_or_column where operator is one of =,<,>,or <> and value or column is either a value (e.g.. 1 or "1") or the name of a column in the table.

Therefore the simplest query would be of the form SELECT customer_name FROM customers;

Where customers is the name of the table and customer_name is a column in the table. This would select the customer_name column from every row in the table called customers.

If we only wanted some of the names we could restrict the names selected with a where clause, for example:

SELECT customer_name FROM customers WHERE customer_name > 'Jones';

would only retrieve the department names that would be after Jones alphabetically (e.g. Smith, Weston, Swarbrick, Zachary, King, Loundes, Munden etc.).

Simple Queries To Retrieve Data From The Database

Having looked at the basic syntax and a couple of simple examples so far in this sql tutorial, let's move on to build up some more complicated and more interesting queries.

We've already seen that the simplest query is of the form: SELECT * FROM the_table; where the_table is any table in our database (actually the_table could be a view or even a sub query but to keep this tutorial simple let's pretend it can only be a table). This query would return all the columns in all rows from whatever table we specify.

For example, let us suppose we're a bookseller and in our database we have a table called technical_books which has the following columns: book_id, title, format, price, author

Let us further suppose that we have the details of over 10,000 technical books held in our table, so running the query SELECT * FROM technical_books; would return all the details for all 10000 books, but we're only interested in one book - "Learn SQL From Scratch In 40 Minutes Flat" !

So, how do we restrict our query to just return the details of that one book? Actually this is very straightforward. All we need to do is to add some conditions to our query, like so:-

SELECT * FROM technical_books WHERE title = 'Learn SQL From Scratch In 40 Minutes Flat'

This query will now return the details for all courses entitled 'Learn SQL From Scratch In 40 Minutes Flat' (there may be more than one edition or there may be more than one format). To refine the query further we would add more conditions.

For example, let's assume that the format of the book 'Learn SQL From Scratch In 40 Minutes Flat' that we are interested in is "Ebook". In which case we can just add that condition to our query like so:

SELECT * FROM technical_books

WHERE title = 'Learn SQL From Scratch in 40 Minutes Flat'

AND format = 'Ebook';

Assuming that there is only one ebook with this title in our database, this query would return just one row. This shows how to restrict the number of rows returned by our queries to exactly the ones we're interested in by adding as many conditions to the query (the where clause to be precise) as are needed. in this case there are two conditions combined by "and". This means both conditions must be met by a particular record (row) in our table, for that record to be in the results.

To make a condition optional we just need to replace the "and" with an "or". For example:

SELECT * FROM technical_books

WHERE title = 'Learn SQL From Scratch in 40 Minutes Flat'

OR format = 'Ebook';

would retrieve details of all the ebooks we have in our table as well as the details of all books entitled 'Learn SQL From Scratch in 40 Minutes Flat'.

How To Modify Data In The Database

Up 'til now we've learnt how to construct queries to retrieve information from our database and this is what 90% of our time is spent on with any application and is fundamental to our understanding of SQL therefore. Queries are also often used in update, insert and delete statements as we'll see later, so they're doubly important.

Now let's learn how to update data in the database. There are three commands to do this: update, delete and insert. The basic syntax of each of these is as follows:

UPDATE my_table SET col1 = val1, col2 = val2,... colz = valz WHERE conditions;
DELETE FROM my_table WHERE conditions;
INSERT INTO my_table (col1, col2... colZ) VALUES (val1,val2... valz);

where my_table is the table name, col1, col2, colz are the column names and conditions determine which rows are deleted or updated in the same way as they determine rows that are retrieved in a select statement.

The insert statement is more complicated so it is best illustrated by an example. We'll re-use our table called technical_books from the previous examples. To insert data into the table we would write something like this:

INSERT INTO technical_books(book_id, title, format, price, author)

VALUES (1,'Learn SQL From Scratch in 40 Minutes Flat', 'Ebook',free,'asktheoracle.net');

Furthermore we would need one statement like that for each book the details of which we wished to add to the database.

There are a couple of general points that need to be mentioned before we continue. First, in the insert statement, if we don't specify the column names, Oracle assumes that all columns are being inserted and will generate an error if a value is not supplied for every column in the table. For example if we defined a table course with the columns course_id, name, tutor, and price then the statement:

INSERT INTO course VALUES (1,'SQL Tutorial');

would fail as we only supplied 2 values instead of 4. If we only want to insert 2 columns then we have to specify which columns we are providing values for.

By specifying the names of the columns we can also list them in any order we choose, otherwise they have to be inserted in the same order as they are in the table. For example, using the table course as defined earlier, we can insert one rows with the following statement:

INSERT INTO course VALUES (1,'SQL Tutorial','ebook',0,'asktheoracle.net');

This supplies a value for every column and in the order in which they exist in the table. This statement: however:

INSERT INTO course(title,format) VALUES ('ebook','sql tutorial');

supplies values for just 2 of the columns and in a different order to the order in the table. This statement also shows that as long as the data type is correct, Oracle has no way of validating whether our command makes sense (foreign-key and other types of constraints can be used for this but discussion of of those is outside the scope of this introductory tutorial). In this case we have specified the title as "ebook" and the format as "sql tutorial" which is unlikely to be what we want.

We also need to be aware that if the "where" clause is not added to the update and delete statements then these statements will affect every row in the table. For example if we run the following statement in our hr database

UPDATE employees SET salary = salary*1.1;

we'll give every employee a 10% pay rise. That might be popular with the rest of the organisation but the finance director is unlikely to be impressed!

This statement:

DELETE FROM employees;

would remove the details of every employee from the database which is unlikely to go down well with the HR manager, so we would nearly always specify the conditions for the update or delete by using the "where" clause. If no rows meet the conditions in the "where" clause, then obviously no changes are made by the update or delete statements.

Multi-Table Queries

We still have plenty of ground to cover so let's look at the alternative syntax of the insert statement which uses what's known as a sub-query.

INSERT INTO my_table1 (col1,col2,...col) SELECT col1,col2,...colZ FROM my_table2 WHERE conditions;

In the above example we could again leave out the names of the columns that we are providing values for but they do need to be specified in the sub-query or we need to use "*" to indicate all columns. This alternative syntax has the advantage that it can be used to insert multiple rows in one statement. The number of rows that would be inserted is limited only by the number of rows that meet the conditions specified in the where clause of the sub query. This format is often used to create an empty table that has the columns we want by specifying a condition that is never true such as "1=2". That way the table is created but not populated.

Let's look at sub-queries in more detail before looking at multi-table queries. Sub-queries are exactly what they say they are - queries embedded in another sql statement. When embedded in another query they allow us to answer multi-part questions. For example "give me the names of all the employees in all departments which had a budget over $120,000 this year". Assuming that budget is a column in the department table we can answer the question by breaking it down into two parts: part 1 - "which departments had a budget over $120,000 this year?" and part 2 - "which employees are in those departments?" This is translated into sql as follows:

SELECT employee_id, name FROM employees WHERE department_id IN

( SELECT department_id FROM department WHERE budget > 120000 );

Note that the query is written top down, but executed form the bottom up ie. the sub query is run first. The beauty of sub-queries is that we can keep nesting them almost infinitely to answer more and more complex questions. In practice, however, it is unlikely that you would ever nest a query more than 3 levels deep because of performance issues (discussion of which is outside the scope of this tutorial) and because the code becomes hard to understand and therefore hard to maintain.

We've seen that sub-queries can be used to answer multi-part questions, however there is another way of doing the same thing and that is to convert the sub-query into a join. There may be performance implications for doing this and these would have to be established by trial and error. To convert a sub query into a join we just promote the table to the "from" clause in the first part of the query and add the conditions in the inner "where" clause to the outer "where" clause and specify the join condition between the tables.

Let's re-work the first example as a join. We started with

SELECT employee_id FROM employees WHERE department_id IN

( SELECT department_id FROM department WHERE budget > 120000 );

we can change this to:-

SELECT employee_id FROM employees, departments

WHERE budget > 120000

AND employees.department_id = departments.department_id;

Note that in the join condition we had to specify the table names because department_id is a column in both tables. If we didn't do this, Oracle would raise an error because it wouldn't know to which department_id we were referring. To answer a three part question we could add more tables to the join or add a sub query as in the following example:-

SELECT employee_id FROM employees, departments

WHERE budget = (SELECT MAX(budget) FROM departments)

AND employees.department_id = departments.department_id;

This shows the flexibility of sql because the order of the conditions does not matter in terms of the final result.

I have over 15 years experience with Oracle as dba, designer, developer and trainer on UNIX (Solaris, Linux,HP-UX) and other platforms with a long track record in delivering high quality results on time and on budget for many blue-chip companies.

My technical experience includes:-
·Oracle database administration (v7- 11g)
·Oracle Application Server (9i,10g)
·PL/SQL
·Oracle Forms and Reports (v3 - 10g)
.Oracle Application Express
.Datawarehouse design and build
.Solaris
.Linux
.HP-UX

Acces anonim la cuburi

Serj K — Fri, 29 Oct 2010 13:46:37 GMT

Am un server de SSAS in alt domeniu decat statiile client si doresc sa il accesez dintr-un client de OLAP (care merge fara probleme in aceeasi retea sau local). In momentul cand incerc sa ma conectez, conexiunea e rejectata (the peer prematurely closed the connection) iar Profilerul spune ca s-a conectat userul NT Authority\Anonymous login.

De asemenea, am facut cam tot ce am gasit referitor la acest lucru:

-RequireClientAuthentication din SSAS e fals

-In Surface Area Config sunt permise conexiunile anonime si conexiunile remote

-NT AUTHORITY\ANONYMOUS LOGIN este adaugat in lista de roluri pentru cuburi

Problema este discutata si de altii, chiar si pe site la Microsoft, dar solutia nu am gasit-o.

A reusit cineva sa activeze accesul anonim? Multumesc.

Mentionez ca e vorba de SQL Server si SSAS 2005.

Motor de cautare specializat pe joburile IT din Bucuresti

mariusm — Tue, 12 Oct 2010 22:35:01 GMT

Un motor de cautare specializat pe joburile IT din Bucuresti.

http://www.it-b.ro/

Sunt foarte deschis la idei de imbunatatire a site-ului.

The row was not found at the Subscriber when applying the replicated command.

neo — Wed, 22 Sep 2010 09:58:00 GMT

salut ,

am intr-o replicare tranzactionala bidirectionala (sql serv 2005) mesajul "The row was not found at the Subscriber when applying the replicated command. " Am rulat "SELECT DISTINCT
subscriptions.publisher_database_id
FROM sys.servers AS [publishers]
INNER JOIN distribution.dbo.MSpublications AS [publications] ON publishers.server_id = publications.publisher_id
INNER JOIN distribution.dbo.MSarticles AS [articles] ON publications.publication_id = articles.publication_id
INNER JOIN distribution.dbo.MSsubscriptions AS [subscriptions] ON articles.article_id = subscriptions.article_id
AND articles.publication_id = subscriptions.publication_id
AND articles.publisher_db = subscriptions.publisher_db
AND articles.publisher_id = subscriptions.publisher_id
INNER JOIN sys.servers AS [subscribers] ON subscriptions.subscriber_id = subscribers.server_id
WHERE publishers.name = 'MyPublisher'
AND publications.publication = 'MyPublication'
AND subscribers.name = 'MySubscriber'
"

si

EXECUTE distribution.dbo.sp_browsereplcmds
@xact_seqno_start = '0x0000001900001926000800000000',
@xact_seqno_end = '0x0000001900001926000800000000',
@publisher_database_id = 29,
@command_id = 1
pentru a vedea unde e problema.

in monitorul de replicare apare mesajul

if @@trancount>0 rollback tran
(Transaction sequence number 0x0023F7...... Comand ID: 2)

ce ar trebui sa fac? sa rulez doar aceasta comanda de rollback? daca da cum pot rula rolback atat de personalizat?

multumesc

Interfatare soft gestiune cu un magazin virtual

officeconect — Mon, 13 Sep 2010 06:58:08 GMT

Salut!
Ma numesc Sandu, si nu am cunostinte de programare. As dori daca exista cineva pe forumul asta, sa imi conceapa un cod, care sa ruleze in fundal si care foloseste o biblioteca dll, care sa faca legaturile de import respectiv de export de date dintr-o aplicatie in alta(din gestiune in modulul de magazin virtual si invers). Ambele aplicatii folosesc baze de date SQL, si am documentatia necesara despre cum ar trebui sa arate codul.
In cazul in care cineva este interesat, va las nr. meu de telefon: 0745-984.160 - Sandu Tronca.
Tx in advance.

24 Hours of PASS 15 - 16 septembrie 2010

Diana — Sun, 12 Sep 2010 09:46:21 GMT

http://www.sqlpass.org/24hours/fall2010/