Dennis Cheung is a Senior DBA currently living in Hong Kong, he has been working with SQL server since 2000. He has supported a different version of SQL and loves to learn new technology.

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...

2015-09-30

2 reads

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

ADF: Querying JSON documents

By

In my previous blog post I talked about how to read from an XML...

Read the latest Blogs

Forums

Distributed AG DB movement

By Syed_SQLDBA

I have a DAG between On prem and Azure. We have a maintenance window...

object_name (st.objectid) returns NULL. How can I overcome/fix this?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers