How to move the Master database
The catch to moving the Master database is that you must also move the Resource database. Microsoft states that the...
2011-07-11
1,372 reads
Blog Posts
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,135 reads
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft – Readying on “Hadoop”
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...
2011-07-11
1,100 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in...
2011-07-11
4 reads
Meme Monday – Horoscope
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement....
2011-07-11
492 reads
Meme Monday in July - PearlKnows All
It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11. Started by Twitter|@SQLRockstar, Thomas LaRock, today’s...
2011-07-11
1,249 reads
Meme Monday SQLstrology – Table Valued Zodiac Function
It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...
2011-07-11
951 reads
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter
It’s time for July’s Meme Monday post, and...
2011-07-11
2,499 reads
Misleading Error 1475 While Setting Up Database Mirroring
Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->
I was doing some practice work yesterday testing out some mirroring...
2011-07-11
1,152 reads
Select random records using TABLESAMPLE clause
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,388 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
Cara buka blokir bws mobile salah pin 3 kali
By Buka blokir bws mobile Bank Woori Saudara
Cara membuka blokir BWS Mobile yang terblokir dapat dilakukan dengan mereset password/PIN melalui aplikasi....
BCA KCU PASAR BARU TLP/CS 08216977701
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Cara buka blokir bws mobile salah pin 3 kali
By Buka blokir bws mobile Bank Woori Saudara
Cara membuka blokir BWS Mobile yang terblokir dapat dilakukan dengan mereset password/PIN melalui aplikasi....
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