One of the primary advantages of Platform-as-a-Service solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.
The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.
Voting is now open for the Tribal Awards. Vote for one of the 5 finalists in each category to win a fabulous* prize.
This article will discuss a case study of utilizing a SSIS package to export a table that has columns with data type varchar(mx) and text to an Excel file.
Kathi Kellenberger demonstrates how to start adding visual flair to your SSRS reports, using its impressive set of visual controls, ranging from basic charts to gauges, indicators, sparklines, and maps.
When undisciplined users access your search forms, you can control their behavior and limit the results they're presented with in various ways.
Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.
Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.
Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.
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...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
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