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
??/Q869520616???????????????????????????????? ??/Q869520616??USYD/UNSW/MQ/UTS/ Monash????????????????? ?.???????????????: ...
10:16 02-Sep-2015
SQLServerCentral - Questions
Q/??869520616????,??,???,????????,???,????????? Q/??869520616???????USC,????????????,???,????????? ????????????? ?????????????????????????????: ??????????????,??????,????????,???100%??? ????????(????????),??????????????? ?????????,?????,???????????? ????????,???????,????? ???:Nick ...
09:58 02-Sep-2015
SQLServerCentral - Questions
Q/??869520616????,??,???,????????,???,????????? Q/??869520616???????USC,????????????,???,????????? ????????????? ?????????????????????????????: ??????????????,??????,????????,???100%??? ????????(????????),??????????????? ?????????,?????,???????????? ????????,???????,????? ???:Nick ...
09:57 02-Sep-2015
SQLServerCentral - Questions
Q/??869520616????,??,???,????????,???,????????? Q/??869520616???????USC,????????????,???,????????? ????????????? ?????????????????????????????: ??????????????,??????,????????,???100%??? ????????(????????),??????????????? ?????????,?????,???????????? ????????,???????,????? ???:Nick ...
09:56 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
DatabaseWeekly - Newsletter
Dear friends, In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in practical session where we will try to ...
19:49 01-Sep-2015
DatabaseWeekly - Newsletter
Understanding the difference between row context and filter context is important to use DAX correctly. This article introduces you to these two concepts. Row ...
19:49 01-Sep-2015
SQLServerCentral - Blogs
I've been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with test data. Often each developer ...
15:42 01-Sep-2015
SQLServerCentral - Blogs
I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”. Go on and download ...
15:16 01-Sep-2015
SQLServerCentral - Questions
Hi Folks Good Morning/Evening I have a ssrs report that is built on sql server 2005. It has some input cascading parameters meaning a parent parameter ...
15:04 01-Sep-2015
SQLServerCentral - Questions
I'm attempting to check if a folder contains files or not (empty) using Script Task. Code works in VS 2009, but get 'Exception has been thrown by target ...
14:43 01-Sep-2015
SQLServerCentral - Questions
Here's the scenario: * We're building Powershell scripts to automatically build Azure Virtual Machine ...
14:26 01-Sep-2015
SQLServerCentral - Questions
I am testing how one of our stored procedure is working on `SQL Server Standard` vs `SQL Server Enterprise` editions. I have created two virtual machines ...
12:43 01-Sep-2015
SQLServerCentral - Blogs
I'm excited to be able to say that coming up next week on Thursday September 10, I'll be presenting ...
11:39 01-Sep-2015
SQLServerCentral - Blogs
The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow ...
11:21 01-Sep-2015