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
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you'll see is the ability to perform a database consistency check ...
19:54 03-Sep-2015
SQLServerCentral - Questions
Hi there, I'm trying to create and execute dynamic sql insert statements in TSQL2000 using the following code: DECLARE @number VARCHAR(100) ...
15:03 03-Sep-2015
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
SQLServerCentral - Blogs
A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the parties and events at PASS, with many of them limited ...
12:44 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 - Blogs
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime ...
11:00 03-Sep-2015
SQLServerCentral - Blogs
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata relevant to deployed Extended Event sessions. ...
10:06 03-Sep-2015
SQLServerCentral - Blogs
In this article I'd like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of Buffer Pool Extension. First of all ...
07:08 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
Who can do what? One of the key things that a DBA... The post Checking for Excessive Permissions in SQL Server appeared first on WaterOx Consulting. ...
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