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
The SQL Server 2016 CTP 2.2 incremental release includes new capabilities for query store, stretch database, core engine, temporal, MDS, reporting services ...
19:47 30-Jul-2015
DatabaseWeekly - Newsletter
Which indexes are the big space consumers within the specified table for the given database?
19:47 30-Jul-2015
DatabaseWeekly - Newsletter
Klaus Aschenbrenner explains why Forced Parameterization is not always a good choice.
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
Scott Hanselman shows how to upgrade the Start menu after upgrading to Windows 10.
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
When a performance issue exists in SQL Server, it's ideal to troubleshoot the issue live, but in some cases, historical information can provide a smoking ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
With Always Encrypted sensitive data is transparently encrypted and decrypted within a client application by a client driver. SQL Server does not have ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
According to a new survey, Python's data science training wheels increasingly lead to the R language
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
An ETL process that inserted a few thousand rows every few minutes was taking 300 milliseconds, and suddenly the duration spiked to about 3 seconds. What ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
Mary Jo Foley's review of Windows 10 after using it for a week.
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
A key question about any data warehouse, often overlooked in the purchasing process, is how the data gets in and out. While performance is obviously critical, ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
The fastest way to compute a median uses the SQL Server 2012 OFFSET extension to the ORDER BY clause. Running a close second, the next fastest solution ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
This Curah is a collection of videos on the most important features of SQL Server 2016. Speakers are Engineers and Program Manager of the SQL Server Team! ...
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
You can use this set of guidelines, fork them or make your own - the key here is that you pick a style and stick to it.
18:47 30-Jul-2015
DatabaseWeekly - Newsletter
Grant Fritchey sketches out some of his goals for a proposed Leadership Training Course.
18:47 30-Jul-2015
Simple-Talk - Blogs
This man has some fine, fine whiskers. But that’s not really why we’re here – we want you to tell us what’s happening in this ...
15:12 30-Jul-2015
Simple-Talk - Blogs
We’re¬† on the lookout for the best .NET performance tips. The kind that can save hours of work and loads of worry. The kind that, while simple when ...
14:50 30-Jul-2015
SQLServerCentral - Blogs
14:48 30-Jul-2015
Simple-Talk - Blogs
One of the underlying realities of working with SharePoint's client side object model (CSOM) is that you are not continuously connected to SharePoint. ...
14:15 30-Jul-2015
SQLServerCentral - Blogs
Hi All, As per the previous article, i have tried to create the understanding for Distributed Cache service : Understanding, Planning and Configuring ...
13:36 30-Jul-2015
SQLServerCentral - Questions
Ive installed sql server 2014 developer edition on my pc (windows 8) I included the complete management tools but I cant find the enterprise manager. ...
12:43 30-Jul-2015
SQLServerCentral - Blogs
Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking ...
12:12 30-Jul-2015
SQLServerCentral - Blogs
Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions ...
12:00 30-Jul-2015
SQLServerCentral - Questions
I am not able to dynamically configure the method name using Expressions in the Property of a WebService ...
10:00 30-Jul-2015
SQLServerCentral - Blogs
SQLKover update: I’m reblogging this a bit earlier (it’s a quite¬†recent blog post) because I still see people with this issue. Also, it seems ...
08:38 30-Jul-2015
SQLServerCentral - Questions
I am faced with an issue where I need to make a backup of a database to a URL. Can you help me? I'm on Sql Server 2012. Thanks in advance.
06:55 30-Jul-2015
SQLServerCentral - Blogs
HI ALL In One Of the Group the question was asked that How to list all the Servers in which SQL is installed? It is genuine query. There are many scenario ...
06:18 30-Jul-2015
SQLServerCentral - Blogs
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little ...
00:19 30-Jul-2015
Simple-Talk - .NET Articles
In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2105 and DNX Microsoft have ...
by Clive Tong
00:00 30-Jul-2015
SQLServerCentral - Editorials
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
Detecting file differences on two different web servers using T-SQL.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
23:00 29-Jul-2015
SQLServerCentral - Blogs
I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was ...
22:38 29-Jul-2015
SQLServerCentral - Questions
Hi SQL Gurus, I can't seem to find the answer to this simple problem. I am trying to convert a datetime to a numeric(5,2). I only want the minutes converted. Here ...
18:16 29-Jul-2015
SQLServerCentral - Questions
I need to be able to add a hyphen '-' to the end of a date column based on certain criteria. If field3 has more then one 'VISIT' value. Based on account ...
16:31 29-Jul-2015
SQLServerCentral - Blogs
Alternate Title: I’m traveling a bunch. Let’s get together and talk. A bunch of trips and presentations coming up, so I thought I’d ...
15:48 29-Jul-2015
SQLServerCentral - Questions
Hi all , I opened transaction in master package level like ' begin transaction ' in execute sql task for this i used project level connection and set ...
13:57 29-Jul-2015
SQLServerCentral - Blogs
This year's PASS Summit will end on Oct 31, which is Halloween in the US. I'm sure lots of people will have some fun on Friday, though I also suspect ...
12:20 29-Jul-2015
SQLServerCentral - Blogs
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of ...
12:00 29-Jul-2015