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
Earlier today I had the please of speaking with the PASS Business Intelligence Virtual Chapter on getting ...
21:20 09-Feb-2016
DatabaseWeekly - Newsletter
This book aims to get the newcomer started in SQL Server development, how does it fare?
19:42 09-Feb-2016
SQLServerCentral - Questions
I'm trying to install sql server 2012 in windows 8.1. After accepting terms & conditions,its going to ...
19:06 09-Feb-2016
SQLServerCentral - Questions
I need to examine a user database with a corrupted logfile ("the logscan number ... is not valid"). This database is in full recovery mode. Due to this ...
17:18 09-Feb-2016
SQLServerCentral - Blogs
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I'm honored to say that I have been ...
15:02 09-Feb-2016
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 - Blogs
Until now we have seen the windows memory addressing concepts.http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.htmlSo ...
12:22 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
DatabaseWeekly - Newsletter
Many software teams are already integrating their application code but haven't yet brought the continuous integration discipline to their database development. ...
08:42 09-Feb-2016
DatabaseWeekly - Newsletter
New version includes a first of its kind Pipeline Builder, for a significantly easier automated database deployment pipeline, enabling users to visually ...
08:42 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
Simple-Talk - SQL Articles
You can still do Database Lifecycle Management (DLM) workflows in the hosted version of Team foundation Server (TFS) in Visual Studio Team Services (VSTS) ...
by Jason Crease
00:00 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