都内で働くSEの技術的なひとりごと / Technical soliloquy of System Engineer working in Tokyo

都内でサラリーマンやってます。SQL Server を中心とした (2023年からは Azure も。) マイクロソフト系(たまに、OSS系などマイクロソフト以外の技術も...)の技術的なことについて書いています。日々の仕事の中で、気になったことを技術要素関係なく気まぐれに選んでいるので記事内容は開発言語、インフラ等ばらばらです。なお、当ブログで発信、発言は私個人のものであり、所属する組織、企業、団体等とは何のかかわりもございません。ブログの内容もきちんと検証して使用してください。英語の勉強のため、英語の

English Version Article

Summary of SQL Server tuning - Part 3 - (How much performance does it improve?)

Also today, I am translating the old Japanese post to English while watching "HAKONE EKIDEN". Which does get first prize, Soka-Univ. or Komazawa-Univ? I am looking forward to know the result. In this time, I try to translate following post…

Summary of SQL Server Tuning - Part 2 - (Filtered Index)

Happy New Year to all! I am translating the old Japanese post while watching "Hakone Ekiden". This year, Tokai Univ. team is quite strong. Next, I try to translate following post. ryuchan.hatenablog.comToday, I suddenly realized that the "…

Summary of SQL Server Tuning - Part 1 - (Examine indexes)

Happy New Year to all! I decided to translate old Japanese version posts to English for studying English in this year. First of all, I try to translate following post. ryuchan.hatenablog.comI would like to summarize the tuning of SQL Serve…

年末に記事書いてみる / I'll write an article at the end of the year.

The year is almost over. There weren't many articles this year, either. Next year will be a year of new challenges, so I will try my best to write articles next year. Have a happy new year, everyone!Following article is still being read. T…

Useful SQL functions, syntax, and more - Part 19 (FAST?)

Recently I started working on SQL Server just a little bit on side job. Tuning is an area that I personally like very much because it's like putting the puzzle back together. While doing some research, I found a query hint that I'd never u…

Finding various software to make iPad sub-display

I forgot to write the English version of the article. I wrote early in the morning of May 5. - This is my first article in a while. I hadn't written a article at all since I wrote my New Year's resolutions. ryuchan.hatenablog.com I haven't…

New year’s resolution

A happy new year! I haven't written an article for a long time. I watch HAKONE EKIDEN, and at the same time, I write this article. Last year, I changed a job and the technology I use has also changed. The OS changed from Windows to Redhat …

Started studying Oracle

I haven't posted an article recently. I was busy because my environment has changed. I had used only SQL Server, but now I need to use Oracle at work. ( I had used symfo....lol, too. ) I try to connect Oracle because I can not do anything.…

Introduce the function should be aware of " SQL Server Management Studio " - Part 8 - (Let's easier to write a query.)

ブログへのアクセスログを見ていると、海外からのアクセスが少なからず存在します。( 私の書いた記事を Google 翻訳していたログもありました。 ) 下記のブログを英訳してみましょう。これで海外からのアクセスも増えるかな? ryuchan.hatenablog.comDuring …