Dynamic Sorting in SSRS
Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...
2017-05-19 (first published: 2011-12-26)
21,180 reads
Vinay
How many times the T-SQL inside the CTE is executed?
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2017-02-08 (first published: 2011-12-15)
11,566 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-12 (first published: 2013-08-07)
13,392 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-18 (first published: 2013-04-09)
13,246 reads
SQL Server – Generating PERMUTATIONS using T-Sql
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
890 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
1,993 reads
SQL Server # Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-18
7,055 reads
SQL Server # TSQL to Convert STRING in PROPER format
Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...
2012-10-18 (first published: 2012-10-15)
13,502 reads
SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL
Introduction
Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A...
2012-03-28
1,831 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,670 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
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?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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