More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
Stop and Start Services - SQL School Video
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
Creating and managing Analysis Services partitions
S partitions from the ground up, with advice on binding, merging, and selecting partition data.
Identify last statement run for a specific SQL Server session
The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.
More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
Take a Seat
Bill Nicolich raises questions about the chairs we sit in all day as technology professionals.
Trouble printing out long VARCHAR(MAX) strings?
Ever try to print out a long VARCHAR(MAX)/NVARCHAR(MAX) string, only to find that it's truncated at 8,000/4,000 characters? How do you get around this? New author Sam Bendayan shows us how.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Mal Ciputra HUB/CS (08218573837)
Mal Ciputra, Jl. Arteri Jl. Letjen S. Parman No.28 LG II No. 24, Slipi,...
BCA KCU TAMAN DUTA MAS HUB/WA (08218573837)
ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, Jelambar Baru, Kec. Grogol petamburan,...
BCA KCP Jalan Panjang HUB/WA (08218573837)
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
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