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
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
Brian Harry talks about the TFS 2015 Update 2 RC 1 and VS 2015 Update 2 CTP1.
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
Quality is an underappreciated aspect of data models. In this blog post, Michael Blaha discusses quality for day-to-day operational applications.
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
DatabaseWeekly - Newsletter
Creating SQL logins on a single SQL Server is easy, you can simply open up SQL Server Management Studio, right click on the Security folder and choose ...
16:42 12-Feb-2016
DatabaseWeekly - Newsletter
This article gives an overview of the Microsoft Azure SQL Data Warehouse architecture. The new platform-as-a service (PaaS) offering provides independent ...
16:42 12-Feb-2016
DatabaseWeekly - Newsletter
There are several ways to ensure unique records in an Oracle table, but are some better than others? David Fitzjarrell takes a look at how the different ...
16:42 12-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 ...
15:42 12-Feb-2016
DatabaseWeekly - Newsletter
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialised tools that have dominated ...
15:42 12-Feb-2016
DatabaseWeekly - Newsletter
Sometimes you need some functionality in your database build process that isn't quite available. Visual Studio Database projects don't have great ways ...
15: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. 8 must-have SQL Server toolsThe SQL Developer ...
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
SQLServerCentral - Editorials
Steve Jones talks about the timeframes for updating and fixing security problems in applications. New DLM Dashboard - free toolWhen ...
00:00 11-Feb-2016