Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
388 reads
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
388 reads
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,210 reads
Update: Just getting started with Power BI? You can download the Power BI Report File for this KPI Report. Please...
2016-02-16
2,165 reads
Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for...
2016-02-11 (first published: 2016-02-02)
2,973 reads
Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get...
2015-09-01 (first published: 2015-08-19)
2,625 reads
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation...
2015-08-27
809 reads
Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to...
2015-08-13
1,219 reads
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,170 reads
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...
2015-03-26 (first published: 2015-03-19)
6,302 reads
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
602 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Hi when i think of server hops , i think of how kerberos assists...
Comments posted to this topic are about the item Can/Can't Do/Don't
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers