Gartner Magic Quadrant for BI/BA and the Lone Three Leaders
History clearly confirms that good things come in threes. As far as I know this is the first time that...
2016-02-05
508 reads
Power BI Publish to Web for Anonymous Access is Here
Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web”...
2016-02-05
1,935 reads
Copying SSIS packages With DTUTIL
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new...
2016-02-15 (first published: 2016-02-05)
6,487 reads
Using Custom File Delimiters in SSIS
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field...
2016-02-16 (first published: 2016-02-05)
2,700 reads
Its been a busy start to the year
Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses...
2016-02-05
493 reads
PASS Summit 2016 – call for Speakers…
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
798 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
561 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
555 reads
Columnstore Indexes – part 76 (“Compression Delay”)
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
794 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
498 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers