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
Can we use instead of delete and after delete trigger together?
19:15 04-Aug-2015
SQLServerCentral - Questions
I'm trying to compare two points on a map using SQL Server. I use geography::Point to create the actual point and do my calculations. However, when ...
17:27 04-Aug-2015
SQLServerCentral - Blogs
17:04 04-Aug-2015
SQLServerCentral - Blogs
Machine Learning Data Sets When starting out with data mining and machine learning you will need to have access to sample data in order to learn the technology.  ...
15:31 04-Aug-2015
SQLServerCentral - Questions
Hello, I like to have an image with Windows 2012 R2 and SQL Server 2012 installed and apply it to 2 VMs. Will SQL Server work? What do I need to do ...
15:29 04-Aug-2015
SQLServerCentral - Questions
i have a data something like this. 70.6 70.60 70.60 70.60 70.70 i can't used varchar as i need to perform arithmatic operation (> or floor) when ...
14:41 04-Aug-2015
SQLServerCentral - Blogs
How to Keep Up With SQL Server ran as the editorial of the day on July 31st. Modest amount of comments, but in particular I made a note to come back to ...
13:00 04-Aug-2015
SQLServerCentral - Blogs
One of benefits, among several, in moving to Kentucky is the close proximity to several SQL Saturday events.  I am honored to have been selected to speak ...
12:30 04-Aug-2015
SQLServerCentral - Blogs
During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know the answer to. The question was, ...
12:00 04-Aug-2015
SQLServerCentral - Blogs
If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a login is.  However, did you know that you can access resources ...
10:52 04-Aug-2015
SQLServerCentral - Blogs
As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in ...
09:30 04-Aug-2015
SQLServerCentral - Blogs
This great book by Ricardo Semler is something that some of my friends have been recommending me to read for years. I have constantly have heard that ...
09:24 04-Aug-2015
SQLServerCentral - Questions
One of the daily processes in our manufacturing firm is to extract data from several tables from our SQL Server databases using SSRS. The results are ...
02:39 04-Aug-2015
SQLServerCentral - Blogs
As was recently promised, I have an update to an old tried and true script for calculating the size of an object. That promise was doled out in the previous ...
02:35 04-Aug-2015
Simple-Talk - .NET Articles
Behaviour Driven Development requires the use of ubiquitous language to clearly state the requirements ...
by Sunil Pardasani
00:00 04-Aug-2015
SQLServerCentral - Questions
I have two servers, Server A and Server B. I have linked server between Server A and Server B. I have SAME JOBS on Server A and Server B. I need TSQL ...
23:13 03-Aug-2015
SQLServerCentral - Editorials
The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.
23:00 03-Aug-2015
SQLServerCentral - Main Articles
In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we ...
23:00 03-Aug-2015
SQLServerCentral - Main Articles
There are unique considerations that apply to virtual machines that run SQL Server workloads in such ...
23:00 03-Aug-2015
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw someone recently ask ...
19:02 03-Aug-2015
SQLServerCentral - Blogs
I ran into a question recently about how to clear out a database of all objects. I assume someone was testing some type of deployment scenario, and didn’t ...
16:44 03-Aug-2015
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The DAC is a really important ...
15:42 03-Aug-2015
SQLServerCentral - Questions
I have created a filestream as Microsoft has described to do by making the "GUID" the primary key, as shown here. CREATE TABLE [dbo].[RCWFileStream]( ...
15:11 03-Aug-2015
SQLServerCentral - Blogs
Hi friends, in our day to day work we used SELECT.INTO clause to create replica of a table for different …Continue reading →
14:28 03-Aug-2015
SQLServerCentral - Questions
Always create the FILESTREAM data container which will be used by the FILESTREAM enabled database in a separate volume. Does this mean, as an example: ...
14:26 03-Aug-2015
SQLServerCentral - Blogs
It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is a good chance to catch ...
14:00 03-Aug-2015
SQLServerCentral - Blogs
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The primary reason for this is to get the ...
12:54 03-Aug-2015
SQLServerCentral - Blogs
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF versions at the bottom.) Download ...
11:00 03-Aug-2015
SQLServerCentral - Blogs
If you've used SSIS for any significant amount of time, you've almost certainly run into this roadblock: You need to download a file stored on an SFTP ...
11:00 03-Aug-2015
SQLServerCentral - Blogs
Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here are two options to consider. Single ...
08:59 03-Aug-2015
SQLServerCentral - Blogs
Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate ...
08:50 03-Aug-2015
SQLServerCentral - Questions
I do a Full Backup every day of my Database. I am trying to use the previous Full backup to set up an additionnal Differential Backup, how can I do this? ...
07:56 03-Aug-2015
SQLServerCentral - Blogs
One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed ...
04:00 03-Aug-2015
SQLServerCentral - Questions
I'm trying to create a comma separated table by running the below query but this query has been running for 8 hours and I still don't have any records ...
02:45 03-Aug-2015
Simple-Talk - Cloud Articles
In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based ...
by Robert Sheldon
00:00 03-Aug-2015
SQLServerCentral - Editorials
Today Steve Jones talks about the impressions we make as career minded individuals. How to track every change to your SQL Server databaseSee ...
23:00 02-Aug-2015
SQLServerCentral - Main Articles
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
23:00 02-Aug-2015
SQLServerCentral - Main Articles
References and links to learn more about columnstore indexes.
23:00 02-Aug-2015
SQLServerCentral - Main Articles
SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between ...
23:00 02-Aug-2015