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'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
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
DatabaseWeekly - Newsletter
As with any technology, the "mileage" you get from NoSQL varies depending on your team's expertise and culture. As Uber's recent switch from PostgreSQL ...
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
Pinal Dave describes how to write directly to sparse column sets.
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
A script to save to an Excel file the database file properties for all databases for all the databases that are in the SQL Server instance.
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
The cloud is ready for SQL Server enterprise-grade workloads. This is not my opinion but a simple fact that comes from helping multiple clients in different ...
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
The question was "What is the significance of NULL in SQL?" and most of the existing answers went on about citing C.J. Date or Tony Hoare and unanimously ...
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
How train companies derive insights and value from the data of trains, rail infrastructure, and operations. In essence, this means automatically gathering ...
10:47 31-Jul-2015
DatabaseWeekly - Newsletter
Windows PowerShell console process name is PowerShell. No problem. Except that I often have multiple instances of Windows PowerShell running, and quite ...
10:47 31-Jul-2015
SQLServerCentral - Blogs
Don't tell me that you didn't see it coming: at some point, Developers end up being put to hell by a DBA! I don't want to enter the DBA/Developer wars, ...
09:35 31-Jul-2015
SQLServerCentral - Blogs
This is a first article in a series of articles about real life database and IT infrastructure migration ...
07:25 31-Jul-2015
SQLServerCentral - Questions
Hello, all. We use SQL Server 2008r2 and a database failed to start. I want to restore the database but i need a help, how to do this. Thanks in advance ...
06:38 31-Jul-2015