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


DatabaseWeekly - Newsletter
The goal for Cerego-enhanced online learning is to help users capture knowledge - and to do it faster and hold on to it longer.
19:42 13-Feb-2016
DatabaseWeekly - Newsletter
It's easy to get caught up in daily incidents, tickets, and special projects. Like a good scout, though, a core task in a DBA's job is to be prepared.
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better ...
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses ...
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
Microsoft is making previews of some services for its Azure Stack hybrid preview. It's also offering a roadmap for Windows Azure Pack, a predecessor to ...
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
Power BI "publish to web" allows you to easily expose a Power BI report to the world through an iframe that can be embedded wherever you like.
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
Unless the size of your log file is causing you some dramatic pain, leave it alone.
08:42 13-Feb-2016
DatabaseWeekly - Newsletter
According to Foote Partners, IT job growth in January 2016 was the worst in nearly a year and a half, but extra pay inched up at the end of 2015.
08:42 13-Feb-2016
SQLServerCentral - Blogs
By Steve Bolton ....As I've cautioned before, I'm writing this series of amateur self-tutorials in order to learn how to use SQL Server to perform goodness-of-fit ...
02:19 13-Feb-2016
SQLServerCentral - Questions
SELECT date_created FROM table gives me columns of data like this: 1312912118 So I did this: SELECT (date_created/86400)+25569 FROM table gives me date ...
00:00 13-Feb-2016
DatabaseWeekly - Newsletter
Nitish Upreti looks at bulk-copying data protected with Always Encrypted, Microsoft's SQL platform that protects sensitive data in use (during transactions ...
18:42 12-Feb-2016
DatabaseWeekly - Newsletter
Corey Romero at VMware announces the 2016 vExperts - those that have demonstrated significant contributions to the community and a willingness to share ...
18:42 12-Feb-2016
DatabaseWeekly - Newsletter
Derek Wilson explains how he determined that your best chance of sighting a creature is to go to Urquhart in the month of August.
18:42 12-Feb-2016
DatabaseWeekly - Newsletter
You can still do Database Lifecycle Management (DLM) workflows in the hosted version of Team foundation Server (TFS) in Visual Studio Team Services (VSTS) ...
18:42 12-Feb-2016
DatabaseWeekly - Newsletter
Peter Elzinga presents an SSIS-based solution for automatically generating Excel files from SQL files that involves minimum effort and maintenance.
18:42 12-Feb-2016
DatabaseWeekly - Newsletter
Cody Konoir shares a short cautionary tale about the importance of rebooting after a SQL Server install.
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. ...
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
Warner Chaves gives an overview of SQL Server's Mobile Report Publisher. He looks at what it is, how it's different to SSRS Report Builder, and how to ...
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
Every year Microsoft invites a select group of students to become on-campus insiders and serve as a communication point for all of the latest Microsoft ...
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
Itzik Ben-Gan looks at the FROM clause, and within it more specifically, the JOIN table operator. He goes through the logical steps involved in a join, ...
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses ...
17:42 12-Feb-2016
DatabaseWeekly - Newsletter
Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.
17:42 12-Feb-2016
SQLServerCentral - Blogs
I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while (no travel is nice). However, I’m ...
13:23 12-Feb-2016
Simple-Talk - Blogs
Oh dear, this lot don’t look best pleased – but you could! Leave a caption in the comments, and if we think it’s the funniest of the ...
13:21 12-Feb-2016
SQLServerCentral - Blogs
I had to do some performance testing for an MSSQLTips article and I thought I'd share the framework I used in a blog post. First of all we have to log ...
13:00 12-Feb-2016
SQLServerCentral - Questions
Hi I have used SQL 2000 DTS PACKAGES. Last week it works correctly but today I faced following error [Microsoft][ODBC ...
12:17 12-Feb-2016
SQLServerCentral - Questions
i need to batch updates on a table from a stored procedure that is has user defined table types. The updates are causing table locking and i would like ...
11:04 12-Feb-2016
SQLServerCentral - Blogs
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables ...
03:06 12-Feb-2016
SQLServerCentral - Editorials
There's a push to upgrade those SQL Server 2005 instances with support ending this April.
00:00 12-Feb-2016
SQLServerCentral - Main Articles
If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on...
00:00 12-Feb-2016
SQLServerCentral - Main Articles
When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys ...
00:00 12-Feb-2016
SQLServerCentral - Main Articles
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. ...
00:00 12-Feb-2016
SQLServerCentral - Questions
Hi, Please be so kind as to point me in the right direction with regards to my SQL case select query: My case statement currently reads as follow: ...
18:11 11-Feb-2016
Simple-Talk - Blogs
“Does anyone actually do this stuff?” This question came from a member of the audience at one of Brent Ozar’s training classes on SQL ...
18:00 11-Feb-2016
SQLServerCentral - Questions
HI. I have a requirement to change the dbid of the database and increase the priority of the start up of the database.
16:49 11-Feb-2016
SQLServerCentral - Blogs
I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren't sure what was wrong. ...
16:43 11-Feb-2016
SQLServerCentral - Blogs
Text Mining with RapidMiner for Loch Ness Monster Sightings Text mining involves pulling root words from text in a system.  In this example, I pulled ...
12:33 11-Feb-2016
SQLServerCentral - Blogs
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents themselves. If you still haven't, be sure ...
09:25 11-Feb-2016
SQLServerCentral - Blogs
I've used Windows Live Writer for almost as long as I've been blogging (mid 2007 or so). It's worked well enough and I've liked having an offline editor. ...
01:56 11-Feb-2016