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
I've a basic concept question with regards to Sql server backups for the FULL recovery model. I want to be able to restore to a point in time right up ...
19:38 08-Feb-2016
SQLServerCentral - Questions
Hello Everyone, I am trying to convert rows into column, while i know this can be done using pivot table but I have an issue where the number of rows ...
16:26 08-Feb-2016
SQLServerCentral - Questions
I have installed SQL Instance INSTANCE1 and INSTANCE2 on Node1 and created AG1 on INSTANCE1 and AG2 on INSTANCE2 but when I connect AG1 and AG2 both connect ...
15:20 08-Feb-2016
SQLServerCentral - Blogs
There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career ...
15:00 08-Feb-2016
SQLServerCentral - Blogs
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS.  Detailed steps including ...
14:37 08-Feb-2016
SQLServerCentral - Blogs
I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions ...
14:00 08-Feb-2016
SQLServerCentral - Blogs
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking ...
13:30 08-Feb-2016
SQLServerCentral - Blogs
Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These ...
12:00 08-Feb-2016
Simple-Talk - SQL Articles
It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses ...
by Joe Celko
00:00 08-Feb-2016
SQLServerCentral - Editorials
Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.
00:00 08-Feb-2016
SQLServerCentral - Main Articles
A proposed solution to the INSERT EXEC problem in tSQLt
00:00 08-Feb-2016
SQLServerCentral - Main Articles
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column ...
00:00 08-Feb-2016
SQLServerCentral - Questions
Hi, we've just upgraded to SS2014 and one developer asked me about slow query execution. The query was quite simple, one table, one condition selecting ...
20:40 07-Feb-2016
SQLServerCentral - Blogs
I'm excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities ...
16:55 07-Feb-2016
SQLServerCentral - Questions
hi, I am interesting to do my master dissertation in SQL server services in scope (Data visualization for sensemaking) but I still thinking about a scenario ...
22:33 06-Feb-2016
SQLServerCentral - Questions
CREATE PROCEDURE [Catalogs].[usr_sp_GetMasterDataPageSorted] ( @sortExpression nvarchar(50), @between1 int, @between2 int ) ...
19:11 06-Feb-2016
Simple-Talk - Blogs
I was attempting to deploy a provider-hosted application to my O365 instance and it was failing with an extremely helpful message reading "The operation ...
21:02 05-Feb-2016
SQLServerCentral - Blogs
History clearly confirms that good things come in threes.  As far as I know this is the first time that only the three most widely recognized Business ...
19:51 05-Feb-2016
SQLServerCentral - Blogs
Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a ...
19:38 05-Feb-2016
SQLServerCentral - Questions
Could you please let me know why I'm getting this error: The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not ...
19:31 05-Feb-2016
DatabaseWeekly - Newsletter
SQL Server 2008 introduced sparse columns as a method to reduce storage for null values and provide more extensible schemas. The trade-off is that there ...
18:42 05-Feb-2016
DatabaseWeekly - Newsletter
Tim Mitchell demos how to use custom file delimiters in SSIS flat file connections, which can be used to read or write files with a nonstandard field ...
16:42 05-Feb-2016
SQLServerCentral - Questions
I have a server that was brought to its knees yesterday, and the time frame matches perfectly with a ...
15:10 05-Feb-2016
SQLServerCentral - Blogs
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new server.  There are a couple of different ...
14:28 05-Feb-2016
SQLServerCentral - Blogs
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field separator such as comma, tab, ...
14:00 05-Feb-2016
DatabaseWeekly - Newsletter
DAX introduced a GROUPBY function that should replace SUMMARIZE in some scenarios. This article describes how to use GROUPBY in nested grouping scenarios ...
13:42 05-Feb-2016
DatabaseWeekly - Newsletter
Every now and again you need to run code when your instance starts up. For example you might want to check if the SQL Agent is running.
13:42 05-Feb-2016
DatabaseWeekly - Newsletter
Troy Hunt investigates concern about the security of the Waitrose login form.
13:42 05-Feb-2016
DatabaseWeekly - Newsletter
Rob Sewell on using Pester to run unit tests within PowerShell.
13:42 05-Feb-2016
DatabaseWeekly - Newsletter
Microsoft has bet big time on PowerShell for a number of years and has made it very plain that if you intend to have a career managing Windows-based platforms ...
13:42 05-Feb-2016
DatabaseWeekly - Newsletter
The commonmark R package wraps around cmark, which converts markdown text into various formats, including html, latex and groff man. This makes commonmark ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
Throughout January Glenn Berry described each of the 70 queries in the January 2016 version of his SQL Server 2016 Diagnostic Information Queries, with ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
The SQL Server 2016 Community Technology Preview (CTP) 3.3 is now available for download! In SQL Server 2016 CTP 3.3, part of our new rapid preview model, ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
Anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
The Power BI team announced its support to create R visuals in its recent update and in this tip we'll help you get started by walking through what R ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
The problem with cascade deletes configuration in EF is, sometimes it cannot be done with attributes, which is a mapping mechanism that most people like ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
Microsoft is looking for some people to talk to for ~20 minutes, via phone/Skype, about Backups or data security.
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
Recent disruptions have not all been based first on price, but rather data. For instance, Uber actually started in the high-end luxury car business that ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
The latest preview of SSMS includes all updates included in last year's December release, and features numerous bug fixes in Always Encrypted dialogs, ...
12:42 05-Feb-2016