Bash on Ubuntu on Windows ‘da dil değiştirme

Eminim siz de henüz beta olan Bash on Ubuntu on Windows’u (kısaca BUW diyeceğim) kurcalamaya devam ediyorsunuzdur. İlk kurduğumda, komutların çıktılarının Türkçe olması benim için biraz tuhaf gelmişti ve bu şekilde kullanmaya (daha doğrusu kurcalamaya) devam ettim. BUW’u makina ayarları Almanca olan bir arkadaşımın makinasında çalıştırıp komut çıktılarını Almanca görünce kalakaldım. Nasıl yapsak da İngilizce yapsak dolayısıyla…


刪除大量資料作法

Method 1 若刪除完成之後留下的資料較多的話(例如要刪除1/3的資料),就用WHILE DELETE top語法來刪除  declare @n int  while 1=1  begin  DELETE top(2000)  FROM dbo.BigTable  WHERE time <= ‘2013-09-03 22:00:00.000’  OPTION(MAXDOP 1) — 可考慮是否只使用一個CPU來執行刪除動作  set @n=@@ROWCOUNT  if @n<2000  break  end   Method 2 若留下的資料比較少(例如要刪除2/3的資料),就可以考慮INSERT INTO再RENAME 1.將要保留的資料INSERT INTO到dbo.Temp_BigTable 2.DROP TABLE dbo.Temp_BigTable 3.RENAME dbo.Temp_BigTable to dbo.BigTable 注意: 因為原Table會被刪除,所以需事先調查與保存與重新設定以下項目 1.權限 2.Trigger 3.Index PS.以下狀況無法直接DROP TABLE 1.被Foreign Key或view with SCHEMABINDING…


Using SQL Server in Windows 8 and later versions of Windows operating system

雖然KB2681562文件說明Windows 10不支援SQL 2008 R2 但經過測試在Windows 10安裝SQL 2008 R2只會跳出警告,最後還是可以安裝成功 ,但此種搭配微軟並不支援,將來也不會有hotfix Using SQL Server in Windows 8 and later versions of Windows operating system https://support.microsoft.com/en-us/kb/2681562 OS version SQL version Minimum SQL Server version requirements Windows 10 SQL 2014 Support SQL Server 2014 Service Pack 1 or a later update SQL 2012 Support SQL Server 2012 Service Pack…


Interview with SQL Server MVP and SQL Server forums Moderator Shashank Singh

Good day, everybody! It is Monday, so it’s time for a new Interview with the Forum’s Ninja.   Today I would like to introduce Shashank Singh who is known as Shanky_621 in the forums. I’ve known Shashank for several years since he became active in SQL Server forums. He is  Microsoft Most Valuable Professional since…


5 diagnostických vychytávek, které ještě v Application Insights neznáte

1. Proactive Detection a unifikace oznámení Již po vytvoření služby Application Insights je automaticky aktivní funkce Proactive Detection. Ta na základě prediktivní analýzy a obecně analýzy sesbíraných dat dokáže hledat anomálie v chování aplikace. Ze života mohu uvést příklad, kdy jsem omylem nasadil verzi aplikace s neaktivní Output Cache. Služba Proactive Detection dokázala do 3…


My Personal FAQ on HDInsight HBase & Phoenix

I will keep this page updated with HDinsight HBase/ Phoenix related commonly asked questions. You can leave comments/questions on this blog as well as follow me on twitter Follow @ashishth Official channel to provide HDInsight related feedback and make feature requests is here What is the advantage of using HBase in Azure HDinight? Azure HDInsight HBase…


Microsoft Forums URL address format

Good day, I have small tip for you today. Did you know that understanding the URL format will give you the power to find forums that you didn’t even know exist? Moreover, by understanding the URL format you can learn a lot about the forums that you are using. In this post I would like to…

4

Платформа ASP.NET Core 1.0. Часть 2: ASP.NET сегодня или что же выбрать?

Многие, в том числе и я, достаточно долго ждали выхода финальной версии .NET Core и ASP.NET Core и конечно дождались. Всего пару месяцев назад была выпущена финальная версия технологии для разработки веб приложений, получившая название ASP.NET Core 1.0. Напомню, что  ещё в начале текущего года именовалась она как ASP.NET 5. Продалжая данный цикл статей, углубимся в детали темы. Всё самое новое, то, что сегодня может предоставить новейшая…


Shooting a Visual Studio Toolbox episode with Robert Green

While shopping at Costo last night, noticed an old friend Robert Green and his beautiful wife Collette happen to be checking out in front of us  (they even came down and visited us while in Australia).  While chatting the topic of work came up and the fact I am now on the Power BI team…


Azure News on Friday (KW34/16)

Auch diese Woche gab’s wieder viele Nachrichten zur Microsoft Azure Plattform. Hier sind nähere Infos dazu… Aktuelle Neuigkeiten Datum Nachricht 26.08. Onboarding to Azure Web Marketplace Eigene Web Apps im Azure Web Marketplace veröffentlichen 26.08. New App Service quota UX Einsicht in die Quotas eigener Azure Web Apps die in der Leistungsstufe Free oder Shared…