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
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016. One of the topics covered was a new operator for ...
14:57 25-Jul-2016
SQLServerCentral - Blogs
Row Level Security (RLS) is a great new feature in SQL Server 2016. It's been in Azure SQL Databases for some time, but we now have it on premise. It's ...
14:16 25-Jul-2016
SQLServerCentral - Questions
Do you know if there is software out there designed to keep inventory of sql server databases. I´m looking for a tool to keep track of multiple instances ...
14:02 25-Jul-2016
SQLServerCentral - Blogs
Blog post #7 in support of Tim Ford's (b|t) #iwanttohelp, #entrylevel. Read about it here. Sooner or later when you’re working with SQL Server, ...
13:04 25-Jul-2016
SQLServerCentral - Blogs
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out ...
12:00 25-Jul-2016
SQLServerCentral - Blogs
This is the fourth week of four of my July training programming and this week we have two courses that I am involved inTomorrow 26th July I will be teaching ...
11:30 25-Jul-2016
SQLServerCentral - Questions
I have a Clients Database collecting data from a Meter or Counter (regular smart house water or power Meter). I need to prepare a graph (line graph or ...
08:21 25-Jul-2016
SQLServerCentral - Questions
Hi, I have a 2 node SQL Server 2012 availability group setup and working fine. Recently I identified some permission issue and fixed it on the Primary. ...
06:54 25-Jul-2016
SQLServerCentral - Blogs
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual Summit 2016 to be held in Bangalore from Aug 11 to 13th. ...
02:19 25-Jul-2016
SQLServerCentral - Blogs
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have been added to improve its performance. It helps ...
01:40 25-Jul-2016
SQLServerCentral - Editorials
Today Steve Jones wonders why we don't unit test more, especially for databases. How to fix SQL Server disk I/O bottlenecks (without ...
23:00 24-Jul-2016
SQLServerCentral - Main Articles
Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads ...
23:00 24-Jul-2016
SQLServerCentral - Main Articles
Information Technology is fast-changing, but the people who work in IT need to have a good chance of a long-term career. That means keeping up to date, ...
23:00 24-Jul-2016
SQLServerCentral - Blogs
Today marks one years since Power BI was officially released.  It's been an amazing ride and I'd like to thank the team at Microsoft for so responsive ...
21:18 24-Jul-2016
SQLServerCentral - Questions
IT 64 5 - Database Management Systems Take Home Mid - term Only answer 10 of the 2 0 questions. ...
17:32 24-Jul-2016
SQLServerCentral - Blogs
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL – Columnstore Indexes Scripts Library ...
14:57 24-Jul-2016
SQLServerCentral - Blogs
Well today marks the one year anniversary since the initial release of Power BI.  We all have watched this product mature from a small infant to what ...
12:04 24-Jul-2016
SQLServerCentral - Blogs
Today marks the first anniversary of Power BI Desktop and the Power BI Service.  The effort to achieve this milestone and the on-going commitment of the ...
11:58 24-Jul-2016
SQLServerCentral - Questions
i'm trying to get the same result set from my original query to a case statement. Original qry: the result return $80,160 select sum(Total Cost) from ...
19:32 23-Jul-2016
SQLServerCentral - Blogs
San Antonio is such a great city with a lot to see and do, such as the Alamo and the river walk. I'm excited to be speaking at their very first SQL Saturday!! My ...
12:51 23-Jul-2016
SQLServerCentral - Blogs
I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls.  The audience was great ...
10:49 23-Jul-2016
SQLServerCentral - Questions
I want the ability to display the Time for the different time zones thru-out the world where I have ...
01:00 23-Jul-2016
SQLServerCentral - Questions
so this query works for a specific userID. ![alt text][1] However, when I run for the entire data warehourse (same query, but eliminate the "customer_profile.userID ...
19:25 22-Jul-2016
SQLServerCentral - Blogs
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember ...
19:18 22-Jul-2016
SQLServerCentral - Blogs
Prakash will walk you through a centralized process using PowerShell where the key information collected, ...
19:01 22-Jul-2016
SQLServerCentral - Questions
From any server in Availability group (only have one), can I find out what server is primary ? Thanks
18:27 22-Jul-2016
SQLServerCentral - Questions
can we overwrite a backupfile which is not expired in sql server let me explain in detail what i did. DBNAME : TEST STEP 1 : RIGHT CLICK ON TEST----->TASKS---->BACKUP ...
15:35 22-Jul-2016
SQLServerCentral - Questions
i taken a backup of a database and i mentioned backupset will expire after 0 day(s) which means the backup will never expire. but i am able to overwrite ...
14:44 22-Jul-2016
SQLServerCentral - Blogs
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the ...
14:29 22-Jul-2016
DatabaseWeekly - Newsletter
What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this ...
12:47 22-Jul-2016
DatabaseWeekly - Newsletter
In the second part of his ongoing SQL Server and Continuous Integration series, James Anderson looks at using the version control system Git with SQL ...
12:47 22-Jul-2016
DatabaseWeekly - Newsletter
For the first time this August, the Redgate team are heading to SQLServerGeeks Annual Summit 2016. Catch some great sessions from Grant Fritchey and Alex ...
12:47 22-Jul-2016
SQLServerCentral - Blogs
Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL ...
11:00 22-Jul-2016
SQLServerCentral - Questions
Hi, I can't find the way where is the problem in my "Insert into" Query in Store Procedure, In my Remote Server Query is executed successfully but there ...
08:09 22-Jul-2016
SQLServerCentral - Blogs
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban, Lean and XP After ...
06:09 22-Jul-2016
SQLServerCentral - Questions
Hi Experts, Could you pls expalin me is the database ID is basically an OS ID that is then given DB access, or is the ID created within the database itself Can ...
03:33 22-Jul-2016
Simple-Talk - SQL Articles
With the formatting of code, we sometimes do things because they've always been done that way, rather than making code easier to understand. Occasionally ...
by Joe Celko
00:00 22-Jul-2016
Simple-Talk - SQL Articles
Distribution statistics are used by SQL Server's Query Optimiser to determine a good execution plan for your SQL query. You don't need to know about them ...
by Robert Sheldon
00:00 22-Jul-2016
Simple-Talk - .NET Articles
It is just the first stage to make your C# Cmdlet do what it is supposed to do. Even though cmdlets are used at the commandline, they need a whole range ...
by Michael Sorens
00:00 22-Jul-2016