Despite my misgivings about the fall from favor of technology books, I was heartened to hear from the developers at Red Gate that the classic books on the art of programming are still important to them. What are the equivalent books for DBAs?
Learn how to get column names, data types, indexes, foreign keys, triggers and more in one snappy overview from new author Jacques Bosch
Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.
To tackle performance problems with applications, first use SQL Profiler to find the queries that constitute a typical workload: From the trace, spot the queries or stored procedures that are having the most impact. Then it's down to examining the execution plans and query statistics. You then see what effects you've had and maybe repeat the process. Gail explains all, in a two-part article.
To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
This Friday's poll looks at your productivity. Is there some technology that has really helped you do your job better?
When moving data in related tables between databases, the order sometimes matters. New author Glen Cooper brings us an article that discusses the issues in maintaining referential integrity.
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...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Depati Payung Negara Ruko No.2, RT.025/RW.005, Pagar Dewa, Kec. Selebar, Kota Bengkulu, Bengkulu...
BCA KCP Tebet Timur Telpon/wa:0813.7887.595.Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet...
BCA KCP Pusat Pasar Minggu HUB.Tlpn.0821•3111•185 Jl. Lenteng Agung Raya No.26 EF, Ps. Minggu,...
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