Certifying Schools
Schools don't necessarily teach people how to code, but they could do a better job.
Free Database Unit-Testing Framework for SQL Server
Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio.
Simple SQL: Handling Location Datatypes
How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains.
We Need DevOps for Performance
CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.
What to Do When You Get a “Cache is Out of Date” Error Message
Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
SQL Saturday statistics – Web Scraping with R and SQL Server
Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.
Bones of SQL - The Calendar Table
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Forums
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kontak resmi BCA KCU BUKIT BARISAN Telp:0817866887
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
Alamat kontak resmi BCA KCU BUKITTINGGI Telp:0817866887
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers