Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
670 reads
Koen Verbeeck
Help me raise money for cancer research #tourneeminerale
In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be...
2017-01-19
555 reads
T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
474 reads
Clustered Columnstore Index really hates Updates
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2...
2017-01-03 (first published: 2016-12-23)
4,922 reads
Master Data Services Error – Missing Temp Directory
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...
2016-12-15
2,007 reads
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,373 reads
Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
528 reads
Calculate a semi-additive average in DAX
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...
2016-11-24
1,726 reads
SQL Server 2016 service pack 1 is here!
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why,...
2016-11-30 (first published: 2016-11-22)
2,429 reads
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my...
2016-11-21 (first published: 2016-11-15)
2,125 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers