Subtle Errors When Using Dates-Part 2
It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...
2011-07-12
574 reads
Blog Posts
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
616 reads
Which database is using all my CPU #2
A few weeks back we wrote about a query to tell you which database is using up most CPU time....
2011-07-12
1,484 reads
2011 SQL Rally Evaluations - Reporting Services Boot Camp
I wrote this early in June, but lost it in my blog pile again and just found it…
First and foremost,...
2011-07-11
412 reads
5 Ways to Be a More Effective DBA Today
Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...
2011-07-11
1,443 reads
Can you delete from a view?
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,648 reads
Denali’s Skeletons in the closet (and workaround), Part II
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
616 reads
Environment variable in SSIS not being recognized
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
2,093 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more...
2011-07-11
4 reads
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that...
2011-07-11
1,060 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 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....
BCA KCP Alaydrus TLP/WA 08216977701
Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
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