Diverse

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!

24 Hours of PASS Spring 2012 - 21.03.2012

Diana — Thu, 08 Mar 2012 19:24:51 GMT

http://www.sqlpass.org/24hours/spring2012/SessionsbyTrack.aspx

"SQL Server 2012 Launch is a joke"

Diana — Thu, 08 Mar 2012 19:42:21 GMT

http://www.midnightdba.com/DBARant/?p=827

Despre ”injecții SQL”

B_gd_n[ ]Sahlean — Sun, 23 May 2010 15:10:21 GMT

Sursa: http://xkcd.com/327/

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

24 Hours of PASS 15 - 16 septembrie 2010

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

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

Cam din scurt, dar merita

Diana — Fri, 30 Jul 2010 09:30:35 GMT

http://www.vconferenceonline.com/shows/spring10/uvc/event_730.asp?msg=You%20have%20already%20registered%20for%20this%20event.

Speakeri faimosi. GRATIS. :)

SSWUG Learning Center

Diana — Fri, 30 Jul 2010 09:09:10 GMT

Workshop-ul lui Kalen Delaney sigur merita.

http://www.sswug.org/learning/

SQLBits - The 7 Wonders of SQL

Diana — Fri, 30 Jul 2010 09:06:45 GMT

http://www.sqlservercentral.com/articles/Events/70823/

Avem tupeu

Diana — Sat, 03 Jul 2010 17:47:08 GMT

Asadar:
http://www.brentozar.com/archive/2010/03/plagiarism-inspiration-and-john-dunleavy/
http://itknowledgeexchange.techtarget.com/sql-server/plagiarism-inspiration-and-john-dunleavy-madder-and-more-pissed-off/

Si mai jos preturile pe care le practica plagiatorul:
http://sqltechconsulting.com/rates/

DBA training videos

Diana — Mon, 28 Jun 2010 20:38:03 GMT

http://dbmanagement-blog.com/sql-server-dba-training-videos/

24 Hours of PASS: Celebrating SQL Server R2 - Recordings

Diana — Sat, 19 Jun 2010 13:13:32 GMT

http://www.sqlpass.org/LearningCenter/24Hours.aspx

Carte BI - PerformancePoint 2007

geo — Thu, 17 Jun 2010 09:26:10 GMT

Salut,

E cineva interesat de cartea Business Intelligence with Microsoft® Office PerformancePoint(TM) Server 2007 ?
E ca si noua, sunt subliniate cu evidentiatorul cateva randuri pe primele 30 pagini (pana s-a razgandit seful ca e prea scump si nu mai are rost)

Am luat-o de pe Amazon: http://www.amazon.co.uk/Business-Intelligence-Microsoft%C2%AE-Office-PerformancePoint/dp/0071493700/ref=sr_1_1?ie=UTF8&s=books&qid=1276758025&sr=8-1

Cine e interesant sa-mi faca o oferta pe PM.

o zi buna,
geo

Report Builder 2.0

Byty — Tue, 11 May 2010 10:37:06 GMT

Cine are sa imi dea si mie un link la un tuorial/manual/ altceva... care sa imi arata cum se foloseste de la 0 la mai avansat..

De citit

Diana — Mon, 10 May 2010 07:59:33 GMT

http://www.red-gate.com/specials/Ebooks/defensive_database_programming.htm?utm_source=dbw&utm_medium=email&utm_content=defensive-20100509&utm_campaign=sqltoolbelt

Si, pe langa carte
http://sqlblog.com/blogs/alexander_kuznetsov/

24 Hours of PASS 2010

Diana — Fri, 09 Apr 2010 21:08:04 GMT

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

1 aprilie

B_gd_n[ ]Sahlean — Thu, 01 Apr 2010 08:46:13 GMT

http://www.simple-talk.com/content/article.aspx?article=986

Conferinta SQLBits

Diana — Thu, 01 Apr 2010 19:41:36 GMT

http://www.sqlbits.com/ ---> Sessions from the last conference

Sql Server 2008 Standard

Sterescu Gabriel — Tue, 24 Nov 2009 10:42:32 GMT

Buna Ziua,

Am si eu un sql server 2008 standard si as dori sa aflu cand expiera, exista vreo comanda pe care sa o rulezi ca sa iti zica ?

Multumesc in avans

Cu stima,
Sterescu Gabriel

Problema cu baza de date in Suspect

sandra — Fri, 16 Oct 2009 10:53:51 GMT

Am un server SQL 2000 care tine mai mult baze de date printre care si baza de la SMS.
Intr-o seara partitia pe care se afla fisierele mdf si ldf a ramas fara spatiu iar baza am gasit-o in suspect. Desi am eliberat spatiu pe disc baza tot in Suspect este.
Am modificat in sysdatabases statusul bazei in 24 si acum ea apare normal in lista, SMS se poate conecta si citi din ea, dar este read-only. La orice incercare de scriere in baza primesc eroare. Deasemenea, daca dau restart la server baza revine in Suspect.
Am incercat sa rulez dbcc checkdb pe baza dar nu pare sa faca nimic.
Stie cineva ce ar putea fi de facut? Se mai poate cumva repara baza?

Creare camp Logic (boolean) intr-o interogare SQL

buciutacalin — Thu, 15 Oct 2009 13:30:23 GMT

Buna !

Cum as putea crea un camp de tip logic (boolean) direct intr-o interogare SQL ?

In Visual Fox faceam ceva de genu:
SELECT .F. as selectat, numar FROM documente

Am incercat in SQL urmatoarele:

SELECT 0 as selectat, numar FROM documente
sau
SELECT 1=0 as selectat, numar FROM documente

dar nu a mers

URGENT!!! - refacere date pe baza undei tabele de back-up

victordomain — Mon, 12 Oct 2009 10:07:09 GMT

Buna ziua,

Avem tabelele:

Facturi
id - int
numar - int

Facturi_backup
id - int
numar - int

Dintr-o greseala (update Facturi set numar = 1023), toate numerele de factura din tabela facturi sunt acum 1023.

Partea buna ca am un back-up mai vechi si pot reface majoritatea numerelor de factura.

Intrebarea mea este: Care e comanda care imi preia numerele de factura din tabela Facturi_backup in functie de id si-mi updateaza tabela Facturi astfel incat sa pot reface acele numere de factura. ID-urile nu sunt afectate si ne putem baza pe ele.

Multumesc... e cam..urgent :).

loguri

creieru — Wed, 09 Sep 2009 07:36:36 GMT

buna
pe serverul de SQL mi-a disparut o tabela dintr-o baza de date. A putea afla cine a sters-o sau ce s-a intamplat (din loguri eventual, cu toate ca fisierul de logs din SQL nu se refera la notiunea de logs general cunoscuta, ci e folosit de motorul SQL)....sau alta idee cumva?

multumesc

where exists

ungureandavid — Mon, 27 Jul 2009 11:13:13 GMT

cine poate sa-mi explice dece nu este corecta urmatoarea interogare?

UPDATE ANAPAT...buletin
SET id_prescriptii_pacient =
(
SELECT prescriptii_pacienti.id FROM ANAPAT...prescriptii_pacienti, ANAPAT...buletin
WHERE buletin.id_pacient = prescriptii_pacienti.id_pacient
)
WHERE EXISTS
(
SELECT buletin.id FROM anapat...buletin, anapat...prescriptii_pacienti
WHERE buletin.id_pacient=prescriptii_pacienti.id_pacient
)

insert sau update

ungureandavid — Wed, 22 Jul 2009 10:05:49 GMT

Salut!

Am o aplicatie care insereaza intr-o tabela cateva campuri. Cheia primara este coloana cnp, care nu admite duplicate. Intrebarea mea este: pot sa folosesc vre-o smecherie ca atunci cand randul pe care vreau sa il insereaz daca exista, atunci sa fac update, iar daca nu exista sa fac insert?

Auzisem ca se poate face cu index.. dar nu stiu mai multe...

multumesc
david