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
If a particular stored procedure is executing longer than 60 seconds, can the stored proc stop processing ...
21:39 24-Jan-2017
SQLServerCentral - Questions
I have a sql stored procedure with 2 date variables that I need to run the report on. @StartDate and @EndDate. The Stored procedure runs a census report ...
21:34 24-Jan-2017
SQLServerCentral - Questions
By the end of 2017 I would like to be in a position to transition from my current vocation into full-time T-SQL work. In my current position as an office ...
20:51 24-Jan-2017
SQLServerCentral - Questions
In brief, I have been asked to help unravel a situation where a generic development AD user account has been used for years across multiple environments ...
15:05 24-Jan-2017
SQLServerCentral - Blogs
The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that having a leader you can trust ...
15:00 24-Jan-2017
SQLServerCentral - Blogs
In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual.  ...
13:45 24-Jan-2017
SQLServerCentral - Editorials
Being unemployed is difficult. Here's something I learned to help me through it.
00:00 24-Jan-2017
SQLServerCentral - Main Articles
Using R with Power BI, SSRS or RTVS for easier data visualization
00:00 24-Jan-2017
SQLServerCentral - Main Articles
On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings ...
00:00 24-Jan-2017
SQLServerCentral - Main Articles
Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is ...
00:00 24-Jan-2017
SQLServerCentral - Blogs
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes according to one's ...
23:06 23-Jan-2017
SQLServerCentral - Questions
I have a query something like SELECT ProductId,ProductName, Product Demand, Product Supply, Product Launch Year, ParentProduct, SUM(Cost) FROM ...
20:41 23-Jan-2017
SQLServerCentral - Blogs
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I'm constantly impressed by the improvements that the dev team ...
19:09 23-Jan-2017
SQLServerCentral - Questions
Hi Experts, I have an existing cube in which i have to add attributes to one of the dimensions. The attributes are present in the database table but ...
18:00 23-Jan-2017
SQLServerCentral - Blogs
Right now I am so excited, and a little embarrassed.  After using Visual Studio (VS) for database projects for the last 7 years, I am just now finding ...
16:20 23-Jan-2017
SQLServerCentral - Blogs
Abstract This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable an integration of JSON data into ...
15:43 23-Jan-2017
SQLServerCentral - Blogs
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great information. I’ve talked about the ...
15:05 23-Jan-2017
SQLServerCentral - Blogs
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of good comments and several of them suggested that ...
14:00 23-Jan-2017
SQLServerCentral - Blogs
Issue: When I am running code from PowerShell console its running fine but when I execute it through ...
11:42 23-Jan-2017
Simple-Talk - SysAdmin Articles
When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite ...
10:20 23-Jan-2017
SQLServerCentral - Blogs
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets up at 5am, works a 12 hour day ...
09:14 23-Jan-2017
SQLServerCentral - Blogs
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and perhaps the most common of those is the use ...
09:00 23-Jan-2017
SQLServerCentral - Questions
Hi All, I have strange issue that I am trying to understand. I am able to query a view and it returns results in under a minute. But when i use " Select ...
05:05 23-Jan-2017
SQLServerCentral - Blogs
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select customer from dbo.customers where id ...
05:00 23-Jan-2017
SQLServerCentral - Blogs
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session known as telemetry_xevents that is ...
04:00 23-Jan-2017
SQLServerCentral - Questions
we have a table have primary key PID and foreign key CID, now need to clean some rows based on primary key. the table like below: CREATE TABLE #AA ...
03:03 23-Jan-2017
SQLServerCentral - Blogs
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to see Grant and Denny speak. Grant did an hour, ...
02:10 23-Jan-2017
SQLServerCentral - Editorials
Why do we have databases? Steve Jones has a few thoughts. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new ...
00:00 23-Jan-2017
SQLServerCentral - Main Articles
In this example we will join two CSV files with a common column using SQL Server.
00:00 23-Jan-2017
SQLServerCentral - Main Articles
A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU7 for SP3.
00:00 23-Jan-2017
SQLServerCentral - Main Articles
SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual ...
00:00 23-Jan-2017
SQLServerCentral - Main Articles
Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.
00:00 23-Jan-2017
SQLServerCentral - Blogs
This page is a table of contents for for several new and forthcoming posts.  I'm posting a series of excerpts for my Wrox Press book: Professional SQL ...
17:49 22-Jan-2017
SQLServerCentral - Blogs
Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This ...
17:39 22-Jan-2017
SQLServerCentral - Blogs
I have been working on SQL Server Consulting assignment,  a SQL Server 2014 migration for a new client over the past few weeks. When I'm undertaking ...
09:00 22-Jan-2017
SQLServerCentral - Blogs
Dear All,Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community ...
08:32 22-Jan-2017
SQLServerCentral - Blogs
TweetG’day, It’s been a while I thought that I'd make a quick blog post about an incident that I encountered today that I had not come across ...
06:29 22-Jan-2017
SQLServerCentral - Questions
Hi Guys, I have tried many ways on importing data from a CSV file into MS SQL database, I'm unable to figure the error which is being passed by logparser. ...
20:41 21-Jan-2017
SQLServerCentral - Blogs
By Steve Bolton ....In the world of fuzzy sets and imprecision modeling, the concept of cardinality ...
21:15 20-Jan-2017