-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathblog.html
42 lines (36 loc) · 18 KB
/
blog.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<!DOCTYPE html> <html lang="de"> <head> <meta charset="utf-8"> <title>Robert Meyer Consulting & Training</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="shortcut icon" type="image/x-icon" href="./Logo.ico"> <link href="https://fonts.googleapis.com/css?family=Poppins:400,400i,500,500i,600,600i,700,700i,800,800i,900,900i&display=swap" rel="stylesheet"> <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700&display=swap" rel="stylesheet"> <link href="/assets/fonts/fontawesome-webfont.woff2?v=4.7.0" rel="preload" as="font" type="font/woff2" onload="this.onload=null;this.rel='stylesheet'" crossorigin> <link type="text/css" media="all" href="/assets/css/bootstrap.min.css" rel="stylesheet"> <link type="text/css" media="all" href="/assets/css/jquery.animatedheadline.css" rel="stylesheet"> <link type="text/css" media="all" href="/assets/css/font-awesome.min.css" rel="stylesheet"> <link type="text/css" media="all" href="/assets/css/style.css" rel="stylesheet"> <link type="text/css" media="all" href="/assets/css/skins/goldrenrod.css" rel="stylesheet"> <link type="text/css" media="all" href="/assets/css/rougify-github.css" rel="stylesheet"> <link href="https://www.google-analytics.com" rel=preconnect> <script src="/assets/js/modernizr.js"></script> <title>blog | Robert Meyer Consulting & Training</title> <meta name="generator" content="Jekyll v4.2.2"/> <meta property="og:title" content="blog"/> <meta property="og:locale" content="de"/> <meta name="description" content="Trainer for Mircosoft Azure and Identity/Security. Development from Cloud and Web Solutions."/> <meta property="og:description" content="Trainer for Mircosoft Azure and Identity/Security. Development from Cloud and Web Solutions."/> <link rel="canonical" href="https://meyer-consulting.net/blog.html"/> <meta property="og:url" content="https://meyer-consulting.net/blog.html"/> <meta property="og:site_name" content="Robert Meyer Consulting & Training"/> <meta property="og:type" content="website"/> <meta name="twitter:card" content="summary"/> <meta property="twitter:title" content="blog"/> <meta name="twitter:site" content="@roeb"/> <meta name="twitter:creator" content="@roeb"/> <script type="application/ld+json">
{"@context":"https://schema.org","@type":"WebPage","description":"Trainer for Mircosoft Azure and Identity/Security. Development from Cloud and Web Solutions.","headline":"blog","publisher":{"@type":"Organization","logo":{"@type":"ImageObject","url":"https://meyer-consulting.net/assets/Logo.png"}},"url":"https://meyer-consulting.net/blog.html"}</script> <script>!function(e,a,t,n,o,c,s){e.GoogleAnalyticsObject=o,e[o]=e[o]||function(){(e[o].q=e[o].q||[]).push(arguments)},e[o].l=1*new Date,c=a.createElement(t),s=a.getElementsByTagName(t)[0],c.async=1,c.src=n,s.parentNode.insertBefore(c,s)}(window,document,"script","https://www.google-analytics.com/analytics.js","ga"),ga("create","UA-160199639-1","auto"),ga("send","pageview",{page:location.pathname+location.search+location.hash}),ga("set","anonymizeIp",!0);</script> </head> <body class="dark fullscreendark"> <div class="page"> <div class="stretchy-nav-background"></div> <header id="header"> <div class="cd-stretchy-nav"> <a class="cd-nav-trigger" href="#0" aria-label="Navigation"> <span aria-hidden="true"></span> </a> <ul class="stretchy-nav"> <li> <a href="/de/"> <span> Start </span> </a> </li> <li> <a href="/de/about"> <span> Über mich </span> </a> </li> <li> <a href="/de/services"> <span> Dienstleistungen </span> </a> </li> <li> <a href="/de/talks"> <span> Vorträge </span> </a> </li> </ul> <span aria-hidden="true" class="stretchy-nav-bg"></span> </div> </header> <main id="main"> <span class="back-mobile" id="back-mobile"><i class="fa fa-arrow-left"></i></span> <section id="blog" class="active"> <div class="container page-title text-center"> <h2 class="text-center"> blog <span>beiträge</span> </h2> <span class="title-head-subtitle"> Ich schreibe über Azure, .NET, React, Vue.js und andere Themen der Software-Entwicklung </span> </div> <div class="container blog dark"> <div class="row"> <div class="content"> <article> <a href="/blog/2018/04/16/sql-management-studio-connect-and-queries-take-so-long/"> <h4>SQL Management Studio: Connect and Queries take so long</h4> </a> <figure class="blog-figure"> <a href="/blog/2018/04/16/sql-management-studio-connect-and-queries-take-so-long/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>When I connect to my local SQL Server using SQL Management Studio or SQL Operations Studio and want to execute queries, it sometimes takes several minutes to execute.</p> </p> <a href="/blog/2018/04/16/sql-management-studio-connect-and-queries-take-so-long/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>Long Running Queries</span> <span>SQL Management Studio</span> <span>SQL Operations Studio</span> <span>Timeout</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2018/04/16/sql-management-studio-connect-and-queries-take-so-long/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2017/10/04/git-add-gitignore-after-commit/"> <h4>Git: Add .gitignore after commit</h4> </a> <figure class="blog-figure"> <a href="/blog/2017/10/04/git-add-gitignore-after-commit/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>I had created a new repository in GitHub and forgot to add the .gitignore file to ignore all my Visual Studio and debugging files. However, I did not realize it until after I created the first commit.</p> </p> <a href="/blog/2017/10/04/git-add-gitignore-after-commit/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>GitHub</span> <span>gitignore</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2017/10/04/git-add-gitignore-after-commit/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2017/09/29/self-hosted-asp-net-core-taghelper-doesnt-work/"> <h4>Self Hosted ASP.NET Core: TagHelper doesn't work</h4> </a> <figure class="blog-figure"> <a href="/blog/2017/09/29/self-hosted-asp-net-core-taghelper-doesnt-work/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>I have implemented a simple TagHelper in a ASP.NET Core 2.0 Website, which replace the <time> Tag with the current time. The website never runs in an ISS or Kestrel server, but is hosted by HttpSys in a console / service.</p> </p> <a href="/blog/2017/09/29/self-hosted-asp-net-core-taghelper-doesnt-work/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>.NET Core</span> <span>ASP.NET Core</span> <span>SelfHosted Website</span> <span>TagHelper</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2017/09/29/self-hosted-asp-net-core-taghelper-doesnt-work/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2017/09/22/selfhosted-asp-net-core-2-0-application/"> <h4>SelfHosted ASP.NET Core 2.0 Application</h4> </a> <figure class="blog-figure"> <a href="/blog/2017/09/22/selfhosted-asp-net-core-2-0-application/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Auf Grund einer Projektanforderung musste ich mich die Tage damit auseinandersetzen, wie man eine ASP.NET Core 2.0 Website und Web API in einem eigenen Prozess als Windows Service bereitstellt.</p> </p> <a href="/blog/2017/09/22/selfhosted-asp-net-core-2-0-application/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>.NET Core</span> <span>.NET Standard</span> <span>Autofac</span> <span>NLog</span> <span>SelfHosted Website</span> <span>ServerFabric</span> <span>Windows Service</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2017/09/22/selfhosted-asp-net-core-2-0-application/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2012/08/07/sql-server-2012-eomonth-funktion/"> <h4>SQL Server 2012: EOMONTH Funktion</h4> </a> <figure class="blog-figure"> <a href="/blog/2012/08/07/sql-server-2012-eomonth-funktion/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Mit dem SQL Server 2012 ist eine neue Datumsfunktion dazu gekommen. Mit EOMONTH ist es möglich sich den letzten Tag des Monats ausgeben zu lassen. Dies ist besonders interessant wenn man Wertebereiche innerhalb eines Monats oder über mehrere Monate Tag genau selektieren möchte.</p> </p> <a href="/blog/2012/08/07/sql-server-2012-eomonth-funktion/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>EOMONTH</span> <span>SQL Server 2012</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2012/08/07/sql-server-2012-eomonth-funktion/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2012/07/30/add-sts-reference-in-visual-studio-2012/"> <h4>“Add STS Reference” in Visual Studio 2012</h4> </a> <figure class="blog-figure"> <a href="/blog/2012/07/30/add-sts-reference-in-visual-studio-2012/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Ich habe heute ein Azure Projekt im neuen Visual Studio 2012 angefangen und wollte ACS einbinden. Bei Visual Studio 2010 ging dies sehr einfach über den Menupunkt “Add STS Reference …”.</p> </p> <a href="/blog/2012/07/30/add-sts-reference-in-visual-studio-2012/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>ACS</span> <span>Reference</span> <span>STS</span> <span>Visual Studio</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2012/07/30/add-sts-reference-in-visual-studio-2012/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2012/07/19/pagging-mit-offset-und-fetch-im-sql-server-2012/"> <h4>Paging mit OFFSET und FETCH im SQL Server 2012</h4> </a> <figure class="blog-figure"> <a href="/blog/2012/07/19/pagging-mit-offset-und-fetch-im-sql-server-2012/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Lange hat es gedauert, doch nun beherrscht der SQL Server mit Version 2012 endlich das Paging. Unter Paging versteht man die Festlegung davon wie viele Datensätze pro Seite ausgeben werden sollen. Dies wird besonders bei diversen Webapplikationen benötigt um die Anzahl der geladenen Daten zu verringern.</p> </p> <a href="/blog/2012/07/19/pagging-mit-offset-und-fetch-im-sql-server-2012/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>FETCH</span> <span>OFFSET</span> <span>ORDER BY</span> <span>ROW_NUMBER</span> <span>SQL Server 2012</span> <span>TOP</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2012/07/19/pagging-mit-offset-und-fetch-im-sql-server-2012/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2012/07/17/neuerungen-mit-sharepoint-2013/"> <h4>Neuerungen mit SharePoint 2013</h4> </a> <figure class="blog-figure"> <a href="/blog/2012/07/17/neuerungen-mit-sharepoint-2013/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Diese Nacht war es endlich soweit und die Microsoft SharePoint 2013 Preview stand, neben Office 2013, zum Download bereit. Natürlich bringt SharePoint 2013 viele neue Features mit. Mit einigen hat man gerechnet, andere kamen ziemlich überraschend. Ich möchte euch hier eine kurze Auflistung der neuen Features zur Verfügung stellen.</p> </p> <a href="/blog/2012/07/17/neuerungen-mit-sharepoint-2013/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>Features</span> <span>Neuerungen</span> <span>SharePoint 2013</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2012/07/17/neuerungen-mit-sharepoint-2013/">permalink</a></span> </div> </div> </article> <hr/> <article> <a href="/blog/2012/07/11/update-auf-groe-datenmengen-mit-rowcount/"> <h4>Update auf große Datenmengen mit @@ROWCOUNT</h4> </a> <figure class="blog-figure"> <a href="/blog/2012/07/11/update-auf-groe-datenmengen-mit-rowcount/"> <img class="responsive-img" src="" alt=""> </a> </figure> <div class="blog-excerpt"> <p> <p>Häufig steht man vor der Herausforderung in einer sehr großen Tabelle Datensätze zu aktualisieren. Hat diese z.B. wie in meinem Szenario über 10 Millionen Datensätze und einen Trigger der auf Update Commands reagiert, ist es nicht sehr sinnvoll mit einem mal mehr als 1000 Zeilen zu aktualisieren. Hierbei kann es zu ungewollten Table Locks kommen. Noch problematischer wird es, wenn während des Zeitpunktes des Updates viele Abfragen auf dieser Tabelle ausgeführt werden.</p> </p> <a href="/blog/2012/07/11/update-auf-groe-datenmengen-mit-rowcount/" class="btn readmore"> <span> Mehr ... </span> </a> <div class="meta"> <span><i class="fa fa-user"></i> <a href="#">Robert Meyer</a></span> <span class="date"><i class="fa fa-calendar"></i> 9 January 2017</span> <span class="tags"><i class="fa fa-tags"></i> <span>ROWCOUNT</span> <span>UPDATE</span> <span>WAITFOR DELAY</span> </span> <span class="permalink"><i class="fa fa-link"></i> <a href="/blog/2012/07/11/update-auf-groe-datenmengen-mit-rowcount/">permalink</a></span> </div> </div> </article> <hr/> </div> </div> </div> </section> </main> <footer id="footer"> <style>
#cookie-notice {
width: 100vw;
background: #ccc;
padding: 0.5rem 1rem;
display: none;
text-align: center;
}
#cookie-notice span {
color: #000;
}
#cookie-notice a {
display: inline-block;
cursor: pointer;
margin-left: 0.5rem;
color: #333;
}
#cookie-notice a span {
color: #333;
}
#cookie-notice a:hover span {
color: #fff;
}
@media (max-width: 767px) {
#cookie-notice span {
display: block;
padding-top: 3px;
margin-bottom: 1rem;
}
#cookie-notice a {
position: relative;
bottom: 4px;
}
}
</style> <div id="cookie-notice"> <span> Wir würden gerne Cookies und Skripte von Dritten verwenden, um die Funktionalität dieser Website zu verbessern. </span> <a id="cookie-notice-accept" class="btn"> <span> Erlauben </span> </a> <a href="/de/privacy" class="btn" aria-label="Privacy information"> <span> Informationen </span> </a> </div> <script>function createCookie(e,o,t){var i="";if(t){var n=new Date;n.setTime(n.getTime()+24*t*60*60*1e3),i="; expires="+n.toUTCString()}document.cookie=e+"="+o+i+"; path=/"}function readCookie(e){for(var o=e+"=",t=document.cookie.split(";"),i=0;i<t.length;i++){for(var n=t[i];" "==n.charAt(0);)n=n.substring(1,n.length);if(0==n.indexOf(o))return n.substring(o.length,n.length)}return null}function eraseCookie(e){createCookie(e,"",-1)}"true"==readCookie("cookie-notice-dismissed")||(document.getElementById("cookie-notice").style.display="block"),document.getElementById("cookie-notice-accept").addEventListener("click",function(){createCookie("cookie-notice-dismissed","true",31),document.getElementById("cookie-notice").style.display="none",location.reload()});</script> <div class="social-media"> <div class="language"> <a href="https://meyer-consulting.net/blog" aria-label="English"> <img src="/assets/icons/usa.png" alt="English"/> </a> </div> <div class="social-media icons"> <a href="https://twitter.com/roeb" target="_blank" rel=”noopener”> <div class="social-icon twitter"></div> </a> <a href="https://github.com/roeb" target="_blank" rel=”noopener”> <div class="social-icon github"></div> </a> <a href="https://www.linkedin.com/in/robert-meyer-332b2b28/" target="_blank" rel=”noopener”> <div class="social-icon linkedin"></div> </a> <a href="https://www.xing.com/profile/Robert_Meyer10" target="_blank" rel=”noopener”> <div class="social-icon xing"></div> </a> <a href="https://keybase.io/roeb/" target="_blank" rel=”noopener”> <div class="social-icon keybase"></div> </a> <a href="https://www.malt.de/profile/robertmeyer" target="_blank" rel=”noopener”> <div class="social-icon malt"></div> </a> <a href="https://meyer-consulting.net/feed.xml" target="_blank" rel=”noopener”> <div class="social-icon rss"></div> </a> </div> <div class="legal-notice"> <a href="/de/impressum"> Impressum </a> <a href="/de/privacy" aria-label="Privacy information"> Datenschutz </a> </div> </div> </footer> </div> <script src="/assets/js/jquery-3.6.0.min.js"></script> <script src="/assets/js/jquery.animatedheadline.js"></script> <script src="/assets/js/bootstrap.min.js"></script> <script src="/assets/js/transition.js"></script> <script src="/assets/js/custom.js"></script> </body> </html>