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 - Questions
Hi...The same being repeated in other select statements as well and later on unioning them. is there any other best way that can be cut short this code select ...
22:28 17-Jan-2017
SQLServerCentral - Questions
Hi All, I started working on new data warehouse project by using SQL Server(SSIS,SSAS) Does anyone have sample server architecture design document for ...
21:26 17-Jan-2017
SQLServerCentral - Blogs
This just in from the Reporting Services product team: "Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available"  ...
19:54 17-Jan-2017
DatabaseWeekly - Newsletter
How to a) find out how much physical memory the server has b) calculate what the Maximum Server Memory (MB) should be, then c) call sp_configure to alter ...
19:41 17-Jan-2017
DatabaseWeekly - Newsletter
Did you know from SQL 2016 you have the ability to work with wait stats at a session level?
19:41 17-Jan-2017
DatabaseWeekly - Newsletter
Brent Ozar summarizes your favorite SQL Server bugs & enhancement requests, from T-SQL Tuesday 86.
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Chris Webb explores his second-favorite feature in SSAS Tabular v.next : Detail Rows expression property for measures. It not only brings drillthrough ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Tim Ford dissects a case where a client migrated their SQL Server instances from SQL Server 2012 to SQL Server 2016, but didn't do a complete job of migrating ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Did you know, for example, that a COPY_ONLY full backup can be used as the base for a log backup but not a differential?
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Is there a truly secure messaging app? On Friday it was revealed that attackers could exploit a security vulnerability in WhatsApp to snoop on its users. ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
How to configure a firewall for SQL Server using SQL Server configuration manager.
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Fabian Pascal dissects a design that seeks to " avoid tight coupling between the tables...by storing ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Sunil Agarwal discusses how SQL Server columnstore index processes string data types.
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Having setup replication from an on-premise SQL Server instance to an Azure SQL database, Jeffrey Verheul is stopped in his tracks by a strange bug.
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Kendra Little finds an issue with how SQL Server tracks and reports on modifications to column statistics ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
SQL Server 2016 introduces BatchMode execution model for aggregates computed over a set of rows defined ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
It's a trick question, yes. Your SQL Server version matters! In this post I'll tell you how to check your version, talk about what makes up the version ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Not everyone understands just how important data is until it is gone. When disaster strikes, and you can't recover, you are likely to be shown the door.if ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow.
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Tim Ford shows how to identify logins where the assigned default database was dropped after login creation. ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Michael J Swart investigates why a doomed transaction was still trying to do work. Summary? Don't program in T-SQL. Avoid triggers. Extended events are ...
18:41 17-Jan-2017
DatabaseWeekly - Newsletter
Adam Machanic collates some useful resources from his SQL Server 2016 "Hidden Gems" talk for the GroupBy online conference.
18:41 17-Jan-2017
SQLServerCentral - Blogs
Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in a Virtual Environment. ...
18:06 17-Jan-2017
SQLServerCentral - Questions
The company have dev/stage/prod server. Stage server will refresh every week from prod server(use prod backup file restore in stage). The new stored ...
16:10 17-Jan-2017
SQLServerCentral - Blogs
Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you've worked in Microsoft BI in the past this idea is ...
16:07 17-Jan-2017
SQLServerCentral - Blogs
I got a tweet after my SQL Prompt formatting piece that said a user would be interested in upgrading from v5 if "as 'Alias'" was transformed into "'Alias' ...
15:45 17-Jan-2017
SQLServerCentral - Blogs
In this module you will learn how to use the Sankey with Labels Power BI Custom Visual.  The Sankey with Labels is a type of diagram that visualizes the ...
14:23 17-Jan-2017
SQLServerCentral - Blogs
I'll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class is being delivered in ...
12:45 17-Jan-2017
SQLServerCentral - Blogs
Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running on Linux. Fairly innocuous ...
09:16 17-Jan-2017
SQLServerCentral - Questions
HI , I need some help to add Chinese character in SQL server column which is already having SQL_Latin1_General_CP1_CI_AS collation. There is solution ...
08:49 17-Jan-2017
SQLServerCentral - Editorials
Many of our security issues come down to not patching software when there are updates available.
00:00 17-Jan-2017
SQLServerCentral - Main Articles
Using R integration for analyzing sales data in WideWorldImporters database
00:00 17-Jan-2017
SQLServerCentral - Main Articles
When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance ...
00:00 17-Jan-2017
SQLServerCentral - Questions
I have a recursive CTE that calculates projected profit for the duration of a project. I'm trying to figure out to add a corresponding month/date to each ...
21:53 16-Jan-2017
SQLServerCentral - Blogs
Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on  sys.dm_os_wait_stats ...
19:04 16-Jan-2017
SQLServerCentral - Blogs
I'm hosting a  new webinar on the DLM tools from Redgate Software and database DevOps. Tomorrow, ...
17:10 16-Jan-2017
SQLServerCentral - Questions
Can I create SSIS package using Microsoft Visual Studio 2015 Professional Version?
16:35 16-Jan-2017
SQLServerCentral - Blogs
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary ...
16:00 16-Jan-2017