Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
381 reads
Koen Verbeeck
CALCULATE and FILTER: A Love Story?
There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going...
2017-09-13 (first published: 2017-09-06)
2,014 reads
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...
2017-08-23
1,130 reads
Fix for Blurry SSMS in Windows 10
I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a...
2017-08-14
7,619 reads
Two Small Tips for Working with Azure
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up...
2017-08-10
501 reads
SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local...
2017-08-08
3,508 reads
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
287 reads
The times they are ae-changing
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...
2017-08-03
373 reads
Microsoft Professional Program in Data Science – Continued
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...
2017-06-27 (first published: 2017-06-19)
2,858 reads
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,591 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
BCA KCU BANYUWANGI | Tlp/Wa:0818751777
Tlp/Wa_Cs:0818-751-777 Jl. Jenderal Ahmad Yani No.24-26, Panderejo, Kec. Banyuwangi, Kabupaten Banyuwangi, Jawa Timur 68416
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers