ktaranov

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

ktaranov

Microsoft SQL Server Articles

Title	Author	Modified
SQL Server Index Design Guide	Microsoft	?
SQL Server 2012 Security Best Practices - Microsoft	Bob Beauchemin	2012-01-15

ktaranov

Source: http://translit.net/

RU	EN
а	a
б	b
в	v
г	g
д	d
е	e

ktaranov

SELECT stt.*, lider.LiderCount
FROM `save_tmp_table` as stt
INNER JOIN (
-- в этом подзапросе находим для каждого из авторов максимальное число совместных публикаций с одним из лидеров 20-ки
SELECT first, MAX(count) as countMAX
FROM `save_tmp_table`
INNER JOIN (
-- В подзапросе выбираем 20 авторов, у которых максимально большое число одиночных публикаций - это наши лидеры
SELECT first AS Lider20ID, count AS LiderCount
FROM `save_tmp_table`

ktaranov

#requires -version 4
<#
.SYNOPSIS
  <Overview of script>

.DESCRIPTION
  <Brief description of script>

.PARAMETER <Parameter_Name>
  <Brief description of parameter input required. Repeat this attribute if required>

ktaranov

#requires -version 4
<#
.SYNOPSIS
  <Overview of script>

.DESCRIPTION
  <Brief description of script>

.PARAMETER <Parameter_Name>
  <Brief description of parameter input required. Repeat this attribute if required>

ktaranov

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66

ktaranov

 SELECT 
   name, recovery_model_desc
 FROM sys.databases

SELECT 
 name, recovery_model_desc
FROM sys.databases

ktaranov

library(shiny)
library(shinyjs)



# Get table metadata. For now, just the fields
# Further development: also define field types
# and create inputs generically
GetTableMetadata <- function() {
  fields <- c(id = "Id", 

ktaranov

USE master;
CREATE DATABASE [TestDB]
 CONTAINMENT = NONE
 ON  PRIMARY 
(  NAME = N'TestDB'
 , FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\TestDB.mdf'
 , SIZE = 4GB
 , MAXSIZE = UNLIMITED
 , FILEGROWTH = 4GB )
 LOG ON