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
We have SQL Server on another machine installed by a person who has left the company. I believe it is 2008 R2 as that is what we use. SQL is required ...
19:31 28-Sep-2016
SQLServerCentral - Questions
Hello, I need to add extra blank space to a string. This case I use ^ character sine don't now how to add blank space character. I want this..... This ...
19:11 28-Sep-2016
SQLServerCentral - Questions
I'm running SQL Server Configuration Manager 2015.0130.14500.010 on 64-bit Windows 7, and when I open it, it shows only the 32-bit node. Any idea what ...
18:46 28-Sep-2016
SQLServerCentral - Blogs
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re ...
17:12 28-Sep-2016
SQLServerCentral - Questions
Hello, How do I find the IP Adress and hostname of the virtual SQL Server Cluster? I know that this ...
16:29 28-Sep-2016
SQLServerCentral - Questions
Hi I installed sql server version 2014 but my database compatibility level is 100,is it Poor Performance? ...
15:33 28-Sep-2016
SQLServerCentral - Questions
Hi, We have developed an In-house Productivity Monitoring tool on our organization. Objective is, a client tool will be installed on all the users' desktop/Laptop, ...
14:38 28-Sep-2016
SQLServerCentral - Questions
Current row; Name Bldg CID John Doe 120 450 Next row; Name Bldg CID John Doe 120 500 Want to remove duplicate rows but ...
13:51 28-Sep-2016
SQLServerCentral - Blogs
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the ...
12:39 28-Sep-2016
DatabaseWeekly - Newsletter
Samsung's outlined its vision of the current state of the SSD market and future trends at its annual ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
In preparation for a recent load testing engagement, we started talking about the company's goals. The DBA said something really insightful: "We want ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
At Microsoft Ignite, it's announced that very soon, we will be able to host Power BI Desktop files on premises using Reporting Services. Watch the following ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect to  using R and RStudio (and a whole ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Building reliable, robust software is hard. It is even harder when we move from deterministic domains, such as balancing a checkbook, to uncertain domains, ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
The European Union's law enforcement agency, Europol, issued a warning today regarding the cybercrime threat landscape, particularly threats emanating ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week's episode, we're going ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Tim O'Reilly explains why we can't just use technology to replace people; we must use it to augment them so they can do things that were previously impossible.Continue ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Click to learn more about video blogger Stefan Groschupf. Introducing the Big Data & Brews video blog series presented by Stefan Groschupf, CEO of Datameer. ...
10:49 28-Sep-2016
DatabaseWeekly - Newsletter
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the ...
10:49 28-Sep-2016
SQLServerCentral - Blogs
Social Media and Analytics is always an interesting combination. Twitter has an API that you can so you can connect to  using R and RStudio (and ...
10:30 28-Sep-2016
SQLServerCentral - Blogs
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you! Following on from my last post Changing connection colours ...
10:18 28-Sep-2016
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 premises 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
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
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