Getting Started with Power BI: Setup (Part 1 of 3)
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-02
186 reads
This is part 1 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-02
186 reads
Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...
2017-01-31
625 reads
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
629 reads
Having a productive work environment for you and your team is important to facilitate tasks being accomplished as well as...
2017-02-03 (first published: 2017-01-25)
1,824 reads
I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped....
2017-01-17
385 reads
Today's TAPtips is about Increased Productivity with the Pomodoro Technique. Have you tried the Pomodoro Technique? If so, what were...
2017-01-10
260 reads
Launching #TAPtips Blog Posts While forming Datalere, Carlos and I wanted to continue with our contributions to the Denver, Colorado...
2017-01-03
185 reads
We’ve been working on this for a while now and I’m excited to announce the merger of Quanta Intelligence and...
2016-08-18
574 reads
DateEventDecember 6 SQLSaturday #359 – Istanbul 2014December 6 SQLSaturday #351 – Lima 2014December 6 SQLSaturday #347 – Washington DC 2014December 13 SQLSaturday #356...
2014-11-15
552 reads
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. ...
2014-11-03
12 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric...
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
This post comes off the back of my last, where I looked at issues...
I have a one database and one table in that database. This is on...
hi, i spent some time today in an existing pkg replumbing 5 flat file...
Still trying to figure out options for automating the export the result of a...
What does this code return?
SELECT ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; GOSee possible answers