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,642 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
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,232 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
16,361 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,315 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
615 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,392 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,769 reads
Virtual SQL Playground Adventure: Building The Virtual Environment
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual...
2014-03-14 (first published: 2014-03-03)
3,678 reads
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,154 reads
My First Book: SQL Server 2012 Reporting Services Blueprints
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,306 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers