Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
886 reads
Vinay Thakur
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
830 reads
Sql Server 2014…….What!!!
Yes, its true. Microsoft vice president has announce that new version of sql server 2014, will release on 2014… do...
2013-06-17
1,066 reads
Sql server 2012 links
Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/
2013-05-21
1,078 reads
Good Bye 2012 and welcome 2013
Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company...
2013-01-19
732 reads
Denali –Memory : Memory Error Recovery in SQL Server 2012
Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a...
2012-10-25
870 reads
DBCC Cleaning CACHE – Memory
DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...
2012-09-06
932 reads
Error: ACCESS DENIED on installation
Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....
2012-09-05
897 reads
Normalization & Denormalization
Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should...
2012-09-04
1,346 reads
RAID (Redundant Array Independent Disk)
RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...
2012-08-17
909 reads
Blogs
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...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Kelapa Gading Raya TLP/WA 08216977701
Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp. Gading, Jkt Utara,...
BCA KCP Teluk Mas HUB/CS 08216977701
Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No. 95 G-H, Pejagalan, Kecamatan...
BCA KCP Kas Pusat Grosir Cililitan Hub/Wa 08216977701
Jl. Mayjen Sutoyo No. 76 Cililitan Kramat Jati (Lt .2 No. 641 Kota Adm,...
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