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
SQL Server is trying to help you - when you run a query, you see a missing index request. Before you run that CREATE INDEX script in production, consider ...
15:48 15-Aug-2014
SQLServerCentral - Blogs
USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS One of op requested to list all ...
13:47 15-Aug-2014
SQLServerCentral - Questions
Hi Experts! What is wrong with the following DAX Expression... =IF( [UnitPriceDiscountPct] = 0, BLANK () , [UnitPriceDiscountPct] * [SalesAmount] ) It ...
by lasma
13:43 15-Aug-2014
SQLServerCentral - Questions
Hi all We use Redgate SQL backup to backup all databases in our company. We are also backing up databases enabled for replication. I noticed that after ...
by ruancra
12:28 15-Aug-2014
SQLServerCentral - Blogs
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real ...
11:00 15-Aug-2014
DatabaseWeekly - Newsletter
There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. ...
09:48 15-Aug-2014
SQLServerCentral - Questions
Hi experts, I am getting the following error message while trying to do a data insert into physical tables. The Index where its failing is _CREATE CLUSTERED ...
by sweta.dutta7
08:15 15-Aug-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 ...
23:10 14-Aug-2014
SQLServerCentral - Editorials
Steve Jones wonders about the next generations of IT workers. Can we encourage more people to enter this field? With the supposed shortages of talent ...
23:00 14-Aug-2014
SQLServerCentral - Main Articles
In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT. ...
23:00 14-Aug-2014
SQLServerCentral - Main Articles
SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this ...
23:00 14-Aug-2014
SQLServerCentral - Main Articles
It is often generalized that seeks are better than scans in terms of retrieving data from SQL Server. The index hint FORCESCAN was recently introduced ...
23:00 14-Aug-2014
SQLServerCentral - Main Articles
On September 13, 2014 the French SQL Server Community (GUSS) will be holding a SQL Saturday conference. The event is free to attend, with 4 paid-for pre-conference ...
23:00 14-Aug-2014
SQLServerCentral - Questions
We have been trying to install SQL Server 2012 for about a week now. It continues to error out with the following message. It looks like it cannot fine ...
by TomT
17:53 14-Aug-2014
SQLServerCentral - Blogs
Thanks to everyone who attended my session "Modern Data Warehousing" at the Central New Jersey SQL User Group yesterday.  The abstract for my session ...
17:47 14-Aug-2014
SQLServerCentral - Blogs
There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. ...
17:29 14-Aug-2014
DatabaseWeekly - Newsletter
A quick post here on some valuable data sources you can use in your HDInsight, Microsoft Excel, SQL Server, APS, and other products to enrich your data. ...
16:48 14-Aug-2014
DatabaseWeekly - Newsletter
There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along with how they are connecting and what sort of activities ...
16:48 14-Aug-2014
DatabaseWeekly - Newsletter
If you've ever done spatial work with SQL Server, you've probably come across the 'nearest' problem. You have five thousand stores around the world, and ...
16:48 14-Aug-2014
SQLServerCentral - Blogs
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at SQL Connections on Friday, September 19th, ...
16:17 14-Aug-2014
DatabaseWeekly - Newsletter
The only thing you ever need to use for database identity is an IDENTITY, right? Well, maybe. There are a lot of different options and they all have different ...
15:48 14-Aug-2014
SQLServerCentral - Blogs
I had the opportunity to write another guest post at SQL Authority: Finding Out What Changed in a Deleted Database This one covers how to determine who ...
14:30 14-Aug-2014
Simple-Talk - Blogs
There are many occasions when, as a DBA, you want to see who is connected to your SQL Server, along with how they are connecting and what sort of activities ...
14:16 14-Aug-2014
Simple-Talk - Blogs
This picture below – the one with the rabbits, yes – is clearly something to do with databases. But what? Tell us in the comments – ...
13:35 14-Aug-2014
SQLServerCentral - Blogs
Tuesday we sent our metronomic email of the week. No huge call to action this week. My schedule called for a BI focus and I struggled to write it, so ...
13:15 14-Aug-2014
Simple-Talk - Blogs
Most things tend to come with warnings and careful instructions these days, but sadly not one of the most ubiquitous appliances of all, your computer. ...
12:32 14-Aug-2014
DatabaseWeekly - Newsletter
Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. Even the books on T-SQL skate ...
11:48 14-Aug-2014
DatabaseWeekly - Newsletter
A group of innovative hackers used free services from Google and an Internet infrastructure company to disguise data stolen from corporate and government ...
11:48 14-Aug-2014
SQLServerCentral - Blogs
When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent ...
11:13 14-Aug-2014
SQLServerCentral - Blogs
If you have worked with SQL Server for very long you have probably run across the extremely useful system function called sp_help. This handy little ...
11:00 14-Aug-2014
SQLServerCentral - Questions
Hi, I need to send out an email to end users informing them that their reports are delayed. I want the email of each unique user to list the specific ...
by Swordfish0102
10:20 14-Aug-2014
DatabaseWeekly - Newsletter
Conference season is rapidly approaching. Do you approach a room full of strangers with excitement at all the new people you're going to chat to? Or do ...
09:48 14-Aug-2014
SQLServerCentral - Blogs
With IN clause, we can specify multiple values in a WHERE clause.For example, in case of "IN", one can use the subquery to get the multiple values in ...
09:33 14-Aug-2014
SQLServerCentral - Blogs
About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast about SQL Server. He was pretty surprised, but we started ...
07:59 14-Aug-2014
SQLServerCentral - Questions
Tryied to move tempdb from: 'F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data'. TO: 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data'. When ...
by aderossi
07:53 14-Aug-2014
SQLServerCentral - Questions
i have the following csv file layout. "8-13 13:52:13",,"Tyre Inspection","tyres@books.com","Tyres","tmfo","4af2eb33d962ac0f-1407838105495","08/12/2014." I ...
by tamara
07:45 14-Aug-2014
SQLServerCentral - Questions
Linear algorithm:- Step 1:- Select Object service name from [OBJECT_SERVICE] table and Stored into OOS Step 2:- Select month and count ...
by maheshulunda
07:03 14-Aug-2014
SQLServerCentral - Blogs
UPPER():- This function is used to convert the value of a column to upper case. Syntax:   SELECT UPPER(string)OR Select UPPER(Column name) ...
05:03 14-Aug-2014
SQLServerCentral - Blogs
Avg():- This function is used to get the average value of a numeric columnSyntax:-      SELECT AVG(column_name) FROM table_nameIn ...
05:03 14-Aug-2014