SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Kenneth Fisher

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

SQL Crossword #2 SELECT Keywords

Crossword Puzzle on SELECT Keywords  Read more...
By Kenneth Fisher 2017/08/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 250 reads

SQL Crossword #1

Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.  Read more...
By Kenneth Fisher 2017/07/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 220 reads

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.  Read more...
By Kenneth Fisher 2016/11/17 | Source: SQLServerCentral.com | Category: output
Rating: |  Discuss |   Briefcase | 2,762 reads

Constant Data Types

Data types are an important part of how tables and variables work. Did you know that constants have databases too?  Read more...
By Kenneth Fisher 2016/10/03 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,617 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: SQLServerCentral.com | Category: dac
Rating: |  Discuss |   Briefcase | 3,058 reads

Kill SPID (SQL Spackle)

How to find and kill a runaway or blocking session.  Read more...
By Kenneth Fisher 2014/07/01 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,981 reads

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.  Read more...
By Kenneth Fisher 2014/07/11 (first published: 2013/01/03) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,115 reads

Fun with Outer Joins

Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.  Read more...
By Kenneth Fisher 2014/01/17 (first published: 2012/09/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 22,501 reads

SQL Server 2008 R2 Data Types

A list of SQL Server 2008 R2 Data Types and Storage Sizes.  Read more...
By Kenneth Fisher 2012/02/22 | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 3,694 reads

A brief explanation and solution for the Double Hop problem

What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?  Read more...
By Kenneth Fisher 2011/12/09 | Source: SQLServerCentral.com | Category: double hop
Rating: |  Discuss |   Briefcase | 9,684 reads
   Items 1 to 10 of 10