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
The instructor is asking me to write a query that will return all the Director IDs who are living in the same address locality. I was given the below ...
18:59 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
DatabaseWeekly - Newsletter
An Australian reporter for the ABC, Will Ockenden published a bunch of his metadata, and asked people to derive various elements of his life. They did ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
I just wrote a post about Live Query Statistics. Let me show you how this technology in SQL Server 2014 can be used for some amazingly cool (nerdy cool, ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Microsoft, Google, Mozilla, Cisco, Intel, Netflix, and Amazon today launched a new consortium, the Alliance for Open Media. The group plans to develop ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
It's tempting to think that table partitioning will improve query performance. After all, it's an Enterprise Edition feature- it must have a lot of magic, ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
In SQL 2014 and above, you can create memory optimized tables with In-Memory OLTP feature.   When you use this feature, SQL Server actually generates ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Entity Framework 6 was not designed from the start to work with the Always Encrypted feature of SQL Server 2016. However, a lot of effort has gone into ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Tackling A Hairy Problem This series includes a number of stand-alone posts which can fit together to tell a bigger story Part One: Types of Performance ...
19:49 01-Sep-2015