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
Hi Technet, I had successfully configured Log Shipping in a domain. In configuration manager, The SQL Server account (Both sql server and agent) are ...
11:47 26-Sep-2016
SQLServerCentral - Questions
I have a program where you can create new versions, which creates a copy of the current database and restore it as new database and i need the user to ...
10:07 26-Sep-2016
SQLServerCentral - Questions
I have an OLTP database using platform Sql Server 2012, This application issues certificate No when transaction completed. I have faced a problem two ...
07:35 26-Sep-2016
SQLServerCentral - Blogs
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for ...
06:36 26-Sep-2016
SQLServerCentral - Editorials
The world of machine learning and artificial intelligence are growing. Steve Jones notes this means we need to decide if we can trust the black boxes.
23:00 25-Sep-2016
SQLServerCentral - Main Articles
Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split ...
23:00 25-Sep-2016
SQLServerCentral - Main Articles
Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.
23:00 25-Sep-2016
SQLServerCentral - Blogs
This has bit a couple of clients recently, figured I'd put out a PSA.Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect ...
22:43 25-Sep-2016
SQLServerCentral - Questions
Dear all Please let me know why i'm not getting same results in below cases how to achieve without third variable declare @TaxName VARCHAR(30)=NULL, ...
09:51 25-Sep-2016
SQLServerCentral - Questions
Can I install SQL EXPRESS 2016 on Small Business server 2011?
08:58 25-Sep-2016
SQLServerCentral - Questions
i want to add days to date like that '31/12/2004' add one day to make it '01/01/2005' and remove a day ...
23:27 24-Sep-2016
SQLServerCentral - Blogs
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way ...
15:29 24-Sep-2016
SQLServerCentral - Blogs
This may feel very simple to many developers and yes it is, but I saw this request somewhere in community website.So thought of creating a very simple example.  Here ...
08:36 24-Sep-2016
SQLServerCentral - Questions
I'm trying to create a view that I can use to show long-term candlestick graphs. To do this, I have ...
03:55 24-Sep-2016
SQLServerCentral - Questions
Hello, My requirement is to write 2 datasets from database to same excel but to 2 different tabs. columns are dynamic so I used script component to write ...
21:46 23-Sep-2016
SQLServerCentral - Questions
County (CountyCode, CountyName) Constituency (ConstituencyCode, CountyCode, ConstituencyName) Using MS-SQL-Server, create the above database with its ...
20:50 23-Sep-2016
SQLServerCentral - Questions
I made a mistake in a DTS package (Enterprise Manager-SQL Server 2000) and now I want to correct it ...
20:24 23-Sep-2016
SQLServerCentral - Blogs
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people ...
20:20 23-Sep-2016
DatabaseWeekly - Newsletter
Recently I was asked by a developer whether they could use sp_rename to change the schema of a table. I said no but I realized that I don't know for sure ...
18:49 23-Sep-2016
DatabaseWeekly - Newsletter
The 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need for Continuous Integration (CI), the central ...
18:49 23-Sep-2016
DatabaseWeekly - Newsletter
Not only is putting an ORDER BY in a view considered a bad idea it has absolutely no effect.
18:49 23-Sep-2016
DatabaseWeekly - Newsletter
Lessons in speeding up restores after needing to restore a 5TB prod database to rebuild an AG node.
18:49 23-Sep-2016
DatabaseWeekly - Newsletter
The 5th cumulative update release for SQL Server 2012 SP3 is now available for download at the Microsoft Downloads site.
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
Data about data -- even from authoritative sources -- may not be as accurate as the people working on the project or the audience believe.
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
PSYaml is a simple PowerShell module that I've written that allows you to serialize PowerShell objects to "YAML Ain't Markup Language" (YAML) documents ...
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
If you need to open up your SQL Server on an Azure VM to public internet access, then the document "Connect ...
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
Data pages in a heap are NOT linked together, as there's no ordering in a heap.However, there is a special case when the data pages in a heap will become ...
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
The 14th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Downloads site.
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
Yahoo! Inc. said the personal information of at least 500 million users was stolen in an attack on its accounts in 2014, exposing a wide swath of its ...
17:49 23-Sep-2016
DatabaseWeekly - Newsletter
There are so many ways to look inside SQL Server. New extended events and dynamic management views are introduced every version. But if you want to collect ...
17:49 23-Sep-2016
SQLServerCentral - Questions
Consider the following relational database called "IEBC": Voter (IdNo, FirstName, LastName, Age, ConstituencyCode) County (CountyCode, CountyName) Constituency ...
16:34 23-Sep-2016
Simple-Talk - SysAdmin Articles
PSYaml is a simple PowerShell module that I've written that allows you to serialize PowerShell objects to “YAML Ain't Markup Language” (YAML) ...
16:10 23-Sep-2016
Simple-Talk - Blogs
PSYaml is a simple PowerShell module that I've written that allows you to serialize PowerShell objects to “YAML Ain't Markup Language” (YAML) ...
16:10 23-Sep-2016
SQLServerCentral - Questions
Hi Guys Greetings for the day, Can you please read my blog and answer. It is regarding a query running very slow in PROD against the DEV. Here is the ...
14:17 23-Sep-2016
SQLServerCentral - Blogs
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017 already live! Between 9th and 11th of ...
13:00 23-Sep-2016
SQLServerCentral - Blogs
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) ...
12:45 23-Sep-2016
SQLServerCentral - Blogs
I've been gone... wow. Since March 31st of this year?! Let's fix that.So what has been holding me back? Kids? I have three! 2, 15, 18. One wants ...
10:49 23-Sep-2016
SQLServerCentral - Blogs
Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the Learning Tree IAT...IAT stands for Instructor Advisory ...
10:30 23-Sep-2016
SQLServerCentral - Blogs
Filtered index is a type of non clustered index introduced in Sql Server 2008. As the name suggest filtered index is an optimized non clustered ...
08:23 23-Sep-2016