How Much Hospitals Charge For The Same Type Of Cases?
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,209 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
How to Install Microsoft R Server for Windows
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,945 reads
Getting Started With Power BI Desktop: Simple Visualization
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation...
2015-08-27
805 reads
Getting Started With Power BI Desktop: Getting Data
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,620 reads
Getting Started With Power BI Desktop: Installation
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,215 reads
Finding gaps or missing dates in a date range using TSQL
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
15,682 reads
How to resequence column based on numeric prefix using TSQL
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,292 reads
Getting back to basics
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
600 reads
Executing scripts on multiple servers the easy way
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,356 reads
Failed To Lock Virtual Machine’s Configuration
[Updated]
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable...
2014-05-23
14,756 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers