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
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]( [Id] ...
15:11 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
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.
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
SQLServerCentral - Blogs
I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using SP3’s that this may actually be helpful ...
20:44 02-Aug-2015
SQLServerCentral - Blogs
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit 2015,  and now  when I hear back ...
20:20 02-Aug-2015
SQLServerCentral - Blogs
It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not). If you haven’t already, follow ...
03:59 02-Aug-2015
SQLServerCentral - Questions
Hello Techie, please help me on this. i am trying to check if .two decimal value not in a column using this. FLOOR(LOG10(REVERSE(ABS(M.Description_12_Value)+1)))+1 ...
16:26 01-Aug-2015
SQLServerCentral - Blogs
I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL slide deck (PDF). Here is an older recording ...
15:09 01-Aug-2015
SQLServerCentral - Questions
I have two tables that each have a latitude and Longitude. One table has 1691 (TableA) records and the other 5778 (TableB) records. Each record has a ...
22:24 31-Jul-2015
SQLServerCentral - Questions
Hello, I am trying to use a Stored Procedure to include multiple Create View but I have no luck getting to work. Please See below for a sample. ...
16:47 31-Jul-2015
DatabaseWeekly - Newsletter
An ETL offload solution addresses the challenges of data overload, rising costs, and the skills gap.
16:47 31-Jul-2015
SQLServerCentral - Questions
I have run a script that shows SQL suggested indexes which will increase performance greatly. A few of the indexes have the same keys but different INCLUDE ...
15:05 31-Jul-2015
SQLServerCentral - Questions
I would like to use SSIS -- not Transactional Replication -- to transfer data between various servers, where the data tables have Identity columns. I ...
14:52 31-Jul-2015
DatabaseWeekly - Newsletter
Steve Jones explains his approach to creating and managing passwords for SQL Server service accounts.
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
Highlight blocks of code, hide or display the results pane, open up a context sensitive suggestions dropdown, and more.
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
Tim Mitchell describes what synchronous script transformation processing is, and shows an example of how to use it in an SSIS package.
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
A common question we encounter when working with SQL Source Control is about database permissions. Different environments require different permissions, ...
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
Some sins are perpetrated before even a single line of code is written. Setting up your development environment in the wrong way can harm SQL Server (and ...
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
The idea of 'instrumenting' an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers ...
13:47 31-Jul-2015
DatabaseWeekly - Newsletter
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with so many ways of aggregating, ...
13:47 31-Jul-2015
SQLServerCentral - Blogs
Reading Time: 2 minutes Kon!!!!!! In WOxPod!, episode # 014 - “Kon Melamud” Today we have... The post 014 -Kon Melamud appeared first on WaterOx ...
12:30 31-Jul-2015
DatabaseWeekly - Newsletter
PowerShell Direct lets you breach the boundary between hypervisor host and guest virtual machine in a secure way to issue PowerShell cmdlets and run scripts ...
11:47 31-Jul-2015
DatabaseWeekly - Newsletter
A couple of quick "how to" scenarios on using SSMS to look at Query Store data on Azure SQL Database V12.
11:47 31-Jul-2015
DatabaseWeekly - Newsletter
Booby-trapped MMS messages and websites exploit flaw in heart of Android.
11:47 31-Jul-2015
DatabaseWeekly - Newsletter
One of the most compelling features in PowerShell is how easy it is to extend it. You're not limited to whatever a cmdlet writes to the pipeline. You ...
11:47 31-Jul-2015
DatabaseWeekly - Newsletter
Your very own personal assistant, a better browser... and something called the Start menu.
11:47 31-Jul-2015
Simple-Talk - Blogs
The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers ...
11:10 31-Jul-2015