Speaking at SQL Server Days 2015
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The...
2015-07-15
657 reads
Koen Verbeeck
Power BI Confusion
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get...
2015-07-14
1,630 reads
T-SQL Tuesday #68: Just say No to Defaults
It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2015-07-17 (first published: 2015-07-13)
2,418 reads
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10,...
2015-07-13
2,537 reads
Reblog: What’s the deal with Excel and SSIS?
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...
2015-07-10
1,301 reads
100th post
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of...
2015-07-10
520 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
529 reads
Hello world!
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
371 reads
How to drop a Temporal Table
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...
2015-07-03
2,740 reads
Doing a Full Outer Join in Power Query
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,690 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers