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
Hi, I am trying to write a statement in which my test step finds a parent node and node name but then I want it to start with only those two items or ...
10:18 24-Feb-2017
SQLServerCentral - Questions
I have 2 tables, both have date columns & customer code is common in both tables. I need to extract details of all the customer from both table on the ...
10:12 24-Feb-2017
SQLServerCentral - Blogs
Wow that week absolutely flew by! Here’s what I’ve been reading… Seatbelt learning with Uncle Buck Buck Woody goes through how he learns ...
09:00 24-Feb-2017
SQLServerCentral - Questions
tb_Maintable Countryid Stateid Cityid Details1 Details2 Details3 Details4 ProcessDate C1 S1 CT1 28/02/2016 C2 S2 CT2 28/02/2016 C3 S3 CT3 ...
08:47 24-Feb-2017
SQLServerCentral - Questions
We have an external database that I'd like to feed Contact data into our Dynamics NAV database running on MS SQL database. The procedure we use is: DECLARE ...
05:47 24-Feb-2017
SQLServerCentral - Editorials
Steve looks back at the languages he's learned this week. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new ...
00:00 24-Feb-2017
SQLServerCentral - Main Articles
Here a quick script showing how to get all the Active Directory users in a AD group.
00:00 24-Feb-2017
SQLServerCentral - Main Articles
If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby ...
00:00 24-Feb-2017
SQLServerCentral - Blogs
I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven't had a lot of time to work on the Linux version lately, but I thought I'd ...
20:03 23-Feb-2017
Simple-Talk - SQL Articles
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database ...
19:52 23-Feb-2017
SQLServerCentral - Questions
I have databases running on SQL Server 2008 R2, SQL Server 2014 and SQL Server 2008. I need to find ...
19:44 23-Feb-2017
SQLServerCentral - Blogs
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know ...
18:02 23-Feb-2017
SQLServerCentral - Blogs
  They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked ...
15:00 23-Feb-2017
SQLServerCentral - Blogs
Today at 3 PM EST I’m giving a webinar on designing a successful database security model with SQL Server. Register Here for Free (you can also register ...
14:15 23-Feb-2017
SQLServerCentral - Blogs
Who has the legal right to access your personal and private digital assets? The answer can be complex, and will depend on where you live, where you are ...
12:45 23-Feb-2017
SQLServerCentral - Blogs
There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into.yet!!! ...
12:27 23-Feb-2017
DatabaseWeekly - Newsletter
Enlarge / Frank Abagnale, as played by Leonardo DiCaprio in Catch Me If You Can, once pretended to be ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services - and we had an absolute ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
When an application searches for specific text data, you can generally rely on it to get the search term right. For example, if it needs to find 'sausages', ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
After more than a year in preview R Tools for Visual Studio, the open-source extension to the Visual Studio IDE for R programming, is nearing its official ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Was asked during today's Power BI User Group leaders call how to fill in an entire state with a color based on a measure. Turns out the shape map makes ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Who has the legal right to access your personal and private digital assets? The answer can be complex, and will depend on where you live, where you are ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Azure SQL Database enables you to directly load files stored on Azure Blob Storage using the BULK INSERT T-SQL command and OPENROWSET function. Loading ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Deploying SQL Server Availability Groups in Azure VMs typically involved provisioning two additional ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
We are excited to announce that SQL Blob Auditing is now Generally Available in Azure SQL Database. Blob Auditing tracks database events and writes audited ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
For more than six years, the SHA1 cryptographic hash function underpinning Internet security has been at death's door. Now it's officially dead, thanks ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
More isn't faster I've had people give me all sorts of janky reasons for changing Max Worker Threads. I've even had people tell me that someone from Microsoft ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Today, I want to give a shout out to one of our partners who has a great offering for Azure Data Lake Store customers.  When ingesting large scale data ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
This is the third post in a three-part series that explains how to maintain a single declarative source ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Enlarge / The Yubikey Neo (the black USB key) is a FIDO U2F-compliant key that works over NFC or USB. ...
09:42 23-Feb-2017
DatabaseWeekly - Newsletter
Today's less-than-ugent challenge was to un-pivot the output of RESTORE HEADERONLY. I thought for certain someone else, somewhere, at at some time must ...
09:42 23-Feb-2017
SQLServerCentral - Questions
How do I use a column separated filed within in clause Table 1 (id,requestedColor) Data 1 Red,Green 2 Blue, 3 Yellow,Red The column RequestColor ...
08:45 23-Feb-2017
SQLServerCentral - Questions
There are plenty of examples on how to retrieve a single sibling value. For example given the following XML fragment: 800000 80000 United Security ...
08:45 23-Feb-2017
SQLServerCentral - Blogs
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the ...
06:28 23-Feb-2017
SQLServerCentral - Questions
There are plenty of examples on how to retrieve a single sibling value. For example given the following XML fragment: 800000 80000 ...
00:09 23-Feb-2017
SQLServerCentral - Editorials
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered. How to fix SQL Server ...
00:00 23-Feb-2017
SQLServerCentral - Main Articles
Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md
00:00 23-Feb-2017
SQLServerCentral - Main Articles
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other. ...
00:00 23-Feb-2017