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, 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
DatabaseWeekly - Newsletter
Running DMV queries against a Power BI Desktop model and more importantly doing something useful with the information they return, isn't straightforward. ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
Subhendu De attempts to describe what IoT is and what architecture is recommended to build an scalable, reliable, secured, maintainable and fault tolerant ...
12:42 05-Feb-2016
DatabaseWeekly - Newsletter
It's no secret that Docker and Microsoft have been working increasingly closer over the past couple of years. And unikernel operating systems are important ...
12:42 05-Feb-2016
SQLServerCentral - Questions
I am unable to delete the SCHEMA due to object and getting below error Msg 3701, Level 11, State 6, Line 1 Cannot drop the index 'LICHECK_STARTUP.index_name', ...
12:28 05-Feb-2016
DatabaseWeekly - Newsletter
On the heels of a report showing the inefficacy of government-run cyber security, it's imperative to understand the limitations of your system and model. ...
11:42 05-Feb-2016
SQLServerCentral - Blogs
Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses in Alexandria - a suberb of DC, followed by ...
10:00 05-Feb-2016
SQLServerCentral - Blogs
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals, with lot of the tech ...
09:03 05-Feb-2016
SQLServerCentral - Questions
Hi to ALL I am maintaining 100 sql servers how to check all sql servers are running or not at a time? pls ...
08:43 05-Feb-2016
SQLServerCentral - Questions
Hi sometimes xp_cmdshell showing null and sometimes its working fine... i dont know what wrong with this Any suggestions
07:16 05-Feb-2016
SQLServerCentral - Questions
I need to update a table with some 500 entries. I have a table with two columns in Excel with the left ...
05:46 05-Feb-2016
SQLServerCentral - Questions
I am using SQL Server 2012. We have 2 databases db1 and db2. We have 2 users, user1 and user2, that the application uses, that have limited permissions ...
00:59 05-Feb-2016
SQLServerCentral - Editorials
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you ...
00:00 05-Feb-2016
SQLServerCentral - Main Articles
Automatically capture replication conflicts and generate an automated email notification.
00:00 05-Feb-2016
SQLServerCentral - Main Articles
Microsoft is looking for some people to talk to for ~20 minutes via phone/Skype and as a thank you for sharing, will provide a $10 Amazon gift card after ...
00:00 05-Feb-2016