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 - Blogs
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a ...
00:10 02-Jul-2015
SQLServerCentral - Questions
Hello, I would like to add two records from two tables using UNION (or other techniques). CAT C1 C2 C3 C4 AA 1 ...
23:03 01-Jul-2015
SQLServerCentral - Questions
TABLE DEFINITION Column Name Comments CustomerID INT SequenceNo INT Comments VARCHAR(MAX) CUSTOMER TABLE CustomerID SequenceNo Comments ...
20:41 01-Jul-2015
SQLServerCentral - Questions
I am getting the Following Error when i try to run a update to match data from my temp table created. Msg 4104, Level 16, State 1, Line 3 The multi-part ...
18:36 01-Jul-2015
SQLServerCentral - Blogs
In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who ...
18:19 01-Jul-2015
SQLServerCentral - Blogs
Today I received an email notifying me that I have been awarded the Microsoft "MVP" award for my second year. An excerpt from Microsoft's website states "The ...
18:17 01-Jul-2015
SQLServerCentral - Blogs
How to Grant limited permissions to create views in another schema? In SQL Server 2005 and 2008R2 you can grant permissions at the schema level and, in ...
17:46 01-Jul-2015
SQLServerCentral - Questions
IBrief Summary: W&I's Enterprise Telephone Database (ETD) stores data about IRS call center activity. ...
15:43 01-Jul-2015
SQLServerCentral - Questions
![alt text][1] [1]: /storage/temp/2548-capture.png
14:52 01-Jul-2015
DatabaseWeekly - Newsletter
Fortunately there is a simple way to reduce the quantity of T-SQL that SMO needs to do its job. You'll just need to specify the default initial fields ...
14:47 01-Jul-2015
DatabaseWeekly - Newsletter
This is the 3rd in a multi-part series titled "On the Forensic Trail". My goal with this series is to introduce my PowerShell Forensics module called ...
14:47 01-Jul-2015
DatabaseWeekly - Newsletter
Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been ...
14:47 01-Jul-2015
DatabaseWeekly - Newsletter
SQL Server 2016 will be coming with Temporal Data support following the ANSI SQL 2011 standard. This will add support for Temporal Tables as a Database ...
14:47 01-Jul-2015
DatabaseWeekly - Newsletter
Adam Bertrand answers the four most common questions that IT Pro's wonder about DevOps , but seldom ask publicly.
14:47 01-Jul-2015
SQLServerCentral - Questions
I have 5 tables and I want a report Division wise : Div_name in Div_master is common to Div_Name in mst_Product ![alt text][1] Product_id is common ...
14:43 01-Jul-2015
SQLServerCentral - Blogs
Polyglot Persistence is a fancy term to mean that when storing data, it us best to use multiple data storage technologies, chosen based upon the way data ...
14:00 01-Jul-2015
SQLServerCentral - Blogs
Reading Time: 2 minutes Seattle, here we come! I am excited, and honored that it is... The post Speaking at PASS Summit 2015 & SQL Live360! appeared ...
13:30 01-Jul-2015
SQLServerCentral - Blogs
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post. I wrote recently ...
13:19 01-Jul-2015
SQLServerCentral - Questions
How would I get to know which data modelling we use in our project?
13:17 01-Jul-2015
DatabaseWeekly - Newsletter
NULLs in SQL are a mixed blessing.The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. ...
12:47 01-Jul-2015
SQLServerCentral - Questions
Hi Friends, We are using SQL Server 2014 on Windows server 2008 Web edition (64 bit). Total RAM of OS is 8 GB .When we check high ...
12:21 01-Jul-2015
SQLServerCentral - Blogs
I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ...
12:00 01-Jul-2015
SQLServerCentral - Blogs
As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make your way into the building where you are ...
11:15 01-Jul-2015
SQLServerCentral - Blogs
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then ...
11:00 01-Jul-2015
Simple-Talk - SysAdmin Articles
By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process ...
by Nicolas Prigent
00:00 01-Jul-2015
SQLServerCentral - Editorials
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
23:00 30-Jun-2015
SQLServerCentral - Main Articles
In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.
23:00 30-Jun-2015
SQLServerCentral - Main Articles
Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this ...
23:00 30-Jun-2015
SQLServerCentral - Main Articles
Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is ...
23:00 30-Jun-2015
SQLServerCentral - Blogs
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing. This is an example ...
18:00 30-Jun-2015
SQLServerCentral - Questions
SQL Newbie here. I've inherited some older SQL Servers at my new job. I've been checking out their current maintenance plans and came across the following: ...
16:23 30-Jun-2015
SQLServerCentral - Blogs
I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training ...
12:38 30-Jun-2015
DatabaseWeekly - Newsletter
You want to implement Continuous Integration for Databases and you know why, but you need to get buy-in from your managers and colleagues. How do you ...
11:46 30-Jun-2015
SQLServerCentral - Questions
I am trying to build a table detailing historical price changes from a system extract that has generated an audit line every time a change has been made ...
11:35 30-Jun-2015
SQLServerCentral - Blogs
By Steve Bolton ....It may be called Minitab, but SQL Server users can derive maximum benefits from ...
11:02 30-Jun-2015
SQLServerCentral - Blogs
I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek Two of the points ...
11:00 30-Jun-2015
Simple-Talk - Blogs
Microsoft have now publicly announced that they will release Visual Studio 2015 (along with .NET 4.6 and TFS 2015) on July 20th. Redgate is a SimShip ...
10:33 30-Jun-2015
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