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
This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is embracing the open source model. It's releasing ...
10:50 24-Jun-2017
SQLServerCentral - Blogs
I am glad to share that I will be speaking at 24 Hours of PASS – PASS Summit 2017 Preview that will take place on 19th & 20th of July 2017. As ...
10:44 24-Jun-2017
SQLServerCentral - Blogs
Speaking at SQLSaturday Sacramento! I'm proud to announce that I will be speaking at SQL Saturday Sacramento on July 15th 2017! And wow, 650 SQLSaturdays! ...
21:04 23-Jun-2017
SQLServerCentral - Questions
First the error: System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at ...
20:13 23-Jun-2017
SQLServerCentral - Questions
We are running into an issue with an install, receiving the error "Invalid object name ...". It does ...
19:31 23-Jun-2017
SQLServerCentral - Blogs
Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource that not everyone is ...
18:00 23-Jun-2017
SQLServerCentral - Blogs
I ran across Denis Gobo's post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, ...
17:36 23-Jun-2017
SQLServerCentral - Questions
I was reading on handling deadlock and I came up with this page in Microsoft "Implementing an error ...
17:25 23-Jun-2017
Simple-Talk - SQL Articles
The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma ...
16:43 23-Jun-2017
Simple-Talk - Blogs
The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma ...
16:43 23-Jun-2017
DatabaseWeekly - Newsletter
Dharma Shukla covers Azure Cosmos DB, a massively scalable, multitenant, globally distributed database ...
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver ...
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
Power BI has long had the capability to include custom R charts in dashboards and reports. But in sharp contrast to standard Power BI visuals, these R ...
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
Current laws are outdated and are hindering access to data and threatening user privacy, the company says.
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
Sean Regan says DevOps requires more than tools. It also needs high-performing people and teams.Continue reading Building the culture and collaboration ...
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
I've read through a number of the industry thought leaders to get an understanding of how DevOps is being communicated out there. As with so much else ...
15:46 23-Jun-2017
DatabaseWeekly - Newsletter
In the recent past, I have written a blog about Ransomware. Here is the link. SQL SERVER - How to Protect ...
15:46 23-Jun-2017
SQLServerCentral - Blogs
We have jobs that run in the early morning to load data to our data warehouses and other systems, and if they don’t complete correctly, we start ...
11:50 23-Jun-2017
SQLServerCentral - Questions
SELECT TOP 600 dm_mid.database_id AS DatabaseID, dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact, dm_migs.last_user_seek ...
11:06 23-Jun-2017
SQLServerCentral - Questions
-- Get fragmentation info for all indexes above a certain size in the current database (Query 62) (Index Fragmentation) -- Note: This query could ...
11:06 23-Jun-2017
SQLServerCentral - Blogs
The weather has been absolutely boiling here in Dublin all week, I’m dying for a cold beer! Anyway, whilst drinking beer I’ll be reading… Docker ...
08:00 23-Jun-2017
SQLServerCentral - Blogs
Three big events planned in Baton Rouge this year that everyone can be a part of:User Groups Networking Night at the Louisiana Technology Park on July ...
06:00 23-Jun-2017
SQLServerCentral - Editorials
This week Steve Jones talks about the need to get away and asks if you have plans.
23:00 22-Jun-2017
SQLServerCentral - Main Articles
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 213 Utilities
23:00 22-Jun-2017
SQLServerCentral - Main Articles
In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.
23:00 22-Jun-2017
SQLServerCentral - Main Articles
In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why ...
23:00 22-Jun-2017
SQLServerCentral - Blogs
It's hard to believe but a full year has now passed as of today. It's my blogoversery! Can that be a word? Someone hash tag it please. To date, I have ...
19:27 22-Jun-2017
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed ...
18:05 22-Jun-2017
SQLServerCentral - Questions
I have inherited a SQL2012 database with several rather large tables filled with IMAGE data. I need to reduce the size of the database and would like ...
17:08 22-Jun-2017
DatabaseWeekly - Newsletter
The Northwind database implements the manager to employee hierarchy using an adjacency list, which is ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Dawn Parzych shows how understanding assumptions and biases can help your organization. Continue reading Perception and bias and metrics, oh my! .
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Last week, Microsoft issued a security patch for Windows XP, a 16-year-old operating system that Microsoft officially no longer supports. Last month, ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
This week on Data Driven , Frank and I are honored to interview Rimma Nehme , CosmosDB Architect at ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Whether he's blocking a 300-pound defensive lineman or hitting the math books, this doctoral candidate just won't quit.
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Asus rounded out the 10GbE ecosystem today with a desktop add-in network interface card to go with the previously released xg-U2008 switch. For less than ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
According to a recently declassified report obtained under FOIA, the NSA's attempts to protect itself against insider attacks aren't going very well: The ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Many customers want to do in-place upgrade of SQL Server instance to avoid the hardware cost and downtime. ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Relational databases do not natively support many to many relationships although a junction table is an easy workaround. Graph databases natively support ...
16:46 22-Jun-2017
DatabaseWeekly - Newsletter
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their daily life.  It consists of nine courses ...
16:46 22-Jun-2017