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
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to get some schedule information ...
12:32 21-Mar-2015
SQLServerCentral - Blogs
By Steve Bolton ....In the last couple of installments of this amateur series of self-tutorials on outlier identification with SQL Server, we dealt with ...
22:19 20-Mar-2015
SQLServerCentral - Questions
Have a POS system running on SQL 2008 R2. They are starting a e-store based on data from that pos system, that will we need to dump .csv files to the ...
19:49 20-Mar-2015
SQLServerCentral - Questions
**I have a table like this** ![alt text][1] **and I want to convert it to this** ![alt text][2] **Any one who have any idea ?** [1]: /storage/temp/2251-capture.png ...
19:10 20-Mar-2015
DatabaseWeekly - Newsletter
There will be an entirely new edition of Windows 10, "Windows 10 IoT", using a similar postfix notation as the ill-fated "Windows 8 RT". However, within ...
18:43 20-Mar-2015
DatabaseWeekly - Newsletter
For many PowerShell beginners, splitting strings works just fine. Eventually you'll realize that you ...
18:43 20-Mar-2015
DatabaseWeekly - Newsletter
Deep Learning is very computationally intensive, so you will need a fast CPU with many cores, right? Or is it maybe wasteful to buy a fast CPU? One of ...
17:43 20-Mar-2015
DatabaseWeekly - Newsletter
Few database projects start with a clean slate. Many operational applications have legacy databases as a source of data and ideas. Analytical applications ...
17:43 20-Mar-2015
SQLServerCentral - Questions
Hi Guys Do any one have idea about DDM Studio for SQL Server.. id it free downloadable??
17:27 20-Mar-2015
DatabaseWeekly - Newsletter
While Microsoft has dropped hints that the Internet Explorer brand is going away, the software maker has now confirmed that it will use a new name for ...
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
Steve Jones presents a script, useful for demo purposes, which detaches all user databases from a SQL Server instance and then reattches certain ones.
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
Resource semaphore waits for a query due to an expensive sort operator. The cure? An index!
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
Microsoft continues to fill in the check boxes for its Azure cloud. Example: Azure DocumentDB, Microsoft's take on NoSQL databases a la Couch or MongoDB, ...
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
A few years ago, Joel Spolsky wrote his simple, 12-point test to measure how "good" a software team is. Stan was thinking about this test quite a bit, ...
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
A specific query plan for INVENTSUM was showing multiple plans. The funny part is that the newer plan was estimating more rows being returned then the ...
14:43 20-Mar-2015
DatabaseWeekly - Newsletter
A new UI, new features to analyze performance of DAX queries and more.
14:43 20-Mar-2015
SQLServerCentral - Questions
create table dummy ( id int, Resulxml xml ) insert into dummy values(1,' A1 Q1 ...
13:47 20-Mar-2015
DatabaseWeekly - Newsletter
Most senior DBAs shudder when they hear NOLOCK, but Kenneth Fisher argues that it's a useful setting, under very specific circumstances.
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
If I were to ask you a question "Does statistics update cause recompile for a query referencing the table?", what would your answer be? In most cases, ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
Analysts predict that there will be billions of internet connected devices by the year 2020. While analyst reports range from 24 billion to upwards of ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
"[Thing] != NULL" is nonsense. It won't work the way you want it to work, because NULL literally means "unknown". Nothing in the world can be equal to, ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
What happens if a checkpoint starts but doesn't finish before a crash occurs? Will that checkpoint be used for crash recovery? The answer is no, it won't. ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
You went to a large, popular, SQL Saturday event last year, so you submitted this year. and didn't get accepted. Now what?
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
On where and why you may need to rewrite a security predicate in order to improve performance when working ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
Salary is a poor way to measure success. It's a crude, gross way to compare the value of one job to another, based on someone else's view of your job. ...
13:43 20-Mar-2015
DatabaseWeekly - Newsletter
what it means to Scale Horizontally and what sharding is all about. This post describes what it means to Scale Horizontally and what sharding is all about. ...
13:43 20-Mar-2015
SQLServerCentral - Blogs
I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give you some thoughts to take away about how you might ...
12:17 20-Mar-2015
SQLServerCentral - Questions
My input parameters are multi-valued parameters. EXEC proc_Scores 'tier 2', '2013'',''2014', 'North ...
01:18 20-Mar-2015
SQLServerCentral - Questions
My coworker can connect to sql server using sa password. However, I can not do it. I get an error (Provider: Named Pipes Provider: error :40 - could not ...
23:29 19-Mar-2015
SQLServerCentral - Editorials
This week Steve Jones is wondering what the common mistakes that T-SQL developers make are. 10 must-have SQL Server toolsThe award-winning ...
23:00 19-Mar-2015
SQLServerCentral - Main Articles
What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you ...
23:00 19-Mar-2015
SQLServerCentral - Main Articles
In this article, Robin Shahan explains what Blob Leases are and how to use them, including code samples for calling the different methods available for ...
23:00 19-Mar-2015
SQLServerCentral - Blogs
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the leadership trio consisting of Shawn Bice, Nigel ...
22:46 19-Mar-2015
SQLServerCentral - Questions
---I will like to simplify this multiple queries into one script Please Help. Thanks USE master GO SELECT * FROM sysdatabases; GO ...
20:26 19-Mar-2015
SQLServerCentral - Blogs
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very BIG deal. I have a horrible fear of public speaking, ...
20:01 19-Mar-2015
SQLServerCentral - Questions
I have an Access database which was copied to an USB device and has become corrupt. I am getting the following error message:The Microsoft Jet database ...
18:46 19-Mar-2015
SQLServerCentral - Questions
Hi! How can I change the following to a rolling 12 months query? WHERE (PHYT.COUNT_DATE BETWEEN CONVERT(Datetime, '1/1/2014', 102) AND CONVERT(Datetime, ...
15:53 19-Mar-2015
SQLServerCentral - Blogs
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server in Azure Virtual ...
14:00 19-Mar-2015