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
Hello, recently we upgraded SQL Server 2005 to SQL Server 2008R2 along with SSRS. for database side every thing is running but from SSRS end there was ...
12:58 03-Sep-2015
Simple-Talk - Blogs
As my colleague James said in a recent blog post: “If you share a database with other developers, chances are you've encountered a situation like ...
12:19 03-Sep-2015
SQLServerCentral - Questions
Hi All, Need help in creating a server role which grants like 'DBCC Commands' and privileges to create 'jobs'.
04:34 03-Sep-2015
SQLServerCentral - Editorials
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
23:00 02-Sep-2015
SQLServerCentral - Main Articles
Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing ...
23:00 02-Sep-2015
SQLServerCentral - Main Articles
Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep ...
23:00 02-Sep-2015
SQLServerCentral - Blogs
Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/. ...
22:57 02-Sep-2015
SQLServerCentral - Blogs
Temporal tables were included in SQL Server 2016 as a new feature. These temporal tables are also known as system-versioned tables allow SQL Server for ...
22:28 02-Sep-2015
SQLServerCentral - Blogs
SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard ...
21:13 02-Sep-2015
SQLServerCentral - Questions
The instructor is asking me to write a query that will return all the DirectorIDs who are living in the same address locality.** PLEASE HELP! DirectorID ...
18:50 02-Sep-2015
SQLServerCentral - Questions
I have to delete data from 7 large tables. Adding non-clustered indexes speed up the process but I was told that setting up indexes occupy a lot of space. ...
17:20 02-Sep-2015
SQLServerCentral - Blogs
Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new ones? ...
16:13 02-Sep-2015
SQLServerCentral - Questions
Experts, I am running into an issue with a set of my SSIS packages and need help on this. one of my SSIS package has a script component which refers ...
15:53 02-Sep-2015
SQLServerCentral - Questions
Hi I have queries in our database relying on linked servers. In the test environment I therefore have views / queries similar to SELECT name FROM [TESTSERVER\TESTINSTANCE].testdb.dbo.employee ...
14:52 02-Sep-2015
SQLServerCentral - Questions
link text [link text][1] Hi! I have the following proc with different inputs for the spoc_setcontextinfo. With User1 the result is returned in no more ...
14:29 02-Sep-2015
SQLServerCentral - Blogs
Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool: https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes... Tags: Sql ...
14:16 02-Sep-2015
SQLServerCentral - Blogs
Reading Time: 2 minutes Who can do what? One of the key things that a DBA... The post Checking for Excessive Permissions in SQL Server appeared first ...
13:45 02-Sep-2015
SQLServerCentral - Blogs
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me! I’ll be speaking at the newly merged ...
11:46 02-Sep-2015
SQLServerCentral - Blogs
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ...
11:00 02-Sep-2015
SQLServerCentral - Blogs
I have the great pleasure to announce that I have been nominated for the "Author of the Year 2015" award at the MSSQLTips website. This means however ...
11:00 02-Sep-2015
SQLServerCentral - Blogs
Today will be the first of a few introductory level posts about Extended Events. When dealing with Extended Events, there are a few ways to take a look ...
10:58 02-Sep-2015
SQLServerCentral - Questions
Can we install SQL Server 2005 32 bit enterprise edition in windows server 2008 64 bit?
10:38 02-Sep-2015
SQLServerCentral - Blogs
Remember that blog post from April this year that I announced working on my first ever SQL Server related book "Pro SQL Server Wait Statistics"? Well ...
05:48 02-Sep-2015
SQLServerCentral - Blogs
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated. This article will show you how you can ...
05:41 02-Sep-2015
SQLServerCentral - Questions
Table has around 5 million rows with unclustered index on picktime (datetime) column. I selected rows from table using two different ways. Execution plan's ...
04:32 02-Sep-2015
SQLServerCentral - Blogs
If you've read my blog for a while you may have seen the following posts: Ten MDX Calculations For Your Cube (part 1) Ten MDX Calculations For Your Cube ...
01:30 02-Sep-2015
SQLServerCentral - Editorials
Gone off the Rails.
23:00 01-Sep-2015
SQLServerCentral - Main Articles
In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ...
23:00 01-Sep-2015
SQLServerCentral - Main Articles
With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can download ...
23:00 01-Sep-2015
DatabaseWeekly - Newsletter
Let's take a closer look at how we can speed up the system's performance using the Buffer Pool Extension. For testing I will use a virtual machine with ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Office 2016 is on the verge of being released, and although Power BI is the cool new thing Excel 2016 has added several new BI-related features too. What ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Intro In this article we will see how you can combine NoSQL and relational concepts in SQL Server database. We will see how you can transform tables to ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
In this post, How to Remove All Characters From a String Using T-SQL? we have seen How to Remove All Characters From a String Using T-SQL. But it only ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
The default instance actually has an instance name. It's MSSQLSERVER. This is probably familiar to a lot of you but hold on because I'm going to go a ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based on the users executing those ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
One of the coolest things in SQL Server 2016 is Live Query Statistics (LQS). But did you know that it's available in SQL 2014? The thing is that we haven't ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
I get asked this question frequently by customers. Figured I would share my thoughts on the topic with you guys, and some links to some helpful resources.   First ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences ...
19:49 01-Sep-2015