SQLStudies

GO

by Kenneth Fisher

SQLStudies

Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...

2013-05-06

916 reads

Comparing an inner join vs a subquery

by Kenneth Fisher

SQLStudies

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...

2013-05-08 (first published: 2013-05-03)

5,918 reads

Well I finally passed the 70-451

by Kenneth Fisher

SQLStudies

So I am now an MCITP Database Developer for SQL 2008. This is a big milestone for me. A few...

2013-05-01

808 reads

INFORMATION_SCHEMA the un-sung system views

by Kenneth Fisher

SQLStudies

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....

2013-04-29

2,605 reads

How do I tell the stored procedure name from inside the stored procedure?

by Kenneth Fisher

SQLStudies

I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...

2013-04-24

790 reads

Who writes your documentation?

by Kenneth Fisher

SQLStudies

I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...

2013-04-22

812 reads

Calculating the length of a string (Len vs DataLength)

by Kenneth Fisher

SQLStudies

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...

2013-04-15

1,391 reads

How do I use a variable in an IN clause?

by Kenneth Fisher

SQLStudies

I see this question in one form or another a lot. I’ve seen this or something like it probably half...

2013-04-08

783 reads

UNPIVOT a table using CROSS APPLY

by Kenneth Fisher

SQLStudies

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...

2013-04-12 (first published: 2013-04-01)

4,187 reads

How do I move a SQL login from one server to another without the password?

by Kenneth Fisher

SQLStudies

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...

2013-04-03 (first published: 2013-03-25)

9,579 reads

SQLStudies

GO

Comparing an inner join vs a subquery

Well I finally passed the 70-451

INFORMATION_SCHEMA the un-sung system views

How do I tell the stored procedure name from inside the stored procedure?

Who writes your documentation?

Calculating the length of a string (Len vs DataLength)

How do I use a variable in an IN clause?

UNPIVOT a table using CROSS APPLY

How do I move a SQL login from one server to another without the password?

Blogs

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

Forums

PowerBI Question - Data Sources

SQL Server Certificates

Connect an Azure Function to Azure SQL database Using a Managed Identity

Question of the Day

SQL Server Certificates