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


DatabaseWeekly - Newsletter
Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
Microsoft have announced the last service pack for SQL Server 2012.
14:45 25-May-2017
DatabaseWeekly - Newsletter
SSRS provides the capability to review the scheduled reports (subscriptions) in a highly-detailed fashion. This article will dive into the source of this ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
This article presents different techniques to compute a rownumber column in DAX-based on a specific ranking, comparing slow and optimized approaches.
14:45 25-May-2017
DatabaseWeekly - Newsletter
Nonclustered indexes are awesome in SQL Server: they can get you huge performance gains. But we can't always create the perfect index for every query. ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
There will be times when you're approached by someone in a frenzy, their hair seemingly on fire. They'll go on to insist the world will come to an end ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
The GDPR takes effect on May 25, 2018 and sets a new global bar for privacy rights, security, and compliance. ...
14:45 25-May-2017
DatabaseWeekly - Newsletter
Oh, you put your database in the cloud? We're putting one through them.
13:45 25-May-2017
SQLServerCentral - Questions
Added a new column "PreInventory" to the AmazonFBAInventoryImport Table. Included the formula "SoldLast7Days*ProductsInAdvance" for that column as it ...
13:27 25-May-2017
SQLServerCentral - Blogs
Reporting Services   Over the past couple of articles I have illustrated some of the fun that can be had when dealing with the scheduling capabilities ...
12:05 25-May-2017
SQLServerCentral - Questions
Can someone help to the get the desired result with the required formulas ![alt text][1] [1]: /storage/temp/4113-desired-output.jpg **Below is my sql ...
11:14 25-May-2017
SQLServerCentral - Questions
Hello Team, For one of the application firstly we have installed SQL Server 2014 Evaluation edition. After getting MSDN Subscription we downloaded SQL ...
08:51 25-May-2017
SQLServerCentral - Questions
Hello I have taken over a 2014 SSAS Tabular cube and there isnt any descriptions on the Dimensions and Measure groups, i was looking to see if there ...
08:36 25-May-2017
SQLServerCentral - Blogs
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database file size change and who caused it. I went down the ...
00:29 25-May-2017
SQLServerCentral - Questions
Hi Team, I have some data as below. CustomerID Sports Date 1 Cricket 5/25/2017 2 ...
23:35 24-May-2017
SQLServerCentral - Editorials
We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.
23:00 24-May-2017
SQLServerCentral - Main Articles
In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.
23:00 24-May-2017
SQLServerCentral - Main Articles
A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages. ...
23:00 24-May-2017
SQLServerCentral - Main Articles
Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed ...
23:00 24-May-2017
SQLServerCentral - Questions
I had Microsoft SQL Server Express 2012 installed already. I just installed the Microsoft SQL Server Management Studio Express and tried to open my mdf ...
20:22 24-May-2017
DatabaseWeekly - Newsletter
How can I find out on which Clustered Index the most Lookup Operations have been performed?
18:45 24-May-2017
DatabaseWeekly - Newsletter
I'm a big fan of reusing Power BI datasets whenever possible to minimize redundant datasets floating around the organization. It's less maintenance, less ...
18:45 24-May-2017
DatabaseWeekly - Newsletter
Is the WannaCry incident a wakeup call for the industry? William Brewer discusses the recent ransomware attack on the NHS
18:45 24-May-2017
DatabaseWeekly - Newsletter
Patrick LeBlanc shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report.
18:45 24-May-2017
DatabaseWeekly - Newsletter
The other day I had to update some records, in Production. I'm a firm believer of using explicit transactions and double checking things before committing ...
18:45 24-May-2017
DatabaseWeekly - Newsletter
In SQL Server 2017, we can disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command. This prevents ...
18:45 24-May-2017
DatabaseWeekly - Newsletter
Erik Darling explores the side effects of relying on an old view that has scalar valued functions in it.
18:45 24-May-2017
DatabaseWeekly - Newsletter
Despite overwhelming evidence showing the harm done to the companies themselves by gender discrimination, corporations around the world persist in overlooking ...
18:45 24-May-2017
DatabaseWeekly - Newsletter
Jason Brimhall uncovers one of the sources of report scheduling information, within the ReportServer database.
18:45 24-May-2017
SQLServerCentral - Questions
I need to insert info from a table named tst_attachment into a table named attachment . In the attachment table the attachment_id needs to be retrieved ...
17:04 24-May-2017
Simple-Talk - Blogs
The WannaCry ransomware attack has highlighted a serious problem. If there is negligence in your IT strategy, you are increasingly risking the functioning ...
16:53 24-May-2017
DatabaseWeekly - Newsletter
Redgate's Foundry team are starting work on a solution to reduce the pain and time-cost of providing audit evidence for SQL Server user access. If you ...
15:45 24-May-2017
DatabaseWeekly - Newsletter
User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can ...
15:45 24-May-2017
SQLServerCentral - Blogs
Welcome to a new series that I'm starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions ...
14:30 24-May-2017
SQLServerCentral - Blogs
If you are looking at providing high availability (HA) for SSAS, here are 3 options: Install SSAS on a Windows Server Failover Cluster (WSFC) Here's ...
14:00 24-May-2017
SQLServerCentral - Blogs
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure.  This is part two of what I am learning in Azure. Today's topic ...
13:46 24-May-2017
SQLServerCentral - Blogs
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took. One of the big announcements at Build 2017 was the release of CosmosDB. ...
12:13 24-May-2017
SQLServerCentral - Blogs
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at the same time, but with different ...
12:00 24-May-2017
SQLServerCentral - Questions
Hello I have 2 tables with workers and supervisor data I need the output as any aggregation data of hours spent by supervisor with worker. There will ...
09:54 24-May-2017