Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Kenneth Fisher

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

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,670 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,600 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,053 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,978 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,106 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,492 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,687 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,626 reads
   Items 1 to 8 of 8