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

Guest Columnist: Kenneth Fisher

SQLServerCentral.com profile

   Items 1 to 20 of 22    Older >>
 

Stairway to AlwaysOn Crossword

This crossword puzzle is based on the contents of the Stairway to AlwaysOn.  Read more...
By Kenneth Fisher 2018/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Stairway to Advanced T-SQL Crossword

This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.  Read more...
By Kenneth Fisher 2018/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

Fixing system database corruption with setup.exe

Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.  Read more...
By Kenneth Fisher 2018/04/17 | Source: SQLServerCentral.com | Category: database corruption
Rating: |  Discuss |   Briefcase | 710 reads

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.  Read more...
By Kenneth Fisher 2018/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,807 reads

A General SQL Server Crossword

Crossword puzzle based on terms from SQL Server.  Read more...
By Kenneth Fisher 2018/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 96 reads

Hint Word Search

This is a word search for most (but not all) of the hints available in T-SQL.  Read more...
By Kenneth Fisher 2018/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

SQL Crossword - Best Practices

This crossword tests your knowledge of SQL Server best practices.  Read more...
By Kenneth Fisher 2018/01/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 89 reads

DMO Word Scramble

A Database Management Object word scramble for you to enjoy.  Read more...
By Kenneth Fisher 2017/11/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

The SQL Server Crossword

Crossword puzzle focusing on SQL Servers  Read more...
By Kenneth Fisher 2017/11/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 196 reads

HA HA HA

Crossword puzzle focusing on high availability  Read more...
By Kenneth Fisher 2017/10/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

Delightful Database Diversion

A SQL Server Crossword puzzle.  Read more...
By Kenneth Fisher 2017/09/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

SQL Security Crossword

Crossword puzzle focusing on SQL Server Security  Read more...
By Kenneth Fisher 2017/09/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 125 reads

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 | 322 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 | 244 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,779 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,619 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,060 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,997 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,131 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,506 reads
   Items 1 to 20 of 22    Older >>