Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
Clustered Columnstore Index in Azure SQL Database
Columnstore index is the preferred technology to run analytics queries in Azure SQL Databases. We recently announced general availability of In-Memory technologies for all Premium databases. Similar to In-Memory OLTP, the columnstore index technology is not available in databases in the Standard and Basic pricing tiers today.
R is better than M for difficult data wrangling tasks in Power BI
Yep, I said it! In most cases I believe that it is true. R has been around for over 20 years so it is much more mature than M. It has close to 10K packages many of which are meant just for data wrangling. If you don’t agree with me now I think by the end of this post it’s a good chance that you will think otherwise. This blog is written for those with little exposure to R so I will keep it simple. I am going to start with a very basic file import example and I will end with a somewhat simple but slick multiple file import example.
Cleaning Up SSISDB
I really appreciate what MS has done w/ the SSIS Catalog. We have built-in logging at a level that wasn’t possible in prior releases, but that comes at a cost. The default retention is pretty high (365 days) and MS chose to handle cleanup using cascading deletes. This sort of coding makes life easier for the developers, but almost always performs poorly.
Power Query, R is here to help you!
Microsoft Power BI has an embedded ETL tool called Power Query that is great for basic data transformation. You can handle many data transformation tasks with just a few clicks. But when your data transformation tasks become complex you often have to result to writing custom M code. M is a relatively new programming language and is not that intuitive. The community of M developers is small so finding help is limited in comparison to finding help with other programming languages.
INTRODUCTION TO BACKUP ENCRYPTION IN SQL SERVER
One of the most essential need of every Database Administrator is a backup file. This file acts as a life savior when any disaster occurs either on machine or on the server. When talking about SQL server, such backup files are very much essential in order to have a duplicate copy of the server data.
Format measures as dates in Power BI
If you want to format a measure as date in Power BI, you need an expression returning a date/time data type. This is different from what you can do in Power Pivot and in SSAS Tabular, where you can format any numeric expression using a date and/or time format, and the conversion is implicitly done to perform such a visualization.
Broken References in the SSIS Catalog
It’s possible to create a broken reference in the SSIS Catalog. What’s a “broken reference?” Let’s begin by explaining SSIS Catalog References. I wrote a lengthy explanation of SSIS Catalog References and Environments in SSIS Catalog Environments – Step 20 of the Stairway to Integration Services at SQL Server Central .
What’s new in Mobile Reports in SQL Server 2016 SP1
In our last post around SQL Server 2016 SP1, we promised to do a post about some enhancements we’ve made to mobile reports in the latest release. We’ll highlight two major items we’ve updated and also provide the full change list of updates and fixes for mobile reports that many of you have asked for to date.
Scaling securely at the frontend
High volume web sites that offload scale to the frontend using techniques like leveraging edge caching with a partner content delivery network (CDN) see many benefits, including better performance and a much simpler, more resilient, and potentially cheaper infrastructure to maintain.