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


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
SQLServerCentral - Blogs
My company, Heraflux Technologies is proud to partner with Yucca Group to sponsor this year’s SQL Saturday Chicago, a free one-day event for SQL ...
00:32 16-Apr-2014
SQLServerCentral - Main Articles
Security is a confusing topic to many, especially when it comes to understanding what rights are needed ...
23:00 15-Apr-2014
SQLServerCentral - Main Articles
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation ...
23:00 15-Apr-2014
SQLServerCentral - Main Articles
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and ...
23:00 15-Apr-2014
SQLServerCentral - Blogs
Cartesian product can be illustrated by a Cartesian square Most SQL developers are familiar with the ...
20:45 15-Apr-2014
SQLServerCentral - Blogs
In Chapter 1 of our book, MDX with SSAS 2012, we've devoted a section "Setting a default member of a hierarchy in the MDX script" to show three places ...
20:11 15-Apr-2014
SQLServerCentral - Blogs
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one ...
19:01 15-Apr-2014
SQLServerCentral - Questions
While upgrading sql server 2005 to 2012 which type of upgrade issues we will get?
by suesh
18:47 15-Apr-2014
SQLServerCentral - Questions
We are setting up Database mail on a SQL Server 2008r2 cluster. I think we have set up the database mail Accounts and Profiles properly however none ...
by TomT
18:34 15-Apr-2014
SQLServerCentral - Blogs
For members of the SQL community in Orlando and Chicago you've probably heard that Brook Ranne died on March 29, 2014. Brook was part of our group here ...
17:52 15-Apr-2014
DatabaseWeekly - Newsletter
SQL Server 2014 contains some interesting new features. Although SQL Server Standard Edition is limited to 128GB of memory, teams deploying on Standard ...
17:44 15-Apr-2014
SQLServerCentral - Questions
I have installed only client tool(SSMS etc) the server A and didn't intall any services(engins) in it. I try to connect to server B from server A by SSMS(given ...
by narendba
17:35 15-Apr-2014
SQLServerCentral - Blogs
As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of ...
16:20 15-Apr-2014
DatabaseWeekly - Newsletter
Sweden's Bahnhof are known for creating offbeat data center designs. There a modular solution that looks like a space station. There was an idea to retrofit ...
14:44 15-Apr-2014
SQLServerCentral - Questions
I have two tables containing employee timesheet records. All employees have summary records in the Time table. Some also have detailed records in a ...
by smeachum
14:22 15-Apr-2014
SQLServerCentral - Blogs
Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason is due to frequent upgrades to the hardware ...
14:00 15-Apr-2014
SQLServerCentral - Blogs
I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to finish up some work. The comments so far are interesting ...
13:27 15-Apr-2014
SQLServerCentral - Blogs
Today I wrote another question based on an error message. I included the error message in the question this time and it's reasonably helpful, but the ...
13:17 15-Apr-2014
SQLServerCentral - Questions
I have a requirement to rename a column in UI downtime. If I use sp_rename, for normal columns having non clustered indices are getting adjusted with ...
by rudrapbiswas
12:48 15-Apr-2014
SQLServerCentral - Blogs
If you take basic first aid, say a CPR course, you’ll learn a handy mnemonic for the primary assessment you have to make, A-B-C. That breaks down ...
12:42 15-Apr-2014
SQLServerCentral - Questions
CREATE TABLE #ABC (A INT, B VARCHAR(MAX) ) CREATE TABLE #DEF (B VARCHAR(MAX), C INT, D INT ) we want to create ...
by prasad.nyalapatla
11:57 15-Apr-2014
SQLServerCentral - Blogs
Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first video, I would highly encourage you to do so. In ...
11:55 15-Apr-2014
SQLServerCentral - Blogs
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an overview from ...
11:44 15-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, ...
11:44 15-Apr-2014
DatabaseWeekly - Newsletter
Eighteen percent of online adults in the U.S. have had important personal data stolen. That key takeaway from a new Pew Research Center study highlights ...
10:44 15-Apr-2014
SQLServerCentral - Questions
hi, as of now we are preparing a html body and sending emails from front end as they are triggered by user action. but now we need to send email every ...
by pramod.kietit
10:17 15-Apr-2014
SQLServerCentral - Blogs
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you ...
09:11 15-Apr-2014
SQLServerCentral - Blogs
Question : How to disable sa user in SQL Server 2000? Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances ...
08:33 15-Apr-2014
SQLServerCentral - Questions
I want to partition a huge SQL Table. This table contains Daily and Month end data. Example : **Month End Data** 1. 2014-01-31 2. 2014-02-28 3. 2014-03-31 ...
by Kirman1
08:31 15-Apr-2014
SQLServerCentral - Blogs
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 ...
08:30 15-Apr-2014
SQLServerCentral - Blogs
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even if it’s obvious that ...
07:00 15-Apr-2014