Setting Up a Productive Work Environment – #TAPtips
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,829 reads
Marc Beacom
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
193 reads
Hiring Productive Employees – #TAPtips
Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...
2017-01-31
629 reads
A New Year, A New Company and A New DenverSQL Chapter
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
632 reads
Team Collaboration with Microsoft OneNote – #TAPtips
I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped....
2017-01-17
389 reads
Increased Productivity with the Pomodoro Technique – TAPtips
Today's TAPtips is about Increased Productivity with the Pomodoro Technique. Have you tried the Pomodoro Technique? If so, what were...
2017-01-10
263 reads
Launching #TAPtips – Valuable Tips from Decades of Practice
Launching #TAPtips Blog Posts While forming Datalere, Carlos and I wanted to continue with our contributions to the Denver, Colorado...
2017-01-03
189 reads
DawaBI Merges with Quanta Intelligence to Broaden and Deepen our Service Offering
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
582 reads
PASS SQL Saturday Events: December 2014
DateEventDecember 6 SQLSaturday #359 – Istanbul 2014December 6 SQLSaturday #351 – Lima 2014December 6 SQLSaturday #347 – Washington DC 2014December 13 SQLSaturday #356...
2014-11-15
555 reads
5 things to know about Databricks
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
19 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;