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 an application and backend is SQL Server in Local Server and in Cloud Server. Now I am using one application and I want to transfer all the data ...
16:28 02-Jul-2015
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How many of you can define ...
15:39 02-Jul-2015
SQLServerCentral - Questions
Hi, I have one SQL login XXX with db reader and db writer permissions on the database. What permissin is required for XXX to run Select Grant on other ...
14:54 02-Jul-2015
SQLServerCentral - Questions
/* Respected Techie, May i get your valuable help on below scenario. I am trying to get sum of net product sales for each sales_person for each month ...
12:33 02-Jul-2015
SQLServerCentral - Blogs
A world-class violinist was on campus for an artist-in-residence program. While at lunch he was discussing what he perceived to be the similarities between ...
12:00 02-Jul-2015
SQLServerCentral - Blogs
I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me a reason to use Azure here and there to ...
11:58 02-Jul-2015
SQLServerCentral - Questions
Please refer the below statement where I am getting the eror like Msg 8152, Level 16, State 13, Procedure ...
11:48 02-Jul-2015
DatabaseWeekly - Newsletter
Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows ...
11:47 02-Jul-2015
SQLServerCentral - Blogs
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of  the Microsoft BI platform is ...
10:55 02-Jul-2015
SQLServerCentral - Questions
I am fetching data from a table on the basis of few parameters which are used in a where clause for filter criteria. The Parameters are number of days ...
10:03 02-Jul-2015
SQLServerCentral - Questions
i want to import a text file in ssis by applying substring function on the text file itself.is this ...
09:37 02-Jul-2015
SQLServerCentral - Blogs
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. ...
07:53 02-Jul-2015
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 - Editorials
Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.
23:00 01-Jul-2015
SQLServerCentral - Main Articles
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
23:00 01-Jul-2015
SQLServerCentral - Main Articles
Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.
23:00 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 - Blogs
Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it had a status of “pending” Not helpful! I ...
16:57 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