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
Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule to keep events from being held too close together and another that ...
01:18 28-Jul-2016
SQLServerCentral - Questions
I have this query in SQL Server. When I run it, I am getting this error. Msg 9420, Level 16, State 1, Line 2 XML parsing: line 861527, character 67, ...
23:47 27-Jul-2016
SQLServerCentral - Editorials
Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is ...
23:00 27-Jul-2016
SQLServerCentral - Main Articles
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
23:00 27-Jul-2016
SQLServerCentral - Main Articles
React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat ...
23:00 27-Jul-2016
SQLServerCentral - Blogs
Sharpen Something It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday 51. I recapped that event here with the ...
22:46 27-Jul-2016
SQLServerCentral - Questions
I have an SSIS solution which, along with several other database manipulations, does several individual calculations and appends the results of each to ...
22:34 27-Jul-2016
SQLServerCentral - Questions
I have an Access 2010 database of students & classes in a curriculum. I have built a query where the fields are StudentName & then the name of each class. ...
20:05 27-Jul-2016
SQLServerCentral - Questions
We have a problem with our Power Builder application. It has pages that open a transaction and then don't close it until the user has either completed ...
16:36 27-Jul-2016
SQLServerCentral - Questions
enter code hereHi, I got an error when execute my SQL code the errors : [ Error Code: 904, SQL State: 42000] ORA-00904: "DATEDIFF": invalid identifier ...
14:02 27-Jul-2016
SQLServerCentral - Questions
![alt text][1] [1]: /storage/temp/3576-sql-question.jpg
12:35 27-Jul-2016
SQLServerCentral - Blogs
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server (database engine). You can grab it for free ...
12:15 27-Jul-2016
SQLServerCentral - Blogs
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years ...
11:00 27-Jul-2016
SQLServerCentral - Blogs
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working ...
11:00 27-Jul-2016
SQLServerCentral - Blogs
SQL Server 2016 CU1 has been released and one thing I noticed was: – FIX: Canceling a backup task crashes SQL Server 2014 or 2016 That’s pretty ...
10:13 27-Jul-2016
SQLServerCentral - Questions
I am stuck in ssrs scenario where i have to show the textbox when it is exported to excel or pdf also I have to hide that if count of a particular dataset ...
10:13 27-Jul-2016
SQLServerCentral - Blogs
This is the last course of my July training month. This is my second course this week. Yesterday I was teaching a 1-day course Writing SQL Queries. That ...
06:30 27-Jul-2016
SQLServerCentral - Editorials
Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.
23:00 26-Jul-2016
SQLServerCentral - Main Articles
When you can't get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence ...
23:00 26-Jul-2016
SQLServerCentral - Main Articles
A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.
23:00 26-Jul-2016
SQLServerCentral - Main Articles
Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article ...
23:00 26-Jul-2016
SQLServerCentral - Blogs
When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult to know the best option to deploy the SQL Server tempdb database. In ...
22:00 26-Jul-2016
SQLServerCentral - Blogs
Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail1902: Linux Virtualisation 4 Day starting   4days 30th August1197 ...
20:24 26-Jul-2016
SQLServerCentral - Blogs
Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers. This script outputs sql server configuration, ...
19:52 26-Jul-2016
SQLServerCentral - Blogs
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording ...
18:09 26-Jul-2016
SQLServerCentral - Blogs
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on an Azure SQL Database server.  We are ...
17:24 26-Jul-2016
SQLServerCentral - Blogs
I've had this idea for some time. It's been bugging me, but I haven't really been pressured to write, nor inspired. That changed a bit with the announcement ...
12:24 26-Jul-2016
SQLServerCentral - Blogs
This week is my fourth week on the spin being involved in a Learning Tree Course. This week we have double bubble. I teaching a Course today and I'm Producing ...
06:30 26-Jul-2016
SQLServerCentral - Editorials
Releasing software is stressful, and as Steve Jones notes today, can cause bankruptcy if you don't have a solid process.
23:00 25-Jul-2016
SQLServerCentral - Main Articles
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
23:00 25-Jul-2016
SQLServerCentral - Main Articles
Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
23:00 25-Jul-2016
SQLServerCentral - Main Articles
What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing ...
23:00 25-Jul-2016
SQLServerCentral - Questions
I cannot find out if it is possible to create a snapshot replication distributed from an SQL Server 2008R2 instance to an SQL Server 2016 instance. ...
20:49 25-Jul-2016
SQLServerCentral - Blogs
I'm proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my forth SQLSaturday event this year and I'm ...
20:25 25-Jul-2016
SQLServerCentral - Blogs
I have been sitting on this article for a while now. I have been tossing around some thoughts and finally it is time to share some of those thoughts ...
18:41 25-Jul-2016
SQLServerCentral - Questions
CPU trends in DB level report by script in sql server 2014. Any script for finding the DB level CPU usage report for couple of days. Example: We have ...
18:02 25-Jul-2016
SQLServerCentral - Blogs
In this module you will learn how to use the Chord Power BI Custom Visual.  Chord diagrams show directed relationships among a group of entities ...
16:15 25-Jul-2016
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