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 am trying to enable the Always On Availability Groups feature of SQL Server 2012 Enterprise Edition on Windows Server Standard Edition 2012, but it ...
20:49 25-Mar-2017
SQLServerCentral - Blogs
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In Data Warehousing one will not be shocked ...
17:32 25-Mar-2017
SQLServerCentral - Blogs
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you ...
17:30 25-Mar-2017
SQLServerCentral - Blogs
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the results. Today we will look at using  Pester with ...
09:09 25-Mar-2017
SQLServerCentral - Questions
We are having some corruption in TempDB file (F:\) drive. When I run the sp_helpfile against tempdb, I got this: name fileid filename filegroup size maxsize growth usage tempdev 1 F:\tempdb.mdf ...
19:19 24-Mar-2017
SQLServerCentral - Blogs
When I agreed to host the T-SQL Tuesday site, I wasn't sure what to do. I thought about just putting up a static page, one I'd edit, but in some conversations ...
19:12 24-Mar-2017
SQLServerCentral - Questions
I had to upgrade all environment from SS2008 to SS2014 and SSRS were also part of the project. I was following MS recommendation from:[link text][1] The ...
16:29 24-Mar-2017
SQLServerCentral - Questions
Hello Experts , our full backup starts at 12.02 and completes at 4.00am .our full backup have all data in it and also getting t-log backup files same ...
15:01 24-Mar-2017
SQLServerCentral - Questions
Can I get help on the below. 1) I would like to create a View Statement 2) I would need to Count the number of weeks between EVENT_DATE AND GIFT_DATE ...
13:14 24-Mar-2017
DatabaseWeekly - Newsletter
Tim Peters' Cost Threshold For Parallelism is set to 5. he hopes never to have to defend his settings in a dark alley with Erik Darling.
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
Demonstrating use of the new Dynamic Management Function (DMF) sys.dm_db_stats_histogram, in the latest release of SQL Server 2016 SP1 CU2.
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This results in 32 physical cores or 64 logical cores. ...
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
A refresher on some of the basic principles of probability that one needs while dealing with more advanced programming in R and data analysis.
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
Long gone are the days where a DBA stays busy backing up databases and creating indexes. Today DBAs need to think about Automation, Powershell, Cloud ...
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
Chances are, it is less expensive to upgrade to SQL Server 2016 than to suffer a data breach.
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
Rob Collie checks out the new Concatenex function.
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
What data access library should you use to access your data in SQL Server database? Jovan Popovic shows ...
12:43 24-Mar-2017
DatabaseWeekly - Newsletter
Andrea Angella considers the Universal Architecture idea in light of the question "How can we prevent code becoming an intricate mess over time?"
12:43 24-Mar-2017
SQLServerCentral - Blogs
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself.  There are a couple of frequently ...
11:31 24-Mar-2017
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
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to ...
09:00 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.
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
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
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
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