sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,520 reads
Kenneth Fisher
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...
2016-12-26
474 reads
sp_helptext vs object_definition()
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,805 reads
:OUT :OUT darn results!
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...
2016-12-19
456 reads
An interview with me
The other day I received an email asking for some help with a school project. Would I please answer some...
2016-12-15
454 reads
DBA Myths: You can only restore one differential backup
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
The basic steps...
2016-12-13
469 reads
Fixing Data Migration Assistant timeouts
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the...
2016-12-08
757 reads
TSQL Tuesday #85 Invite – Backup and Recovery
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2016-12-06
550 reads
Easy to read CHECKDB
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...
2016-12-05 (first published: 2016-11-28)
2,478 reads
Using OUTPUT with a field list.
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...
2016-11-30
715 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU SOEKARNO HATTA TLP/WA 083800209966
Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
BCA KCP TAMIM TLP/WA 083800209966
Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat 40181
BCA KCU BANDUNG TLP/WA 083800209966
Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers