SQL Bits is only two weeks away! Join us for the free community day on July 19th, there is also a paid-for pre-conference day on July 17, as well as a paid-for special training day on July 18. There are a whole host of great speakers, including Grant Fritchey, Steve Jones, and David Atkinson (and Brent Ozar, and Benjamin Nevarez, and Karen Lopez...you get the idea). Register while space is available.
2014-07-03
5,147 reads
There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.
2014-07-03
9,666 reads
Phil Factor fluffs the feathers of the shared sandbox model of development.
2014-07-02
139 reads
Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free. How can the database developer support the rapid development and delivery of features in an application? Versioning, branching and merging is part of the solution, but what about the rest of the solution?
2014-07-02
2,945 reads
Here is a short How To article on querying for permissions in a SQL Server database
2014-07-01
12,121 reads
2014-07-01
8,444 reads
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
2014-07-01
3,659 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,722 reads
It's Developer Week in Nuremberg July 14-17. There are a couple of great speakers at this event, like Constantin Small and Sascha Dittmann. Register while space is available
2014-06-30
2,023 reads
NEO4J, the graph database, can be used to provide answers that are very tricky for relational databases, including providing diagrams to show how SQL tables relate to each other, and the shortest chain of relationships between two tables, as David Poole demonstrates
2014-06-30
3,128 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Telp/WA.0821°3111°179 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet...
Solo Center Point, Ruko No. A11 & A12, Sondakan, Kec. Laweyan, Kota Surakarta, Jawa...
Jl. Utara Pasar Besar Utara No.1, Sudiroprajan, Kec. Ps. Kliwon, Kota Surakarta, Jawa Tengah...
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