Denali – Day 4: Editions & Licensing
Denali – Day 4: Editions & Licensing
Editions:
Here is a brief edition summary of Editions available for all sql server from 2005 to...
2012-05-04
613 reads
Vinay Thakur
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
I know this should be first or second blog post when...
2012-05-03
880 reads
Denali – Day 2: AlwaysON High Availability (aka Project HADRON)
Denali – Day 2: AlwaysON High Availability (aka Project HADRON )
AlwaysON Availability Group:
is another very important achievement done by development team project...
2012-05-02
1,519 reads
Denali — Day 1: Tempdb Compatibility – Bug?
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
465 reads
Always use Configuration Manager for changing service account
When your service account is expired/disabled or is not having access than sql service could not able to start and you may...
2012-04-28
1,777 reads
Denali – Blog a Day Series : May, 2012
Denali
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...
2012-04-23
632 reads
More IMPORTANT miscellaneous info
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,272 reads
Restore fails with tail of log error
For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to...
2012-03-22
681 reads
Error 0xC0014062: Unable to complete login process due to delay in opening server connection
Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...
2012-03-14
7,278 reads
Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
526 reads
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 Iskandar Muda II Telpon/wa:0813.7887.595
BCA KCP Iskandar Muda II Telpon/wa:0813.7887.595.Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama...
BCA KCP Gudang Peluru Telpon/WA:0821•3111•185
BCA KCP Gudang Peluru Telpon/WA:0821•3111•185 Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar...
BCA KCU BENGKULU TLP/WA 08216977749
Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu 38223
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