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
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
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
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
Q 1 What Is CLR? CLR is a runtime environment. Code that we develop with language compiler that targets the runtime is called managed code. Programmers ...
02:55 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 - Editorials
Database Security is serious business.
23:00 15-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