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
As per my understanding "Always ON" configuration internally have two nodes and active node will always serve the request. But suppose I have SQL Jobs ...
08:27 10-Feb-2016
SQLServerCentral - Editorials
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Mukesh Kumar shows how to make your query in SQL the same as your query in LINQ.
00:00 10-Feb-2016
SQLServerCentral - Main Articles
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that ...
00:00 10-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 10-Feb-2016
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