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 apologize for asking frequent question. I have tried multiple solutions suggested. I am getting the message very clear but why does the processing ...
20:05 26-Jun-2017
SQLServerCentral - Questions
I have this solution to find Functions or stored procedures but what would I add to the When clause to get Views? I know it's along the lines of: WHEN ...
19:48 26-Jun-2017
SQLServerCentral - Questions
Hi , I have to divide a table that Financial Department gave to me , it is table with three columns: DEPT MONTH BUDGET A 1 50.000? B ...
17:38 26-Jun-2017
SQLServerCentral - Blogs
Managing indexes is a critical component of database maintenance but we often don't think about the indicators behind the index maintenance operations. ...
16:59 26-Jun-2017
SQLServerCentral - Blogs
I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID ...
14:27 26-Jun-2017
SQLServerCentral - Blogs
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works and have as many different ...
13:03 26-Jun-2017
SQLServerCentral - Blogs
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll wait. So? What do you think? Did you get it ...
12:00 26-Jun-2017
SQLServerCentral - Blogs
VM snapshots are one of the best virtualization features ever. But.have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill ...
11:43 26-Jun-2017
SQLServerCentral - Blogs
Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting ...
11:02 26-Jun-2017
SQLServerCentral - Blogs
When I start talking with folks about security, one of the areas of confusion I often find has to do with the three A’s of security. Specifically, ...
11:00 26-Jun-2017
SQLServerCentral - Questions
the single record that i used is table shipment_assignment or table a on this scheme then i add alias ...
09:56 26-Jun-2017
SQLServerCentral - Blogs
Last week I asked the following question on Twitter: – I was interested to see the responses as I wanted to know how more experienced presenters ...
07:18 26-Jun-2017
SQLServerCentral - Blogs
Previous Related Post: Split personality text editing in SSMS with Sublime Text 3 In this prior post I wrote about how to call Sublime Text 3 from SSMS ...
04:00 26-Jun-2017
SQLServerCentral - Blogs
One of the real-world I/O troubleshooting problems is - If you have your databases spread across multiple LUNs and you want to find out which database ...
00:32 26-Jun-2017
SQLServerCentral - Questions
Hello group. I just recently completed my MCSE Data Management and Analytics, but did it using the MCSA 2012/14 path with exam 461,462,and 463. I am ...
23:43 25-Jun-2017
SQLServerCentral - Editorials
If you have ideas for how to improve replication, Steve Jones is asking for them.
23:00 25-Jun-2017
SQLServerCentral - Main Articles
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
23:00 25-Jun-2017
SQLServerCentral - Main Articles
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability ...
23:00 25-Jun-2017
SQLServerCentral - Blogs
[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of the Campaign/Brand ...
22:39 25-Jun-2017
SQLServerCentral - Blogs
Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I would like to thank Sunil Agarwal (Program ...
12:26 25-Jun-2017
SQLServerCentral - Questions
I'm having trouble understanding how the DATE data type storage is 3 bytes in SQL Server. The DATE data type stores only date values with a range of ...
19:48 24-Jun-2017
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