If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.
2015-10-05
6,132 reads
The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.
2015-10-05
2,714 reads
SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.
2015-10-02 (first published: 2013-08-29)
20,291 reads
Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.
2015-10-02
7,474 reads
In this fourth installment, Arshad Ali demonstrates creating filters, publishing dashboards to the Datazen server and creating drill-through dashboards.
2015-10-01
3,983 reads
One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet access.
2015-09-30
3,123 reads
2015-09-29
3,932 reads
Links and references to understand what the Query Store is in SQL Server 2016.
2015-09-28
2,823 reads
Glenn Berry explains how you can do some simple analysis to help decide the exact processor to should choose for a new database server, taking into consideration workload and budget constraints.
2015-09-28
2,452 reads
2015-09-25 (first published: 2013-04-11)
11,997 reads
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Creating a Simple and Flexible...
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers