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
SELECT id,name,date,IsGlobal FROM database..view where @PosType IN (0, 2) and IsGlobal=Case when @IsGlobal'-1' ...
09:10 28-Sep-2016
SQLServerCentral - Questions
when i select from my view in my database is much slower than i select that( database.schema.table) ...
08:17 28-Sep-2016
SQLServerCentral - Blogs
At Microsoft Ignite, it’s announced that very soon, we will be able to host Power BI Desktop files on-premise using Reporting Services. Watch the ...
06:13 28-Sep-2016
SQLServerCentral - Questions
I am running below script to find out the fragmentation percentage but its taking very long time for output to come. I have mentioned WITH NOLOCK as well. ...
06:07 28-Sep-2016
SQLServerCentral - Blogs
If you're a long time IT professional or an occasional user of high or even low tech software you'll know what I mean when I say "Bugs are not a new thing". Some ...
01:53 28-Sep-2016
SQLServerCentral - Blogs
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what's to come with a single language ...
00:57 28-Sep-2016
SQLServerCentral - Blogs
In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we will discussed about the most commonly ...
23:47 27-Sep-2016
SQLServerCentral - Editorials
Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer ...
23:00 27-Sep-2016
SQLServerCentral - Main Articles
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
23:00 27-Sep-2016
SQLServerCentral - Main Articles
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, ...
23:00 27-Sep-2016
SQLServerCentral - Main Articles
DBCC CHECKDB is a built-in SQL Server command that allows you to check database integrity and consistency in one simple command, but running it on large ...
23:00 27-Sep-2016
SQLServerCentral - Blogs
Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This ...
19:56 27-Sep-2016
SQLServerCentral - Questions
I have a SQL Server 2008 R2 database that has a table titled "Accessibility," which contains lookup data, for the sake of simplicity let's call it "High," ...
19:26 27-Sep-2016
SQLServerCentral - Blogs
In this post I will talk about the in-built refactoring support in SSDT - the language is slightly different from my normal style as originally it was ...
18:23 27-Sep-2016
DatabaseWeekly - Newsletter
With the upcoming general availability of Windows Server 2016, we are pleased to announce that Microsoft SQL Server 2016 will support deploying databases ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
I think many of us felt quite excited and the same time disappointed with In-Memory OLTP in SQL Server 2014. It was the great and promising technology ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
In this module you will learn how to use the Stream Graph chart Power BI Custom Visual.  The Stream Graph is similar to a Stacked Area Chart but has more ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
Every query tuner wants to explain exactly how much faster we made a query. But sometimes SQL Server Management Studio adds noticeable overhead to the ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
Compiles Aren't The Same As Recompiles If you're seeing high RECOMPILES, this post isn't for you. We'll talk about the differences between compiles and ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
Generally speaking, the best kind of Sort is one that is avoided completely. With careful indexing and sometimes some creative query writing, we can often ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking FSUTIL utility using SQL Windows ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
PASS Summit 2016 is fast approaching. If you're going, time to start making plans. If you're not going, sell your boss on the idea and get registered. ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
It's funny how easy it is to find information you aren't looking for. A few weeks back Stephen Bennett (b) linked to my post Comparing Two Query Plans. ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
As we head into our 8th SQLintersection next month, I'm excited to say that it's our most diverse, complete, and information-packed show yet! We have 3 ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
The Hortonworks Data Platform 2.5 sandbox is now available.  There are a few major changes, but with luck I'll be able to use it for my Hadoop integration ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and Leeds. See if you can persuade ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
The Background Before SQL Server 2016, businesses has to choose between securing their databases with Transparent Data Encryption (TDE) and database backup ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
SQL Prompt has lots of great features that can help you write SQL quicker. However, you've got to train yourself to use a few of these and not just start ...
13:49 27-Sep-2016
DatabaseWeekly - Newsletter
IntroductionMost of the time, while working with SQL Server, the transaction log files usually grows due to numerous reasons. Out of which one such reason ...
13:49 27-Sep-2016
SQLServerCentral - Blogs
In this module you will learn how to use the Stream Graph chart Power BI Custom Visual.  The Stream Graph is similar to a Stacked Area Chart but ...
13:30 27-Sep-2016
SQLServerCentral - Blogs
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your boss on the idea and get ...
13:07 27-Sep-2016
SQLServerCentral - Blogs
Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit ...
13:00 27-Sep-2016
SQLServerCentral - Blogs
SQL Prompt has lots of great features that can help you write SQL quicker. However, you've got to train yourself to use a few of these and not just start ...
12:10 27-Sep-2016
SQLServerCentral - Blogs
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) linked to my post Comparing Two ...
12:00 27-Sep-2016
DatabaseWeekly - Newsletter
SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post ...
11:49 27-Sep-2016
SQLServerCentral - Questions
Display the names of the properties that are as (potentially) transitive but are not marked as such. In order to determine whether a property is used ...
10:19 27-Sep-2016
SQLServerCentral - Blogs
I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So ...
09:13 27-Sep-2016
SQLServerCentral - Blogs
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to ...
07:31 27-Sep-2016