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
Is it possible to connect together SQL query 45 MDF LDF DETABESE to get report in excel one short in 45 sheets.
10:02 30-Jun-2015
SQLServerCentral - Questions
We have implemented our software in SQL server 2008 r2 Standard DB. Client has bought Sql server 2014 standard. I believe r2 will work on 2014. But I ...
03:17 30-Jun-2015
SQLServerCentral - Editorials
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
23:00 29-Jun-2015
SQLServerCentral - Main Articles
One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps ...
23:00 29-Jun-2015
SQLServerCentral - Main Articles
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. ...
23:00 29-Jun-2015
SQLServerCentral - Blogs
It's this time of the year again, when PASS announces the speakers in the biggest SQL Server event in the world - PASS Summit. Like many others, I submitted ...
20:45 29-Jun-2015
SQLServerCentral - Questions
Respected Sirs, I wanted to know which is the best book now in markt for SQL 2012 writing queries. I am Low to medium in SQL Queries But wanted to become ...
17:31 29-Jun-2015
DatabaseWeekly - Newsletter
A new course from Code School. ?Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write ...
15:46 29-Jun-2015
Simple-Talk - Blogs
If you share a database with other developers, chances are you've encountered a situation like this: 1. Alice starts editing an object. 2. Meanwhile, ...
15:10 29-Jun-2015
SQLServerCentral - Blogs
I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high availability, and independent consulting topics. I had ...
14:20 29-Jun-2015
SQLServerCentral - Blogs
Reading Time: 1 minutes Let’s Play A Game! So, just to tickle your fancy, here is... The post Sneak Preview – Podcast 010 appeared first on ...
12:30 29-Jun-2015
SQLServerCentral - Blogs
Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been ...
11:59 29-Jun-2015
SQLServerCentral - Blogs
A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously sat me down and talked. ...
11:10 29-Jun-2015
SQLServerCentral - Blogs
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS Summit. Well as I’m sure you are aware the selected ...
11:00 29-Jun-2015
SQLServerCentral - Blogs
A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were ...
10:40 29-Jun-2015
SQLServerCentral - Questions
id date diffdays 1 1/1/2015 0 1 1/2/2015 1 1 1/4/2015 2 2 1/1/2015 0 2 1/10/2015 9![alt text][1] 2 2/4/2015 25 ...
10:19 29-Jun-2015
SQLServerCentral - Questions
any one tell me plz
07:40 29-Jun-2015
SQLServerCentral - Blogs
Hi All, Major expectation raised by user for SharePoint other then Search ,is to have Good User Experience ...
04:50 29-Jun-2015
Simple-Talk - Opinion and Geeks
DevOps isn't a particular technology, nor a job role. It is more of a software development method, initiating originally from system administrators, that ...
by Adam Bertram
00:00 29-Jun-2015
SQLServerCentral - Editorials
Steve Jones has a new take on what it means to be a DBA.
23:00 28-Jun-2015
SQLServerCentral - Main Articles
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK ...
23:00 28-Jun-2015
SQLServerCentral - Main Articles
References and links to help you learn how to create multiple tempdb files.
23:00 28-Jun-2015
SQLServerCentral - Main Articles
Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, ...
23:00 28-Jun-2015
SQLServerCentral - Blogs
Continuation from the previous 56 parts, the whole series can be found at http://www.nikoport.com/columnstore/ In this post I want to focus on a very ...
19:03 28-Jun-2015
SQLServerCentral - Questions
1. How do i check to see if a table in a foxpro database is corrupted? 2. What is the best way to this test? I want to do this check before retrieval ...
16:00 28-Jun-2015
SQLServerCentral - Questions
I have a ssis package deployed and created a sql agent job which executes the package.I need to change ...
13:23 28-Jun-2015
SQLServerCentral - Blogs
I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I can’t get a real sleep, no matter how ...
13:14 28-Jun-2015
SQLServerCentral - Blogs
In my previous post in the series, I provided a short explanation on how to register your very first Azure DocumentDB account and play around in the Azure ...
06:18 28-Jun-2015
SQLServerCentral - Questions
i have a job scheduled, and it trigger a main when ever rowcount in the query is > 0 IF @@ROWCOUNT > 0 BEGIN EXEC msdb.dbo.sp_send_dbmail @profile_name ...
11:56 27-Jun-2015
SQLServerCentral - Questions
My SQL2000 server crashed, and I was able to recover the data and log files. I had to reinstall from scratch after that. I found that I can use the sp_attach_db ...
09:14 27-Jun-2015
SQLServerCentral - Questions
hi i am using a modem which gives me machine data in FTP server in .CSV format. no i want to pull this data to my SQL database server for online machine ...
06:02 27-Jun-2015
SQLServerCentral - Blogs
The PASS Summit 2015 Speaker list has been released and I wanted to congratulate everyone that was accepted. It's a great honor and I'm proud to be on ...
20:38 26-Jun-2015
SQLServerCentral - Questions
i have the following script that I run to check for any missing database backups. How can I get the output file to be emailed to me? SELECT ...
17:42 26-Jun-2015
SQLServerCentral - Questions
Hi, Professional, can Someone help me for this case? I like to get a total sales for posted 14 days for each day of last week. For Example, last week ...
17:27 26-Jun-2015
DatabaseWeekly - Newsletter
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database ...
16:46 26-Jun-2015
DatabaseWeekly - Newsletter
While investigating backup failure related issue on SQL SERVER 2008 R2 I was trying to pull the backup ...
16:46 26-Jun-2015
DatabaseWeekly - Newsletter
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies are a good ...
16:46 26-Jun-2015
DatabaseWeekly - Newsletter
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you have created these type of columns ...
16:46 26-Jun-2015
SQLServerCentral - Questions
Hi, I have table Samplebrowser It have Emailid,Browser Column Emailid have duplicates with browser column ![alt text][1] My Expected result would ...
15:43 26-Jun-2015