Verifying Object Exists and Dropping Object with One Statement
For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
SQL Is Always Going to be Popular
Steve thinks that learning more about the SQL language is always a good career investment.
SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7
In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.
Never Create Columns with ANSI_PADDING set to OFF
There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.
Securely Manage Database Credentials Using Visual Studio Manage User Secrets
In this tip we cover how to manage application secrets in a development environment to securely store database credentials.
Build the VCS Habit
Steve thinks version control is a fundamental and critical part of working in technology.
Fetch Web Data in Power BI
Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]
Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints
Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.
What’s in that database? Getting information about routines
There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.
Combining many crossing intervals
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
BCA KCP Kas Plaza Kenari Mas HUB/WA (08216977701)
Plaza Kenari Mas, Lt 4, Blok K37/38, Jl. Kramat Raya No.101, RT.18/RW.1, Paseban, Senen,...
BCA KCP PRJ Kemayoran HUB/WA (08216977701)
VR4W+7F8, JIEXPO, RW.10, Pademangan Tim., Kec. Pademangan, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Mangga Dua Square HUB/WA (08216977701)
Mangga Dua Square, Komp. Ruko, Jl. Gn. Sahari Blok G No. 8-9, Daerah Khusus...
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