You Don't Know Enough
We never know enough ourselves to be sure that we have completely thought through all the scenarios or holes in our logic. This is why it makes sense for us to have a group that spends time looking for problems.
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
SQL Saturday #73 - Orange County, CA
A free one day training event on Apr 9, 2011 in Huntington Beach, CA. Come learn about SQL Server with a number of SQL Server experts.
Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
ERDDUG - Introduction to Indexes with SQL Server MVP Gail Shaw
If you are in South Africa near East Rand, join the East Rand Developer and DBA group on April 9 for a presentation by SQL Server expert, MVP, and longtime SQLServerCentral author, Gail Shaw.
How To Fix Connect
Today Steve Jones asks for your ideas on Microsoft's Connect. It's a good way to submit bugs and suggestions, but it seems to suffer from a scale problem. What do you think would help?
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
SQL Saturday - #74 - Jacksonville
Come attend this free one day training event in Jacksonville, FL on Apr 30, 2011. Meet a number of SQL Server experts and learn about SQL Server at the University of North Florida.
TOP 10 SQL Server Requests That Should Be Automated
What DBA wouldn't want to make their job a little easier?
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 KCP Cijerah TLP/WA 08218573837
Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20, Cibuntu,...
BCA KCP Pondok Timur Lyn Cs 083835110341
Jl. Pd. Timur Indah Kompleks Perumahan Taman Nirwana No.8, RT.005/RW.019, Pengasinan, Kec. Rawalumbu, Kota...
BCA KCP Warung Buncit tlpn/wa: (0831)10703017
BCA KCP Warung Buncit tlpn/wa: (0831)10703017 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, Tegal...
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