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
Hello Guys can you help, I want to return last 4 issues of the book (the ones I circled them) dynamic and not hard coded, for example if the new book ...
10:09 07-Dec-2016
SQLServerCentral - Blogs
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership ...
07:28 07-Dec-2016
SQLServerCentral - Questions
how to attach database from sql server 2012 to 2014 step by step I will install MS-SQL 2014 and need to attached database in version 2012 to 2014 Kindly ...
07:20 07-Dec-2016
SQLServerCentral - Blogs
Stuck with the below error right now..any ideasTrying to pull data from Oracle view using linked server and getting below error. It was only when I try ...
00:39 07-Dec-2016
SQLServerCentral - Main Articles
Now that we've explored, in preceding levels, some of the information that is available about indexes, ...
00:00 07-Dec-2016
SQLServerCentral - Main Articles
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, ...
00:00 07-Dec-2016
SQLServerCentral - Main Articles
SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.
00:00 07-Dec-2016
SQLServerCentral - Main Articles
Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell. ...
00:00 07-Dec-2016
SQLServerCentral - Questions
On the SQL Server 2008 R2, I keep getting Login Failed for user'DOMAIN\username' Reason: Failed to open the explicitly specified database' [Client. IP ...
17:42 06-Dec-2016
SQLServerCentral - Blogs
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I've ...
16:36 06-Dec-2016
SQLServerCentral - Questions
i need to run a query to select specific set of raws (SAC) with year month and FUND type and kept getting ...
16:27 06-Dec-2016
SQLServerCentral - Questions
I am trying to make a table that includes join between 3 tables in the MSSS 2008. There is a fact table, a date table, and a course table. I should join ...
15:26 06-Dec-2016
SQLServerCentral - Blogs
Colleague:I think I just encountered my first Right join*shocked* Me: huh. weird.a rare Right Join has appeared!Colleague:catch it!Me:You use ON. ...
14:20 06-Dec-2016
SQLServerCentral - Blogs
Come on down! You're the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought we might talk about security. ...
14:00 06-Dec-2016
SQLServerCentral - Blogs
In this module you will learn how to use the Sankey Power BI Custom Visual.  The Sankey is a type of diagram that visualizes the flow of data between ...
13:53 06-Dec-2016
SQLServerCentral - Blogs
In-Memory OLTP  (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated ...
10:55 06-Dec-2016
SQLServerCentral - Blogs
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that ...
08:52 06-Dec-2016
SQLServerCentral - Questions
I have put in an answer on the question https://ask.sqlservercentral.com/questions/141050/sql-server-only-detects-16-of-32-logical-processor.html When ...
07:48 06-Dec-2016
SQLServerCentral - Questions
Hello Team, I am facing an interesting issue while altering a column datatype. This issue is related to maximum allowable table row size. I have gone ...
07:34 06-Dec-2016
SQLServerCentral - Blogs
Wait stats is my go to thing, however I do get bored just querying it via a  table so I decided to broaden my horizons and see how "analytical" I could ...
05:30 06-Dec-2016
SQLServerCentral - Editorials
I have seen three common responses to database messes. My favorite is nuclear.
00:00 06-Dec-2016
SQLServerCentral - Main Articles
Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date ...
00:00 06-Dec-2016
SQLServerCentral - Main Articles
Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications ...
00:00 06-Dec-2016
SQLServerCentral - Main Articles
Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey ...
00:00 06-Dec-2016
SQLServerCentral - Blogs
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, ...
18:52 05-Dec-2016
SQLServerCentral - Questions
After deployment to SSISDB, I get foreach loop container warning: `The for each file enumerator is ...
15:44 05-Dec-2016
SQLServerCentral - Blogs
Tired from all those blog posts For my final blog post in the #gettingstarted, #iwanttohelp series, I decided to curate a set of presentations from the ...
15:05 05-Dec-2016
SQLServerCentral - Blogs
Hello Dear Reader!  It's been a while.  I was working with a friend and we came across an interesting problem.  They had a large amount ...
14:12 05-Dec-2016
SQLServerCentral - Questions
I am having an issue with this code below. It give me this error: Conversion failed when converting date and/or time from character string. The datevalue ...
12:32 05-Dec-2016
SQLServerCentral - Blogs
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just in business offices but in ...
12:12 05-Dec-2016
SQLServerCentral - Blogs
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a sort of a summary – about various ...
11:22 05-Dec-2016
SQLServerCentral - Questions
Dear All, We have a database and archived some data, I want to shrink the database(I know it is not recommended) but I don't have choice. I will do rebuild ...
11:13 05-Dec-2016
SQLServerCentral - Blogs
You are the DBA your company makes you. Aren’t you? SQL Server has such a wide range of features that no DBA role will implement all of them. So, ...
09:17 05-Dec-2016
SQLServerCentral - Editorials
Should we be considering our Work/Training Balance as part of our careers? How to fix SQL Server disk I/O bottlenecks (without a hammer)In ...
00:00 05-Dec-2016
SQLServerCentral - Main Articles
How to determine what replica(s) to perform maintenance routines How to fix SQL Server disk I/O bottlenecks (without a hammer)In this ...
00:00 05-Dec-2016
SQLServerCentral - Main Articles
Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of ...
00:00 05-Dec-2016
SQLServerCentral - Main Articles
Redgate is running a short survey to better understand the tools you're using for database development. There are eleven questions, and three $50 Amazon ...
00:00 05-Dec-2016
SQLServerCentral - Questions
I want to make a constraint (if one field is not null, the end user must put 3 or 5 or 10 in another field) and the two fields are in the same table. To ...
17:50 04-Dec-2016
SQLServerCentral - Blogs
I recently needed to replicate all of the reports on one report server to a different server.  I started ...
07:00 04-Dec-2016