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
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014.  If you weren’t you ...
17:49 17-Apr-2014
DatabaseWeekly - Newsletter
In this episode of the Notes from the Field series database expert John Sterrett (Group Principal at ...
16:44 17-Apr-2014
SQLServerCentral - Questions
Hello! I have a query that does exactly what I need it to but I know there has to a better way to write this because it runs for 17 minutes. The problem ...
by muk
16:19 17-Apr-2014
DatabaseWeekly - Newsletter
Microservices is just a Service Oriented Delivery approach for a well architected SOA solution. SOA provides the contextual framework, provides most ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Hot off the presses is this new MSDN white paper: Optimizing Your Query Plans with the SQL Server 2014 ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Our sister site Simple-Talk have gathered together all of their articles on database delivery in a single place, along with some other resources. The ...
14:44 17-Apr-2014
DatabaseWeekly - Newsletter
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, ...
14:44 17-Apr-2014
SQLServerCentral - Questions
I have old flat file from 2009 that are on my drive for long years. i want to create SSIS package to delete all of them except the last three months. ...
by fantumahi2
13:01 17-Apr-2014
DatabaseWeekly - Newsletter
From the moment a query request is made until the query response is delivered, what really happens to your query in SQL Server? Let's find out, and talk ...
09:44 17-Apr-2014
DatabaseWeekly - Newsletter
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for a brand new product, with $50 Amazon vouchers for ...
09:44 17-Apr-2014
DatabaseWeekly - Newsletter
Backing up SQL Server to the cloud makes a lot of sense, particularly for small businesses. Managing the physical media takes up too much time and effort ...
09:44 17-Apr-2014
SQLServerCentral - Blogs
By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn's blog ...
07:00 17-Apr-2014
SQLServerCentral - Questions
Hi, How to resolve the below issue? I have done RebuildIndex but the problem not solved.I think page ...
by rajasekharbollareddy
06:03 17-Apr-2014
SQLServerCentral - Editorials
Twitter is working on a new database that can handle unstructured as well as structured data well. Is this a competitor for SQL Server?
23:00 16-Apr-2014
SQLServerCentral - Main Articles
An introduction to the XML Schema Collection and XML validation.
23:00 16-Apr-2014
SQLServerCentral - Main Articles
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, ...
23:00 16-Apr-2014
SQLServerCentral - Main Articles
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers ...
23:00 16-Apr-2014
SQLServerCentral - Blogs
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to ...
21:20 16-Apr-2014
SQLServerCentral - Questions
I have two tables, and I want to update values in the first one based on a inner join with values from the second table (seems pretty simple right?). ...
by nickmorse
20:39 16-Apr-2014
Simple-Talk - Blogs
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers ...
16:39 16-Apr-2014
SQLServerCentral - Blogs
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, ...
16:33 16-Apr-2014
SQLServerCentral - Blogs
Kevin Kline is speaking at MagicPASS tonight - on two topics! If you're in the Orlando area I hope you'll try to attend - Kevin is a top notch speaker, ...
15:43 16-Apr-2014
SQLServerCentral - Questions
I have tried (in a textbox expression) IIF(InStr(Fields!MyField.Value,"Partial Value"),True, False) to try and find part of the string in MyField. The ...
by Scott 1 1
14:28 16-Apr-2014
SQLServerCentral - Questions
To be more precise I want to list all, including sleeping, sessions connected to a specified SQL 2008R2 ...
by StuKay
14:03 16-Apr-2014
SQLServerCentral - Blogs
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it here. It’s a mechanism ...
13:12 16-Apr-2014
SQLServerCentral - Blogs
As of right now, my United account has no flights booked. My Hilton Honors account has no hotel rooms reserved. My National account has no car rentals ...
12:39 16-Apr-2014
DatabaseWeekly - Newsletter
If there was any question that Microsoft wants to be everyone's data analytics shop, the company erased those doubts with its recent presentation.
11:44 16-Apr-2014
DatabaseWeekly - Newsletter
Where does SQL get the default values from when we create a database without any options?
11:44 16-Apr-2014
DatabaseWeekly - Newsletter
Be careful when implicitly converting data types in T-SQL. Directly assigning 1.5 (either as a FLOAT or a NUMERIC) to an INT value in SQL Server may truncate ...
11:44 16-Apr-2014
SQLServerCentral - Questions
I want to transfer data from 40 diffrent tables to text files of respective Tables and then put that file in FTP Sometime it works sometime FTP component ...
by Bhupendra99
11:20 16-Apr-2014
SQLServerCentral - Blogs
Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and ...
11:00 16-Apr-2014
DatabaseWeekly - Newsletter
Sooner or later, as you begin to hone your PowerShell skills, you'll start writing scripts to automate repetitive tasks.
10:44 16-Apr-2014
DatabaseWeekly - Newsletter
Disaster recovery services are nothing new, but VMware vCloud Hybrid Service Disaster Recovery is. The virtualization company just rolled out a new cloud-based ...
10:44 16-Apr-2014
DatabaseWeekly - Newsletter
After a thorough investigation, Microsoft determined that Microsoft Account, Microsoft Azure, Office 365, Yammer and Skype, along with most Microsoft ...
10:44 16-Apr-2014
SQLServerCentral - Questions
I have been asked to look at the performance of a SharePoint (SP) SQL Server that periodically goes slow. Some configurations have been changed (MAXDOP ...
by Fatherjack
10:19 16-Apr-2014
SQLServerCentral - Questions
Hello Everyone, Can We upgrade SQL Server 2008R2 RTM version to SQL server 2012 RTM. Thanks Basit K
by basit 1
09:39 16-Apr-2014
SQLServerCentral - Questions
If I configure Always ON availability group, whether Primary and Secondary servers use the same SAN ...
by Venkataraman
09:02 16-Apr-2014
SQLServerCentral - Questions
In one of the procedures, I have a temp table, designed to be exactly the same as the destination table, wherein the data will be finally dumped. A column ...
by nidheesh.r.pillai
08:23 16-Apr-2014
SQLServerCentral - Blogs
We can create a database simply by typing in the command create database DB1 .csharpcode, .csharpcode pre{ font-size: small; color: black; font-family: ...
07:00 16-Apr-2014