{"id":39150,"date":"2019-10-31T22:28:07","date_gmt":"2019-10-31T19:28:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server\/"},"modified":"2019-10-31T22:28:07","modified_gmt":"2019-10-31T19:28:07","slug":"10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","title":{"rendered":"10 bezplatn\u00fdch n\u00e1stroj\u016f ApexSQL pro spr\u00e1vu datab\u00e1z\u00ed Microsoft SQL Server","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"10
\n
\nAhoj, Habr! Hodn\u011b spolupracujeme s Quest Software<\/a><\/noindex>, a letos koupili ApexSQL<\/a><\/noindex> \u2014 v\u00fdrobce \u0159e\u0161en\u00ed pro spr\u00e1vu a monitorov\u00e1n\u00ed datab\u00e1z\u00ed Microsoft SQL Server. V Rusku m\u00e1lo lid\u00ed v\u00ed o t\u011bchto chlapc\u00edch, jak se n\u00e1m zd\u00e1. Na hlavn\u00ed str\u00e1nce jejich webu p\u00ed\u0161\u00ed \u201eKiller tools for SQL Server\u201c. Zn\u00ed to hroziv\u011b. M\u00e1me n\u00e1pad p\u0159edstavit tohoto dodavatele a zjistit, co je na jejich \u0159e\u0161en\u00edch tak smrt\u00edc\u00edho. Za\u010dneme s hype \u010d\u00e1st\u00ed \u2014 zdarma dostupn\u00fdmi produkty. Po nich bude kr\u00e1tk\u00e1 \u010d\u00e1st o komer\u010dn\u00edch produktech. Douf\u00e1m, \u017ee v\u00e1m tyto programy budou u\u017eite\u010dn\u00e9. Pros\u00edm, pod\u00edvejte se.
\n<\/a><\/noindex>
\nV tomto \u010dl\u00e1nku:<\/p>\n

    \n
  1. ApexSQL Compare<\/a><\/noindex> \u2014 n\u00e1stroj pro porovn\u00e1v\u00e1n\u00ed SQL k\u00f3du, soubor\u016f a slo\u017eek. Funguje tak\u00e9 jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  2. ApexSQL Decrypt<\/a><\/noindex> \u2014 streamov\u00e9 de\u0161ifrov\u00e1n\u00ed objekt\u016f v SQL Server: procedur, funkc\u00ed, trigger\u016f a pohled\u016f (view). Funguje tak\u00e9 jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  3. ApexSQL Discover<\/a><\/noindex> \u2014 objevov\u00e1n\u00ed instanc\u00ed SQL Server a souvisej\u00edc\u00edch slu\u017eeb SSRS, SSAS a SSIS.<\/li>\n
  4. ApexSQL Refactor<\/a><\/noindex> \u2014 n\u00e1stroj pro refaktoring a form\u00e1tov\u00e1n\u00ed SQL k\u00f3du. Funguje jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  5. ApexSQL Model<\/a><\/noindex> \u2014 vytv\u00e1\u0159en\u00ed diagram\u016f objekt\u016f SQL Server. Funguje tak\u00e9 jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  6. ApexSQL Plan<\/a><\/noindex> \u2014 n\u00e1stroj pro optimalizaci pl\u00e1n\u016f prov\u00e1d\u011bn\u00ed (Execution plans). Funguje tak\u00e9 jako roz\u0161\u00ed\u0159en\u00ed pro SSMS.<\/li>\n
  7. ApexSQL Complete<\/a><\/noindex> \u2014 n\u00e1stroj pro automatick\u00e9 dokon\u010dov\u00e1n\u00ed SQL p\u0159\u00edkaz\u016f a umo\u017e\u0148uje p\u0159id\u00e1vat vlastn\u00ed snippet (kl\u00e1vesov\u00e9 zkratky pro automatick\u00e9 vypl\u0148ov\u00e1n\u00ed). Funguje tak\u00e9 jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  8. ApexSQL Propagate<\/a><\/noindex> \u2014 n\u00e1stroj pro prov\u00e1d\u011bn\u00ed SQL k\u00f3du na n\u011bkolika DB najednou.<\/li>\n
  9. ApexSQL Search<\/a><\/noindex> \u2014 utilita pro vyhled\u00e1v\u00e1n\u00ed dat a objekt\u016f v \u00fatrob\u00e1ch SQL Server. Funguje jako roz\u0161\u00ed\u0159en\u00ed pro SSMS nebo Visual Studio.<\/li>\n
  10. ApexSQL DevOps Toolkit<\/a><\/noindex> \u2014 n\u00e1stroj pro vytv\u00e1\u0159en\u00ed CI\/CD pipeline. Jako jedin\u00fd z v\u0161ech uveden\u00fdch produkt\u016f m\u00e1 webovou konzolu.<\/li>\n<\/ol>\n

    \nKa\u017ed\u00fd produkt je sou\u010d\u00e1st\u00ed funkce placen\u00fdch \u0159e\u0161en\u00ed ApexSQL. Na konci \u010dl\u00e1nku stru\u010dn\u011b \u0159ekneme, co maj\u00ed v nab\u00eddce z komer\u010dn\u00edch \u0159e\u0161en\u00ed. <\/p>\n

    <\/a><\/noindex><\/p>\n

    1. ApexSQL Compare<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    V Compare m\u016f\u017eete porovn\u00e1vat soubory, slo\u017eky a objekty SQL Server. Podporuje se obousm\u011brn\u00e9 porovn\u00e1n\u00ed a n\u00e1sledn\u00e1 generace skriptu pro slou\u010den\u00ed odli\u0161n\u00fdch objekt\u016f. V rozhran\u00ed n\u00e1stroj dok\u00e1\u017ee zv\u00fdraz\u0148ovat syntaxi C#, C++, HTML, JavaScriptu, PostgreSQL, Pythonu, T-SQL, Visual Basic a XML.<\/p>\n

    \"10
    \n
    \nKl\u00ed\u010dov\u00e9 vlastnosti \u2014 integrace do SSMS a Visual Studio, vol\u00e1n\u00ed objekt\u016f z r\u016fzn\u00fdch instance DB pro porovn\u00e1n\u00ed p\u0159\u00edmo z Object Explorer a     podpora pr\u00e1ce p\u0159es CLI<\/a><\/noindex>.<\/p>\n

    <\/a><\/noindex><\/p>\n

    2. ApexSQL Decrypt<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    V Decrypt z rozhran\u00ed SSMS nebo Visual Studio m\u016f\u017eete de\u0161ifrovat proceduru, funkci, spou\u0161t\u011b\u010d nebo pohled (view) jedn\u00edm kliknut\u00edm.<\/p>\n

    \"10
    \n
    \nV rozhran\u00ed si m\u016f\u017eete prohl\u00e9dnout DDL skript de\u0161ifrov\u00e1n\u00ed. Podporuje se sou\u010dasn\u00e9 p\u0159ipojen\u00ed k v\u00edce instanc\u00edm SQL Server.<\/p>\n

    <\/a><\/noindex><\/p>\n

    3. ApexSQL Discover<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nZji\u0161t\u011bn\u00ed existuj\u00edc\u00edch instanc\u00ed SQL Server, slu\u017eeb SSRS, SSAS a SSIS podle rozsahu IP adres a zobrazen\u00ed podrobn\u00fdch informac\u00ed.<\/p>\n

    \"10
    \n
    \nZ rozhran\u00ed m\u016f\u017eete nastavit objevov\u00e1n\u00ed DB podle pl\u00e1nu. ApexSQL Discover m\u016f\u017ee pos\u00edlat ozn\u00e1men\u00ed s v\u00fdsledky objevov\u00e1n\u00ed na e-mail.<\/p>\n

    <\/a><\/noindex><\/p>\n

    4. ApexSQL Refactor<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Form\u00e1tov\u00e1n\u00ed k\u00f3du lze prov\u00e1d\u011bt na z\u00e1klad\u011b v\u00fdchoz\u00edho profilu nebo si nastavit vlastn\u00ed, aby k\u00f3d vypadal pro v\u00e1s nejp\u0159irozen\u011bji. Refactor m\u016f\u017ee zv\u00fdraznit nepou\u017e\u00edvan\u00e9 prom\u011bnn\u00e9 v k\u00f3du, inkapsulovat bloky k\u00f3du do procedur, rozbalit \"*\" do \u00fapln\u00e9ho seznamu.<\/p>\n

    \"10
    \n
    \nJedna z u\u017eite\u010dn\u00fdch funkc\u00ed \u2014 rozd\u011blen\u00ed tabulek pro odd\u011blen\u00ed nejm\u00e9n\u011b pou\u017e\u00edvan\u00fdch sloupc\u016f. O objektech, na kter\u00e9 t\u00e9to rozd\u011blen\u00ed dopadne, Refactor informuje.<\/p>\n

    \"10
    \n
    \nTak\u00e9 v rozhran\u00ed Refactor m\u016f\u017eete bezpe\u010dn\u011b m\u011bnit n\u00e1zvy objekt\u016f se zm\u011bnou v\u0161ech z\u00e1vislost\u00ed.<\/p>\n

    \"10
    \n
    \nO t\u011bchto a dal\u0161\u00edch funkc\u00edch se m\u016f\u017eete podrobn\u011bji sezn\u00e1mit na str\u00e1nce s     popisem n\u00e1stroje<\/a><\/noindex>.<\/p>\n

    <\/a><\/noindex><\/p>\n

    5. ApexSQL Model<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nN\u00e1stroj vizualizuje objekty SQL Server a vazby mezi nimi. V tomto rozhran\u00ed m\u016f\u017eete m\u011bnit konfiguraci objekt\u016f a generovat odpov\u00eddaj\u00edc\u00ed DDL k\u00f3d. V\u0161echny vizualizace lze exportovat ve form\u011b obr\u00e1zk\u016f.<\/p>\n

    Funk\u010dnost Modelu se roz\u0161i\u0159uje pomoc\u00ed komer\u010dn\u00edch produkt\u016f Diff<\/a><\/noindex> a Doc<\/a><\/noindex>. Pomoc\u00ed prvn\u00edho produktu m\u016f\u017eete porovnat model se sou\u010dasn\u00fdm stavem v DB nebo porovnat modely dvou r\u016fzn\u00fdch DB, druh\u00fd produkt je pot\u0159ebn\u00fd k dokumentov\u00e1n\u00ed objekt\u016f DB.<\/p>\n

    <\/a><\/noindex><\/p>\n

    6. ApexSQL Plan<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Toto je n\u00e1stroj na optimalizaci v\u00fdkonu. Pomoc\u00ed ApexSQL Plan lze tak\u00e9 exportovat pl\u00e1ny do report\u016f ve form\u00e1tech HTML a XML. \u010cast\u00fd p\u0159\u00edpad pou\u017eit\u00ed tohoto n\u00e1stroje je srovn\u00e1n\u00ed aktu\u00e1ln\u00edho pl\u00e1nu a modifikovan\u00e9ho podle r\u016fzn\u00fdch krit\u00e9ri\u00ed.<\/p>\n

    \"10
    \n
    \nApexSQL Plan podporuje export z \u00falo\u017ei\u0161t\u011b dotaz\u016f (query store) a zobrazen\u00ed charakteristik t\u011bchto dotaz\u016f ve form\u011b dashboard\u016f.<\/p>\n

    <\/a><\/noindex><\/p>\n

    7. ApexSQL Complete<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Zrychlova\u010d psan\u00ed k\u00f3du. V rozhran\u00ed n\u00e1stroje lze nastavit aliasy, snippet a zv\u00fdrazn\u011bn\u00ed k\u00f3du.<\/p>\n

    <\/a><\/noindex><\/p>\n

    8. ApexSQL Propagate<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nV ApexSQL Propagate lze nastavit prov\u00e1d\u011bn\u00ed k\u00f3du na r\u016fzn\u00fdch datab\u00e1z\u00edch SQL Server, definovat po\u0159ad\u00ed prov\u00e1d\u011bn\u00ed.<\/p>\n

    \"10
    \n
    \nV\u00fdsledky proveden\u00e9ho k\u00f3du jsou parserov\u00e1ny n\u00e1strojem a zapisov\u00e1ny pro snadn\u011bj\u0161\u00ed prohl\u00ed\u017een\u00ed v\u00fdsledk\u016f prov\u00e1d\u011bn\u00ed.<\/p>\n

    <\/a><\/noindex><\/p>\n

    9. ApexSQL Search<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    N\u00e1stroj prov\u00e1d\u00ed vyhled\u00e1v\u00e1n\u00ed ve struktu\u0159e datab\u00e1ze. Odtud lze tak\u00e9 bezpe\u010dn\u011b p\u0159ejmenov\u00e1vat objekty a sledovat jejich vazby. V\u00fdsledky vyhled\u00e1v\u00e1n\u00ed jsou exportov\u00e1ny do HTML, CSV a Excel. <\/p>\n

    <\/a><\/noindex><\/p>\n

    10. ApexSQL DevOps Toolkit<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nKr\u00e1tk\u00e9 video o mechanismu pr\u00e1ce a mo\u017enostech<\/b>

    \r\n \"P\u0159ehr\u00e1t\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Pod povrchem n\u00e1stroje b\u011b\u017e\u00ed k\u00f3d PowerShell. Build, Review, Document a Deploy jsou k dispozici pro v\u00fdvoj\u00e1\u0159e z rozhran\u00ed ApexSQL DevOps Toolkit. Zde lze tak\u00e9 generovat syntetick\u00e1 data, automaticky prov\u00e1d\u011bt jednotkov\u00e9 testy a dokumentovat zm\u011bny. M\u016f\u017ee se p\u0159ipojit jako plugin k TeamCity, Jenkins a dal\u0161\u00edm.<\/p>\n

    V znalostn\u00ed b\u00e1zi ApexSQL jsou zaj\u00edmav\u00e9 \u010dl\u00e1nky<\/a><\/noindex> o DevOps v prost\u0159ed\u00ed datab\u00e1z\u00ed.<\/p>\n

    Nyn\u00ed, kdy\u017e jsme se sezn\u00e1mili s bezplatn\u00fdmi \u0159e\u0161en\u00edmi, stru\u010dn\u011b uvedeme seznam placen\u00fdch \u0159e\u0161en\u00ed, kter\u00e1 samoz\u0159ejm\u011b disponuj\u00ed mocn\u011bj\u0161\u00edm funk\u010dn\u00edm vybaven\u00edm.<\/p>\n

      \n
    1. ApexSQL Audit<\/a><\/noindex> \u2014 n\u00e1stroj pro audit datab\u00e1z\u00ed na shodu s bezpe\u010dnostn\u00edmi po\u017eadavky, v\u010detn\u011b podpory HIPAA, GDPR, PCI. Podporovan\u00e9 jsou reporty a prohl\u00ed\u017een\u00ed historie zm\u011bn.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    2. ApexSQL Backup<\/a><\/noindex> \u2014 automatizace vytv\u00e1\u0159en\u00ed inkrement\u00e1ln\u00edho z\u00e1lohov\u00e1n\u00ed, logu transakc\u00ed a pln\u00e9ho z\u00e1lohov\u00e1n\u00ed. Podporuje obnoven\u00ed k ur\u010dit\u00e9mu okam\u017eiku, je mo\u017en\u00e9 vytv\u00e1\u0159et \u0161ablony pro z\u00e1lohov\u00e1n\u00ed a flexibiln\u011b nastavovat pl\u00e1ny z\u00e1lohov\u00e1n\u00ed.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    3. ApexSQL Defrag<\/a><\/noindex> \u2014 n\u00e1stroj pro monitorov\u00e1n\u00ed a spr\u00e1vu defragmentace.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    4. ApexSQL Job<\/a><\/noindex> \u2014 n\u00e1stroj pro spr\u00e1vu \u00faloh, v\u010detn\u011b historie, harmonogramu a upozorn\u011bn\u00ed.\n

      Pod\u00edvejte se na screenshot<\/b>\"10
      \n\n<\/li>\n

    5. ApexSQL Log<\/a><\/noindex> \u2014 n\u00e1stroj pro \u010dten\u00ed logu transakc\u00ed pro audit, replikaci nebo vr\u00e1cen\u00ed zm\u011bn.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    6. ApexSQL Recover<\/a><\/noindex> \u2014 obnova po\u0161kozen\u00fdch, odstran\u011bn\u00fdch nebo ztracen\u00fdch dat.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    7. ApexSQL Analyze<\/a><\/noindex> \u2014 n\u00e1stroj pro anal\u00fdzu vazeb v DB.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    8. ApexSQL Build<\/a><\/noindex> \u2014 n\u00e1stroj pro automatizaci vytv\u00e1\u0159en\u00ed DB. Lze p\u0159ipojit k syst\u00e9m\u016fm pro spr\u00e1vu verz\u00ed.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    9. ApexSQL Enforce<\/a><\/noindex> \u2014 vylep\u0161ova\u010d SQL k\u00f3du.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    10. ApexSQL Generate<\/a><\/noindex> \u2014 n\u00e1stroj pro generov\u00e1n\u00ed milion\u016f \u0159\u00e1dk\u016f dat jedn\u00edm kliknut\u00edm. Podporuje export testovac\u00edch dat do SQL, XML, CSV, JSON a Excel.\n

      Pod\u00edvejte se na screenshot<\/b>\"10
      \n\n<\/li>\n

    11. ApexSQL Mask<\/a><\/noindex> \u2014 n\u00e1stroj pro vyhled\u00e1v\u00e1n\u00ed, klasifikaci a maskov\u00e1n\u00ed citliv\u00fdch dat v DB. M\u00e1 v\u00edce ne\u017e 220 p\u0159eddefinovan\u00fdch masek a v\u00edce ne\u017e 55 vestav\u011bn\u00fdch filtr\u016f pro klasifikaci.\n

      Pod\u00edvejte se na screenshot<\/b>\"10
      \n\n<\/li>\n

    12. ApexSQL Script<\/a><\/noindex> \u2014 n\u00e1stroj pro vytv\u00e1\u0159en\u00ed DDL a DML skript\u016f a spustiteln\u00fdch instala\u010dn\u00edch bal\u00ed\u010dk\u016f.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    13. ApexSQL Source Control<\/a><\/noindex> \u2014 n\u00e1stroj pro integraci syst\u00e9m\u016f spr\u00e1vy verz\u00ed se SSMS.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    14. ApexSQL Trigger<\/a><\/noindex> \u2014 audit dat v DB a jejich p\u0159evod do DML.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    15. ApexSQL Unit Test<\/a><\/noindex> \u2014 n\u00e1stroj pro prov\u00e1d\u011bn\u00ed unit test\u016f p\u0159\u00edmo z konzole SSMS.\n

      Pod\u00edvejte se na screenshot a video<\/b>\"10
      \n
      \n

      \r\n \"P\u0159ehr\u00e1t\r\n
      <\/div>\r\n <\/div><\/center>\n<\/li>\n<\/ol>\n

      \nNapi\u0161te do koment\u00e1\u0159\u016f, jak\u00e9 n\u00e1stroje pro audit a spr\u00e1vu DB ji\u017e pou\u017e\u00edv\u00e1te a jak\u00e9 \u00fakoly s nimi \u0159e\u0161\u00edte.<\/p>\n

      Pokud m\u00e1te dotazy t\u00fdkaj\u00edc\u00ed se produkt\u016f ApexSQL, chcete si vy\u017e\u00e1dat testovac\u00ed verze komer\u010dn\u00edch produkt\u016f nebo zjistit cenu, zanechte \u017e\u00e1dost v kontaktn\u00edm formul\u00e1\u0159i na na\u0161em webu<\/a><\/noindex>.<\/p>\n

      Pokud \u0159e\u0161\u00edte komplexn\u00ed \u00fakol v oblasti monitorov\u00e1n\u00ed a spr\u00e1vy, p\u0159e\u010dt\u011bte si na\u0161e p\u0159edchoz\u00ed \u010dl\u00e1nky na Habru:<\/p>\n

      Monitorov\u00e1n\u00ed r\u016fzn\u00fdch datab\u00e1z\u00ed z jednoho rozhran\u00ed.<\/a><\/noindex><\/p>\n

      Rychl\u00e1 lokalizace probl\u00e9m\u016f s v\u00fdkonem v SQL Serveru.<\/a><\/noindex><\/p>\n

      Audit zm\u011bn v infrastruktu\u0159e Microsoft (v\u010detn\u011b SQL Serveru).<\/a><\/noindex><\/p>\n

      A m\u016f\u017eete se tak\u00e9 p\u0159ihl\u00e1sit k odb\u011bru na\u0161\u00ed str\u00e1nce na Facebooku<\/a><\/noindex>.
      \n
      Zdroj:       habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

      \u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041c\u044b \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 Quest Software, \u0438 \u0432 \u044d\u0442\u043e\u043c \u0433\u043e\u0434\u0443 \u043e\u043d\u0438 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u043b\u0438 ApexSQL \u2014 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server. \u0412 \u0420\u043e\u0441\u0441\u0438\u0438 \u043e\u0431 \u044d\u0442\u0438\u0445 \u0440\u0435\u0431\u044f\u0442\u0430\u0445, \u043a\u0430\u043a \u043d\u0430\u043c \u043a\u0430\u0436\u0435\u0442\u0441\u044f, \u0437\u043d\u0430\u044e\u0442 \u043c\u0430\u043b\u043e. \u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0441\u0432\u043e\u0435\u0433\u043e \u0441\u0430\u0439\u0442\u0430 \u043e\u043d\u0438 \u043f\u0438\u0448\u0443\u0442 \u00abKiller tools for SQL Server\u00bb. \u0417\u0432\u0443\u0447\u0438\u0442 \u0443\u0433\u0440\u043e\u0436\u0430\u044e\u0449\u0435. \u0423 \u043d\u0430\u0441 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0438\u0434\u0435\u044f \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":29381,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-39150","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd4710 bezplatn\u00fdch utilit ApexSQL pro spr\u00e1vu datab\u00e1z\u00ed Microsoft SQL Server | ProHoster","description":"Ahoj, Habr!","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd4710 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0443\u0442\u0438\u043b\u0438\u0442 ApexSQL \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440!","og:url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:28:07+00:00","article:modified_time":"2019-10-31T19:28:07+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"39150","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-24 00:58:23","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:55:35","updated":"2026-01-24 00:58:23","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/39150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=39150"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/39150\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/29381"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=39150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=39150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=39150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}