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
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
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
Simple-Talk - Cloud Articles
So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have ...
by Murilo Miranda
00:00 22-Jul-2016
SQLServerCentral - Editorials
Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why ...
23:00 21-Jul-2016
SQLServerCentral - Main Articles
This level discusses how to use a database VIEW to simplify your Transact-SQL(T-SQL) code. By understanding ...
23:00 21-Jul-2016
SQLServerCentral - Main Articles
The Pull mode of Desired State Configuration (DSC) is more complicated to implement because you need ...
23:00 21-Jul-2016
SQLServerCentral - Blogs
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little ...
18:30 21-Jul-2016
SQLServerCentral - Blogs
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to repeat ...
18:27 21-Jul-2016
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Having system named objects ...
18:20 21-Jul-2016
SQLServerCentral - Blogs
I was recently browsing www.myplates.com and I'll say it's actually quite fun to see what plates people have randomly bought. I found it easy to spend ...
17:20 21-Jul-2016
SQLServerCentral - Blogs
If you have not already seen in the What's New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize.  ...
17:00 21-Jul-2016
SQLServerCentral - Blogs
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over ...
15:58 21-Jul-2016
SQLServerCentral - Blogs
Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed ...
15:52 21-Jul-2016
DatabaseWeekly - Newsletter
I'm disturbed. I read an announcement from the PASS organization this week that bothers me. I am less upset with the content than the manner in which ...
14:47 21-Jul-2016
DatabaseWeekly - Newsletter
This post is about the practice of Structural Inspection in unit testing and why I personally consider it an anti-pattern. Structural Inspection But first, ...
14:47 21-Jul-2016
SQLServerCentral - Blogs
I'll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate employee) and Damian Brady (b | ...
14:12 21-Jul-2016
SQLServerCentral - Blogs
As I have mentioned in previous posts, we have done a deal with Learning Tree to be able to offer you selected courses from their public course schedule ...
13:00 21-Jul-2016
DatabaseWeekly - Newsletter
Maximum availability is the goal for almost all enterprise database implementations. To achieve that availability, you need to implement a layered approach ...
11:47 21-Jul-2016
DatabaseWeekly - Newsletter
Microsoft has a brand-new conference, exclusively for data scientists, big data engineers, and machine learning practitioners. The Microsoft Data Science ...
11:47 21-Jul-2016