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 - Blogs
In my last post, I explained how to alter an existing job step across many servers. I also had cause to add a T-SQL Job step to a large number of jobs ...
10:03 20-Feb-2017
SQLServerCentral - Questions
Hello, I have "History" folder which consist 3000+ text files and so I would like to automate the process ...
07:04 20-Feb-2017
SQLServerCentral - Editorials
Steve Jones is getting excited about learning at SQL Bits 2017.
00:00 20-Feb-2017
SQLServerCentral - Main Articles
If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL ...
00:00 20-Feb-2017
SQLServerCentral - Main Articles
Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.
00:00 20-Feb-2017
SQLServerCentral - Main Articles
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 ...
00:00 20-Feb-2017
SQLServerCentral - Blogs
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is a training(&-vacation for some) event organized by ...
21:57 19-Feb-2017
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