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'm very new to SQL and SSIS, SSAS, SSRS, I have 3 tier SharePoint farm with one SQL Database and one Separate Report server where all SSIS, SSAS, SSRS ...
09:16 24-Mar-2017
SQLServerCentral - Questions
we have SSRS 2014, it is not integrated with sharepoint. authenitication mode is windows. How do we allow any user in the domain to access the report? ...
09:16 24-Mar-2017
SQLServerCentral - Blogs
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio ...
00:40 24-Mar-2017
SQLServerCentral - Editorials
Who decides when code should be released? A question from Steve Jones today.
23:00 23-Mar-2017
SQLServerCentral - Main Articles
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why. How to fix SQL ...
23:00 23-Mar-2017
SQLServerCentral - Main Articles
Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate ...
23:00 23-Mar-2017
DatabaseWeekly - Newsletter
SQL Server Team has announced that in CTP 1.4 you can schedule tasks using SQL Server Agent, when SQL Server is running on Linux.
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Vladimir Oselsky stumbles across some very puzzling join syntax and tries to figure out its intent.
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Has Hadoop failed to deliver the goods? That was a question on the minds of Strata + Hadoop World attendees last week, with opinions expressed both pro ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
This is a weird story, and I'm skeptical of some of the details. Presumably Apple has decided that it's smarter to spend the money on secure backups and ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
If you are running on the SQL Server 2014 SP2 branch, you really should be running the latest SQL Server ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Microsoft released SQL Server 2016 Service Pack 1 CU2, which is Build 13.0.4422.0. This CU has 101 fixes in the public fix list, by my count. This is ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Many of us have experienced a dreaded data type conversion error when doing tasks like importing files, converting to new database schemas, etc. Which ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Replication is a widely-adopted feature in SQL Server to copy and distribute data and database objects from one database to another and then synchronizing ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
What if the data in the parameter of the paginated report was populated from a SQL Server Analysis Services (SSAS) model? Does the drill URL change? It ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Rob Sewell on how to back up SQL Server databases on Linux using Ola Hallengren's maintenance solution ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
If I have a table that has 6 foreign key columns/references should I create one index with all 6 foreign key columns in it, or should I create 6 individual ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Klaus Aschenbrenner investigates Plan Caching and its side-effects in SQL Server.
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Organisations rarely plan for how they should handle data breaches and when an incident does happen (and that seems to be a near certainty these days), ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
It seems that unlike every other language I've worked with, in T-SQL all variables are scoped to the same local scope regardless of where in the script ...
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
How to use the Gantt Power BI Custom Visual to visualize project timelines and deliverable completion.
19:43 23-Mar-2017
DatabaseWeekly - Newsletter
Glenn Berry describes some common issues and pitfalls that you may run into when you install and use ...
19:43 23-Mar-2017
SQLServerCentral - Blogs
Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you ...
18:45 23-Mar-2017
DatabaseWeekly - Newsletter
GroupBy.org is BrentOzar.com's community training initiative where your votes pick the session lineup.
18:43 23-Mar-2017
DatabaseWeekly - Newsletter
People have long been aware of the server-wide lock taken out by SSAS when processing finishes - and the issues that this can cause. Fortunately, commit ...
18:43 23-Mar-2017
DatabaseWeekly - Newsletter
Brent Ozar give the good, bad and ugly of choosing SQL Server.
18:43 23-Mar-2017
DatabaseWeekly - Newsletter
Do you need to run DBCC CHECKDB even on a read only database? YES! Here's why: many forms of corruption come from storage.
18:43 23-Mar-2017
SQLServerCentral - Questions
What is wrong with the below dynamic sql statement ? Declare @keyColumn nvarchar(50)='KUNNR' Declare @DataSource nvarchar(50)='pdg_sd.dbo.' Declare @Sql1 ...
18:14 23-Mar-2017
SQLServerCentral - Questions
Hi, I am new here. I am doing data integration from SQL Server 2008 R2 to PostgreSQL 9.5. I have table ...
14:29 23-Mar-2017
SQLServerCentral - Blogs
Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/ ...
13:44 23-Mar-2017
SQLServerCentral - Blogs
SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on Linux so I think now ...
13:38 23-Mar-2017
SQLServerCentral - Blogs
I am proud to announce that we contributed to the latest revision of the Microsoft SQL Server on VMware best practices guide, freely available at this ...
13:23 23-Mar-2017
SQLServerCentral - Blogs
This article discusses a simple solution of how to monitor SQL service availability across multiple ...
12:34 23-Mar-2017
SQLServerCentral - Blogs
Link Below:TempDB Database On a Local Disk for an FCIThis article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL ...
12:23 23-Mar-2017
SQLServerCentral - Questions
HI In SQL Server, We have table with 8 crore of records and 3 column data type is float right now. Now we need to change the float data type column into ...
12:10 23-Mar-2017
SQLServerCentral - Blogs
This is Chris Gibson's second post. This post follows on from his first post called: An Introduction ...
08:00 23-Mar-2017
SQLServerCentral - Questions
Hi Team, I want to write a SQL query, to retrive the duplicate words in a text saved in a cell. Below is an example. The Requirement is if the text ...
05:04 23-Mar-2017
SQLServerCentral - Questions
Hi All, I am planning to setup a report to display a list of users with sysadmin right across the environment. I have a Central management servers with ...
00:27 23-Mar-2017
SQLServerCentral - Editorials
Steve Jones wonders how many of us have had to send, or will have to send this email.
23:00 22-Mar-2017