2018

Creating Sample VMs on my laptop

 

2017

PERSIST_SAMPLE_PERCENT

All-important commands you need to configure a Windows Server Core and install SQL Server on it

Configure Windows Server Core with Sconfig.cmd

Create a Standalone R Server from the Command Line

T-SQL: How to Sort a Column that Contains Character-Separated Numbers

Adaptive query processing in SQL Server 2017

What is the SSRS web portal?

Model many-to-many relationships using SQL Server Graph Database

SQL Server Machine Learning Tutorials

Using the FORCESEEK Table Hint

Enable AlwaysOn Availability Groups on a Windows Server Core

Configure remote access of SQL Server on Windows Server Core

Upgrade SQL Server 2016 to Service Pack 1 faced with Exit code (Decimal): -2068380094

Event ID 129 Reset to device, \Device\RaidPort0, was issued on Database Server

 

2015

T-SQL: Improve the Performance for LIKE Wildcard by Changing the Collation

TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

TechNet Wiki International Summit 2015

Webinar: Error Handling in SQL Server

T-SQL: Delete All Rows from a Table except Top (N) Rows

T-SQL: Error Handling for CHECK Constraints

 

2014

Negative Effects of Query Designer

Stored Procedure string parameter accepts default value without quotes

 

2013

T-SQL: Simplified CASE expression

SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

SQL SERVER BACKUP Database Permission

BULK INSERT multiple Files in SQL SERVER Express

INFORMATION_SCHEMA.ROUTINE_COLUMNS

INFORMATION_SCHEMA.COLUMN_PRIVILEGES

COLUMN_DOMAIN_USAGE

REFERENTIAL_CONSTRAINTS

CHECK_CONSTRAINTS

COLUMNS

Parameter-driven ASC/DESC Sort (CASE in ORDER BY)

TABLES

Find all columns with non-default collation

Microsoft SQL Server Best Practices

 

2012

List all objects that have Trigger

Dynamic SQL and Object Dependency

 

2011

Column-level change tracking

 

2010

TRANCOUNT

SCHEMABINDING

Remove duplicate records in two or more columns

Remove duplicate records in a column

SELECT INTO

Disable windows authentication in SQL Server

SET QUOTED_IDENTIFIER ON

CHECKDB

ANSI_NULLS

Beginning SQL Server 2005 for Developers from Novice to Professional

SQL Server Keyboard Shortcuts

Trigger Usages

Collation

Shrink Database

SET DATABESE RECOVERY MODEL

Delete duplicate rows in SQL Server

Determine SQL Server Table Size

How to identify Installed SQL Server version and edition

Free SQL Server buffer cache

Select distinct row number

SQL Server 2008 Query Performance Tuning Distilled

SQL Server 2005: ‘Cannot connect to WMI provider’

SQL SERVER counter via query

Count (*) vs Count (1) vs Count (column)

Saving changes not permitted

Cannot drop database because it is currently in use.

Microsoft SQL Server 2008: T-SQL Fundamentals

How to identify duplicate records in sql server

sql 2005 Setup failed to obtain sys account info for the ASPNET account

 

Advertisements