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
When a user executes a search, they sometimes get an ODBC error - "The prepared statement handle 1 is not valid in this context". The application is an ...
16:08 01-Mar-2017
SQLServerCentral - Blogs
On Monday, Redgate released v1.0 of SQL Clone, and I'm excited that the product is finally available. I'm excited because this has been a long time coming, ...
14:43 01-Mar-2017
SQLServerCentral - Questions
I can't seem to find any help with the following on HA! I need to give access to reporting node in HA. I can't seem to do this without permissions on ...
14:41 01-Mar-2017
SQLServerCentral - Blogs
One of the most common ways to get an event notification is by email. So what happens when you get 500 emails in a day and only one or two are actionable? ...
14:00 01-Mar-2017
SQLServerCentral - Blogs
I’ll be giving a webinar for MSSQLTips.com at March 31st. It’s a sponsored webinar, meaning there will also be a vendor to talk about JAMS, ...
13:00 01-Mar-2017
SQLServerCentral - Blogs
Step By Step configring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability GroupsAlwaysOn Availability Groups: ...
12:43 01-Mar-2017
SQLServerCentral - Blogs
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. ...
12:25 01-Mar-2017
SQLServerCentral - Questions
select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS By using this i am getting all Column_name ...
12:16 01-Mar-2017
SQLServerCentral - Questions
Here's what i'm trying to do! Working with a 26 comma separated value string. Trying to build our part # configuration from this. Database Field BOM_Item 02,03,01,02,01,,,01,,,,,,,,,,,,,,,,,,1 There ...
09:01 01-Mar-2017
SQLServerCentral - Blogs
I’ve been working with containers for a while now and one of the questions that always gets asked when I demo the technology to people is, is there ...
09:00 01-Mar-2017
SQLServerCentral - Blogs
For this blog post I want to discuss the meaning behind SQL Server: Memory Manager\Target Server Memory (KB) and SQL Server: Memory Manager \Total memory ...
07:30 01-Mar-2017
SQLServerCentral - Editorials
How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.
00:00 01-Mar-2017
SQLServerCentral - Main Articles
We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.
00:00 01-Mar-2017
SQLServerCentral - Main Articles
The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term 'shift-left'. By performing, ...
00:00 01-Mar-2017
SQLServerCentral - Blogs
Hello Dear Reader!  I'm working on some really fun stuff with in-database R using SQL Server 2016. I needed to add a couple packages to my R engine ...
19:24 28-Feb-2017
SQLServerCentral - Blogs
I've hosted a page on this blog that has all the T-SQL Tuesday blog invitations and roundups linked. I did this mainly because I was trying to ensure ...
19:05 28-Feb-2017
SQLServerCentral - Questions
SQL Server 2016 have a database, I try rename it. I use SSMS GUI to do it. I first set database to single user mode, then I use rename on gui to change ...
19:01 28-Feb-2017
DatabaseWeekly - Newsletter
The TLDR answer to this is that Extended Events isn't returning an invalid database_id at the time that ...
18:42 28-Feb-2017
DatabaseWeekly - Newsletter
Kathi Kellenberger demonstrates the Category Chart, which displays a value over a series. For example, you may want to display total sales by territory. ...
18:42 28-Feb-2017
DatabaseWeekly - Newsletter
I love playing around with the free data that the Social Security Administration publishes on baby names each year. It's fun to manipulate the dataset ...
18:42 28-Feb-2017
DatabaseWeekly - Newsletter
Kimberley Tripp releases a new version of sp_helpindex, with newer functionality (included columns and filters) as well as being better at describing ...
18:42 28-Feb-2017
DatabaseWeekly - Newsletter
Brent Ozar demonstrates how SQL Server reacts when it finds corruption in a data file, and why you should check your databases for CHECKSUM settings, ...
17:42 28-Feb-2017
SQLServerCentral - Questions
I am working on a Master Data Management project, and I was to introduce a field for Effective Date and End Date to track, for example, when a particular ...
16:50 28-Feb-2017
DatabaseWeekly - Newsletter
When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous ...
16:42 28-Feb-2017
DatabaseWeekly - Newsletter
Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal ...
16:42 28-Feb-2017
DatabaseWeekly - Newsletter
We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do ...
16:42 28-Feb-2017
SQLServerCentral - Questions
I have a table: CREATE TABLE #SingleSELECTFromMultiRecords( [ID] INT IDENTITY(1,1) NOT NULL, [REASON][VARCHAR](500), [To][VARCHAR](500), ...
16:14 28-Feb-2017
DatabaseWeekly - Newsletter
Azure provides an idea platform for hosting microservices because it offers a number of managed services that allow developers to create microservices ...
15:42 28-Feb-2017
DatabaseWeekly - Newsletter
With SQL Clone, developers can even create and delete their own database clones, whenever they need to, based on images the DBA provides. Suddenly, the ...
15:42 28-Feb-2017
DatabaseWeekly - Newsletter
CloudPets left their MongoDB database, containing over 2 million kids' voice messages, exposed publicly ...
15:42 28-Feb-2017
SQLServerCentral - Blogs
In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the values you’re dealing with for the estimated ...
15:08 28-Feb-2017
SQLServerCentral - Blogs
In this module you will learn how to use the Long Text Viewer Power BI Custom Visual.  The Long Text Viewer visual helps in displaying longer text fields ...
15:00 28-Feb-2017
SQLServerCentral - Questions
Hi, I have SQL Server 2016 SP1 with a linked server Oracle 12c Linked Server. Most queries work fine, but there is an issue with Image data. In some ...
13:07 28-Feb-2017
SQLServerCentral - Blogs
A couple of weeks back I installed SQL Server 2016 on my personal machine, including SSAS Tabular. Yesterday I created a new Tabular model project in ...
13:00 28-Feb-2017
Simple-Talk - SQL Articles
We all know how easy it is to run R, together with dependent packages, from SQL Server on order to ...
09:16 28-Feb-2017
SQLServerCentral - Editorials
Steve Jones comments on containers and their suitability for databases.
00:00 28-Feb-2017
SQLServerCentral - Main Articles
To upgrade or migrate, that is the question. And I have an answer.
00:00 28-Feb-2017
SQLServerCentral - Main Articles
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
00:00 28-Feb-2017
SQLServerCentral - Questions
we are upgrading to sql server 2016 sp1. i wanted to ask, would log shipping work if primary server is sql 2016 sp1 enterprise edition and secondary ...
19:30 27-Feb-2017