For Hire: Data Analytics/Business Intelligence Expert
Data Analytics/Business Intelligence Expert Strengths: Passion, great with people, loves to learn and teach Weaknesses: Chocolate, fast cars, death Inquire...
2017-08-07
492 reads
TheSqlPro.com - Ayman El-Ghazali
SQL Server 2016: A Comprehensive Introduction – Arabic
It has been over a year since I have blogged, I know… that’s a long time! I have not retired,...
2017-04-26
349 reads
PolyBase: I now Pronounce you SQL and Hadoop
Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called...
2016-04-27
1,030 reads
SQL Server 2016: What’s the best new feature?
With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about...
2016-04-28 (first published: 2016-04-19)
4,339 reads
Get valuable Virtual Log File (VLF) information for all your databases log files
I had this problem where I needed to gather Transaction Log information on multiple databases and check for valuable statistics on...
2015-11-09 (first published: 2015-11-02)
2,030 reads
SQL 2016 Row-Level Security Demo: Users with various clearance levels
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,287 reads
Another Career Podcast – Working at Microsoft
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
495 reads
Podcast about my career and the SQL Server Community with Chris Bell
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
665 reads
Working at Microsoft – A Year in Reflection
Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing...
2015-06-24
679 reads
SQL Server 2014 BI ???? ??????? ????? ??
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014...
2015-03-29
1,005 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers