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 All, We are trying to load a table from SQL Server Parallel DW APS to In-Memory OLTP SQL Server 2014 Enterprise edition. As we are aware that we have ...
10:40 19-Feb-2017
SQLServerCentral - Questions
please kindly tell me the answer for the attached picture. ![![alt text][1]][1] [1]: /storage/temp/3978-pic1.jpg
09:11 19-Feb-2017
SQLServerCentral - Questions
Hi, I have a database with 100 tables. I have a main customer table (Primary Key CutomerID) and need to archive all customer records where status = ...
19:24 18-Feb-2017
SQLServerCentral - Questions
I given a task for auditing any DDL changes in one particular server instance. There are a few databases on the server and I cannot create any objects ...
10:43 18-Feb-2017
SQLServerCentral - Questions
can someone help me prevent this deadlock I have 2 Tables, Say table A and Table B, Table B has foreign key relation with Table A and while inserting ...
21:22 17-Feb-2017
SQLServerCentral - Questions
Hello All, Good afternoon,I am trying to compare the clustered and nonclustered count and their definitions ...
18:32 17-Feb-2017
DatabaseWeekly - Newsletter
SQL Server 2016 SP1 opens up a lot of new possibilities for Standard, Web, and Express editions of SQL Server, including new options for in-memory technologies ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
Microsoft's February Patch Tuesday patches are not going to arrive until Tuesday March 14, officials confirm, while providing no reasons for the delay. ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
In his ongoing series about chatbots, Benjamin Perkins now talks us through some recent improvements he's made to his own chatbot.
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
The latest version of Microsoft SQL Server, dubbed SQL Server v.Next, is due out soon after being in public preview mode since last year. From the looks ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
Scott Larsen walks through the steps of creating a Power BI visualization based on Hans Rosling's 2006 TED talk.
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular format. In this post, you might see that JSON functions ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
Want to quickly find all the function definitions within a module? Or the function calls within a function definition? Stuart Moore shares a regex he's ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
In this free online training course from Kendra Little, learn to set up simple, lightweight monitoring using free tools and scripts to find the queries ...
17:42 17-Feb-2017
DatabaseWeekly - Newsletter
In a bid to spread greater understanding about the role, Thomas LaRock gives a summary of the day-to-day tasks that are common for a DBA.
16:42 17-Feb-2017
DatabaseWeekly - Newsletter
In this free webinar, Steve Jones and Arneh Eskandari show how Redgate's Database DevOps solution works with Visual Studio Team Services to improve your ...
16:42 17-Feb-2017
DatabaseWeekly - Newsletter
Drew Furgiuele talks about how he had the chance to be involved with dbatools, the exciting community-created PowerShell module that adds functions to ...
16:42 17-Feb-2017
DatabaseWeekly - Newsletter
Grant Fritchey shares a PowerShell script he's written that exports query plans from the plan cache into a .sqlplan file.
16:42 17-Feb-2017
SQLServerCentral - Blogs
This is a different spin on the top three vendor rankings visualized in Power BI.  According to the placement of the chart elements in the "Visionary/Leader" ...
16:17 17-Feb-2017
DatabaseWeekly - Newsletter
One of the wow moments in the keynote where SQL Server 2016 was first introduced was a demo that automated the process classifying images of galaxies ...
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
Kenneth Fisher talks through how he dealt with a database stuck in single user mode.
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
In the latest episode of Dear SQL DBA, Kendra Little clears up the confusion surrounding sp_who2.
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux.
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
On the theme of fixing old problems with shiny new toys, Steve Hughes takes a look at splitting strings ...
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
Andrew Pruski shares a key step to viewing Docker logs that can trip you up if missed out.
15:42 17-Feb-2017
DatabaseWeekly - Newsletter
Led by its Technology Solutions team, Avnet will team with IBM to establish a Watson Internet-of-Things Joint Lab within IBM's newly opened global Watson ...
15:42 17-Feb-2017
SQLServerCentral - Questions
I want to calculate bell curve report and data display in google chart. How to calculate bell curve report from give data? ![![alt text][1]][1] Query ...
13:27 17-Feb-2017
SQLServerCentral - Blogs
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really good consultant is never going ...
13:19 17-Feb-2017
SQLServerCentral - Blogs
Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: – SQL Server vs SQL Server vNext Henrico Bekker ...
09:00 17-Feb-2017
SQLServerCentral - Blogs
It is an open secret that in SQL Server, we can "create a system object" by using an undocumented stored procedure sp_MS_marksystemobject as explained ...
07:28 17-Feb-2017
SQLServerCentral - Editorials
In today's guest editorial: the motivation to do our best must come from within.
00:00 17-Feb-2017
SQLServerCentral - Main Articles
How to use the EXCEPT statement to perform row differences.
00:00 17-Feb-2017
SQLServerCentral - Main Articles
Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, ...
00:00 17-Feb-2017
SQLServerCentral - Blogs
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback ...
19:48 16-Feb-2017
Simple-Talk - SQL Articles
If you are introducing DevOps workflows into a large organization, you'll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, ...
17:12 16-Feb-2017
SQLServerCentral - Questions
Hi expert, I have a issue when I restore database on sql server 2012 sometime. There is a database in server, I want to copy this database to same server ...
16:41 16-Feb-2017
SQLServerCentral - Blogs
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you ask? Well, 4-5 system sessions were holding ...
14:30 16-Feb-2017
SQLServerCentral - Blogs
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL processes, reviewing best practices ...
12:45 16-Feb-2017