SQL Server Community Activities under Surat User Group
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
342 reads
Hemantgiri
- Interests: Reading,Writing,Painting
- Twitter: @https://twitter.com/hemantgirig
- Website: https://www.sqlservercitation.com
- LinkedIn: https://www.linkedin.com/in/hemantgirisgoswami/
Blog Roll - List of blog post and script contribution
Greetings of the day!!
I am getting frequent emails with questions why I do not write as often I used to...
2016-01-11
497 reads
SQL Server GEEKS Annual summit 2015
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...
2015-08-02
681 reads
SSAS– Resolving target machine actively refused
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....
2013-11-08
965 reads
SQL Server–Security Risk Assessment PMP Way
Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project...
2013-11-02
1,146 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
971 reads
Not so good news for MCM Aspirants
Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification,...
2013-09-05
729 reads
SSRS – Download all RDL files from Report Server in one go.
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-07
1,240 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,867 reads
SQL Server – Generate Calendar using TSQL
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-09
1,150 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers