Thứ Hai, 30 tháng 12, 2019

The Daily Build - SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure

The Daily Build - SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure

Headline article

SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure

  (89 votes) by Sergey Syrovatchenko (updated 17 hours ago)
Open source index maintenance tool for SQL Server and Azure

New Articles, Tech Blogs and Tips

Client side scripting

  (0 votes) by Ahmed Bouchefra (updated 22 hours ago)
In this tutorial, we'll install the latest Angular CLI version and generate a new Angular 9 project with routing.
  (0 votes) by Ahmed Bouchefra (updated 22 hours ago)
In this post, we'll see by examples how to use the ngFor directive to iterate over arrays of data and even objects in Angular templates.

Database

  (1 votes) by Wendelius (updated 23 hours ago)
How to overcome the error message "Types don't match between the anchor and the recursive part in column..." for varchar columns in a recursive CTE query
  (0 votes) by OriginalGriff (updated 2 days ago)
Select users with a birthday in the next "n" days is pretty easy, if you use the day of year. The only slight complication is the need to "wrap" round the year end.

Grid & Data Controls

  (0 votes) by essentialSQL (updated 4 hours ago)
In this puzzle, we're going to work through a problem to identify the top and bottom 25 percent to rank student scores. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you've learned.

PHP

  (2 votes) by Foma Tuturov (updated 2 days ago)
MVC Framework

SQL Reporting Services

  (0 votes) by essentialSQL (updated 18 hours ago)
In this puzzle we're going to learn how to find the person whose birthday, among others, is in the middle.  Knowing how to calculate the median value is a good skill to have.  As you start to explore business intelligence you'll come across similar problems to solve.
  (0 votes) by essentialSQL (updated 18 hours ago)
In this puzzle, we're going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you've learned.

Uncategorised Technical Blogs

  (0 votes) by essentialSQL (updated 4 hours ago)
In this video we’ll walk you though how to select top rows within a query.   We’ll show you how to retrieve the top or bottom rows in the result.  We’ll also show you how to use one sort to select the rows, and once completed, another sort to present them (tricky).

Updated Articles, Tech Blogs and Tips

Algorithms & Recipes

  (70 votes) by Peter Occil (updated 22 hours ago)
Most apps that use random numbers care about either unpredictability, high quality, or repeatability. This article explains the three kinds of RNGs and gives recommendations on each kind.
  (54 votes) by Alex Rakov, Alexandre Bencz (updated 2 days ago)
ELENA is a general-purpose, object-oriented, polymorphic language with late binding

ASP.NET

Miscellaneous

  (16 votes) by Michael Haephrati (updated 2 days ago)
Why the creation of a cover story is a mandatory part of any covert monitoring product and how Target Eye handled it

Không có nhận xét nào:

Đăng nhận xét