Marking FK Constraints NOT FOR REPLICATION
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,747 reads
Blog Posts
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,912 reads
Re-blog – July 22-July 28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-29
1,516 reads
Roundup for Un-SQL Friday #005: Bad Interviews
It’s time for the Un-SQL Friday #005 roundup!
From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...
2011-07-29
1,773 reads
SQL Azure – simple description, part I.
I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...
2011-07-29
1,769 reads
SQL Server Hardware Book News and Reviews
Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...
2011-07-29
1,484 reads
Thank you PASS Community
This has been a great week for me. I had a lot of new faces come out for the Columbus...
2011-07-29
1,517 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head...
2011-07-28
1,990 reads
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can...
2011-07-28
4 reads
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,180 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
Kantor BCA KCP Tamim Telp/wa 085169998803
Telp/wa 085169998803 Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa...
Cara buka blokir bank jago terblokir
Anda bisa menghubungi WhatsApp Layanan Jago di nomor resmi (+628132244602 / 08217142959) atau melalui...
BCA KCP Kas Narogong TLP/WA 08216366654
Jl. San Francisco Jl. Raya Narogong No.6 & 7, Limus Nunggal, Kec. Cileungsi, Kabupaten...
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