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
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 - 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
SQLServerCentral - Questions
Hi All, Thanks in advance.I have a sharepoint page with ssrs reports.When i load the page for the first time i am getting the time out error.Is there ...
by prashanthkumar043
04:36 15-Apr-2014
Simple-Talk - SQL Articles
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, ...
by Phil Factor
00:00 15-Apr-2014
SQLServerCentral - Editorials
It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts. ...
23:00 14-Apr-2014
SQLServerCentral - Main Articles
In this article, I'll attempt to "convince" you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).
23:00 14-Apr-2014
SQLServerCentral - Main Articles
Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. ...
23:00 14-Apr-2014
SQLServerCentral - Main Articles
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database ...
23:00 14-Apr-2014
SQLServerCentral - Questions
Hi, On Windows 2008R2 and SQL 2012, config SSIS, job and work fine. Re-apply the job script and try to re-config the job again; error - 'An entry with ...
by Chris 2
20:43 14-Apr-2014
SQLServerCentral - Questions
I am getting error that there is no connection manager specified in my Execute SQL task, so I am missing a step. I have data saved to a recordset destination ...
by Renee
20:22 14-Apr-2014
SQLServerCentral - Questions
Hi Experts, Please suggest me on how to prepare for sql server dba interview with microsoft. What are the questions/ style of question, they generally ...
by NeerajTripathi
18:54 14-Apr-2014
DatabaseWeekly - Newsletter
When a business solution or tool is in the pilot stage, hardware, software, and know-how are the challenges. Once the technical hurdles are cleared, enterprise ...
17:44 14-Apr-2014
DatabaseWeekly - Newsletter
Microsoft has announced that Windows 8.1 users must upgrade to Windows 8.1 Update if they want security patches.
17:44 14-Apr-2014