Here at Database Weekly, 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. Here, we have an assortment of the latest articles from selected sources.

At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.

Latest Articles


SQLServerCentral - Editorials
Measuring the performance of systems isn't always just CPU, RAM, and Disk IO. Today Steve Jones looks at business based metrics.
00:00 09-Dec-2016
SQLServerCentral - Main Articles
Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server ...
00:00 09-Dec-2016
SQLServerCentral - Main Articles
HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible ...
00:00 09-Dec-2016
SQLServerCentral - Main Articles
When something's wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem ...
00:00 09-Dec-2016
SQLServerCentral - Blogs
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about ...
21:00 08-Dec-2016
SQLServerCentral - Questions
I am relatively new to creating slowly changing dimensions in my SSIS packages. So I beg your indulgence. After adding my OLE DB source, I then added ...
20:21 08-Dec-2016
SQLServerCentral - Questions
Hello! I am a Support technician for an Application using a 2008 SQL Express database and the our client app-installations occasionally lose connection ...
17:54 08-Dec-2016
DatabaseWeekly - Newsletter
I've updated the code-base to Apache Zeppelin 0.6.2 and I've also finished a first simple-but-working support to autocomplete (you can activate it using ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
SQL Server 2016 SP1 adds a significant new performance feature, the ability to accelerate transaction ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
I have written a lot about Power Query M scripting language, and how to create custom functions with that. With recent updates of Power BI Desktop, creating ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
Recently, I was working on a backups dashboard in PowerBI to do some analytics on the health of our database backups across the board. We set out to understand ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
A couple of days ago in Washington DC I presented the final 2016 delivery of my Tuning Your Biggest Queries seminar. The class went really well (at least ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
I was hanging out with Miguel de Icaza in New York a few weeks ago and he was sharing with me his ongoing love affair with a NoSQL Database called Azure ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
When it comes to troubleshooting, the more you know the better troubleshooter you are (in my option). ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
High volume web sites that offload scale to the frontend using techniques like leveraging edge caching with a partner content delivery network (CDN) see ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
Join Kent Bradshaw and me for three free webinars about the SSIS Catalog! SSIS Academy: Using the SSIS Catalog is Tuesday - Thursday, 27-29 Dec 2016.
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
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 ...
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
Short answer: the SQL Server optimizer will know that the table was truncated, but statistics might not update when you expect.
17:52 08-Dec-2016
DatabaseWeekly - Newsletter
Columnstore index is the preferred technology to run analytics queries in Azure SQL Databases. We recently announced general availability of In-Memory ...
16:52 08-Dec-2016
DatabaseWeekly - Newsletter
Back in March we announced the availability of per-operator level performance stats for Query Processing (exposed in Showplan XML) with SQL Server 2014 ...
16:52 08-Dec-2016
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a quick post on checking ...
16:21 08-Dec-2016
SQLServerCentral - Blogs
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the things I like best about it is that ...
14:00 08-Dec-2016
DatabaseWeekly - Newsletter
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about ...
10:52 08-Dec-2016
SQLServerCentral - Blogs
As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike ...
05:45 08-Dec-2016
SQLServerCentral - Editorials
It seems that everyone has a different idea on how to interview people. Today Steve Jones looks at the technique of having someone improve some code in ...
00:00 08-Dec-2016
SQLServerCentral - Main Articles
This is a tutorial to download multiple files from internet using the SSIS Script Task.
00:00 08-Dec-2016
SQLServerCentral - Main Articles
After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.
00:00 08-Dec-2016
SQLServerCentral - Main Articles
Learn how to use Redgate's DLM solution to improve your database change management process in our free webinar on December 13th. Microsoft Data Platform ...
00:00 08-Dec-2016
SQLServerCentral - Questions
I couldn't work with linked server as administrator didn't let me to do that. Therefore, I've imported ...
23:20 07-Dec-2016
SQLServerCentral - Questions
Nagios has detected a problem with this service. Notification Type: PROBLEM Service: MSSQL Database Pages Host: serverx.domain..ocal Address: xxx.xxx.xx.xxx State: ...
19:06 07-Dec-2016
SQLServerCentral - Blogs
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we ...
18:56 07-Dec-2016
SQLServerCentral - Blogs
Next week is the 2016 version of SQL in the City and you can register now to attend. It's free and doesn't require any travel. You can watch the event ...
15:08 07-Dec-2016
SQLServerCentral - Blogs
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers. This post ...
12:16 07-Dec-2016