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 a similar vein to last week's blog post. I heard an interesting comment recently. "Change that Column != 2 to a Column > 2 or Column < 2 combination, ...
14:30 09-Feb-2016
SQLServerCentral - Blogs
How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)? The data ...
14:29 09-Feb-2016
SQLServerCentral - Questions
I have a publication which is intended to push data to a subscriber over the internet from a remote server to our onsite local subscriber but it ends ...
13:55 09-Feb-2016
SQLServerCentral - Blogs
Just a short post for a Tuesday to let you that I will delivering Learning Tree's 534 Developing SQL Queries for SQL Server course in Learning Tree's ...
13:00 09-Feb-2016
SQLServerCentral - Questions
I have two tables. Users and UserInformation UserID is a primary key in Users and a foreign key in UserInformation There is only one user in the User ...
10:42 09-Feb-2016
SQLServerCentral - Questions
Help We've recently upgraded to SQL Server 2014 and I need to convert all of the datetime columns to datetime2 in a specific database. Thanks Tim
10:33 09-Feb-2016
SQLServerCentral - Questions
Hello, May anyone please help me on this. database: SQL SERVER 2008 18 Million records i have two table and i need to check missing rows between two ...
08:23 09-Feb-2016
SQLServerCentral - Blogs
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment ...
03:01 09-Feb-2016
SQLServerCentral - Editorials
Public records have been open in the past, but today's digital access might mean problems.
00:00 09-Feb-2016
SQLServerCentral - Main Articles
Enabling Transparent Data Encryption on Databases in Always On Scenario
00:00 09-Feb-2016
SQLServerCentral - Main Articles
The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their ...
00:00 09-Feb-2016
SQLServerCentral - Main Articles
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. ...
00:00 09-Feb-2016
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 - Blogs
Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly and blog posts are flying across twitter.  How can ...
17:23 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
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialised tools that have dominated ...
by Robert Sheldon
00: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