This document describes the process to provision a SQL Azure server manually. While it is expected that most servers will be provisioned using automation, DBA's must have the skills and know the process to perform the same provisioning manually.
Steve Jones has a story about what it's like to work with, and without, Version Control Systems.
Of course it seems a great idea to have your application on all the main mobile platforms as well as on the desktop. However, as Arkadiusz Pachucy knows all too well, this can ultimately leave you with a full-scale maintenance nightmare. In this article he looks at whether technologies like PhoneGap/Cordova or Adobe Air could be the perfect compromise - and if so, what frameworks to use.
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2015 and DNX Microsoft have stepped up to provide everything you need to code multi-platform apps straight out of the box. Clive Tong introduces this new .NET technology.
Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.
SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active query, giving a fantastic opportunity for troubleshooting and debugging.
Putting together a portfolio allows you the chance to showcase what you're good at doing. Steve Jones thinks this might be a good thing for technical people.
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...
BCA KCP Pejaten Telpon/WA:0821•3111•185 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20...
Untuk menutup kartu kredit Bank UOB, Anda dapat mengh??bungi UOBCall melalui Whats?????? (62 0882-201^14008):...
Jl. Bung Tomo, RT.001/RW.01, Baqa, Kec. Samarinda Seberang, Kota Samarinda, Kalimantan Timur 75132
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