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 am trying to add the following message to my db and some is showing red some showing green i need the whole message with quotes to be entered. update ...
15:04 28-Jul-2015
SQLServerCentral - Blogs
I have been in Corporate IT long enough to know that when a bad decision is made, you move out of the way of that train while quietly doing what you can ...
12:27 28-Jul-2015
SQLServerCentral - Blogs
Education. The key topics for everyone. In his incredibly famous TED Talk “Do Schools Kill Creativity“, which might be some of the most important ...
12:00 28-Jul-2015
SQLServerCentral - Blogs
SQL Saturday #386 (Albany, NY) – My first SQL Saturday Session So that picture to the right is me out front of the SUNY Albany campus around 6:45 ...
11:00 28-Jul-2015
SQLServerCentral - Blogs
SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server ...
10:00 28-Jul-2015
SQLServerCentral - Questions
In the following SSRS expression, I need to remove the comma for the last one...but i don't know which one comes first. Ex: A,B,C,D, I am getting the ...
09:34 28-Jul-2015
SQLServerCentral - Questions
Hi all, how to convert date to words?? like '21/01/2015' to 'twenty first January two thousand and fifty' thanks in advance
07:02 28-Jul-2015
SQLServerCentral - Questions
I have view that created on multiple tables and it contains the 800 columns and it returns the 40 million records. So now i want to load the view data ...
06:28 28-Jul-2015
SQLServerCentral - Questions
Hi , I have 2 node Active Passive SQL Cluster with SSRS installed on one of the node. For this i have one Licence. Now if i install SSRS on second node ...
03:00 28-Jul-2015
SQLServerCentral - Questions
Can anybody please provide me with a link or reference to a good selection of SSIS examples (like For each, Data flow, something that combines two complex ...
02:53 28-Jul-2015
SQLServerCentral - Editorials
An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.
23:00 27-Jul-2015
SQLServerCentral - Main Articles
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
23:00 27-Jul-2015
SQLServerCentral - Main Articles
MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service ...
23:00 27-Jul-2015
SQLServerCentral - Blogs
I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those ...
20:58 27-Jul-2015
SQLServerCentral - Questions
Hello, I am looking for a utility (maybe in PowerShell?) to analyze a .sql file and a server to determine the least permissions, down at least to the ...
19:40 27-Jul-2015
SQLServerCentral - Blogs
This is a bit of an off topic post from the technical stuff, but there's a bit of a tie-in, so stick with me. I had to get a tire fixed this morning. ...
18:19 27-Jul-2015
SQLServerCentral - Blogs
This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking ...
17:21 27-Jul-2015
SQLServerCentral - Questions
We need to scale out sql server database while writing on windows azure. We ideally don't want to scle the master tables and just want to scale only the ...
17:19 27-Jul-2015
SQLServerCentral - Questions
Hi, I am trying to append multiple excel source files into one destination, I used for each loop container and here I tried with variable to read the ...
14:21 27-Jul-2015
SQLServerCentral - Blogs
Reading Time: 1 minutes Let’s Play A Game! So, just to tickle your fancy, here is... The post Sneak Preview – Episode 014 appeared first on ...
12:30 27-Jul-2015
SQLServerCentral - Blogs
As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names and eating habits – I ...
11:20 27-Jul-2015
SQLServerCentral - Blogs
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said research I came across three great ...
11:00 27-Jul-2015
SQLServerCentral - Blogs
A client called us with the following issue: He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed. He had ...
06:32 27-Jul-2015
SQLServerCentral - Questions
I have a transactional replication setup and i want to enable data compression(page or row) only on ...
00:19 27-Jul-2015
Simple-Talk - SQL Articles
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with so many several ways of ...
by Robert Sheldon
00:00 27-Jul-2015
Simple-Talk - .NET Articles
It seems a great idea to have your application on all the main mobile platforms as well as on the desktop. Nothing beats writing an app specially for ...
by Arkadiusz Pachucy
00:00 27-Jul-2015
SQLServerCentral - Blogs
"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief description of a recent use case for a power ...
23:44 26-Jul-2015
SQLServerCentral - Questions
Experts, I have a SQL Server 2005 database file (a .mdf file) that I am trying to open in SQL Server Management Studio so I can add a field to a table, ...
23:37 26-Jul-2015
SQLServerCentral - Editorials
The challenges of getting enough resources for our projects aren't always apparent.
23:00 26-Jul-2015
SQLServerCentral - Main Articles
Set-based programming doesn't mean "no loops" or a single statement. Finding out the best ways to traverse a full hierarchy.
23:00 26-Jul-2015
SQLServerCentral - Main Articles
References and links to get you started in backing up your database to the Azure blob storage. "A real time saver" Andy Doyle, Head ...
23:00 26-Jul-2015
SQLServerCentral - Main Articles
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
23:00 26-Jul-2015
Simple-Talk - Blogs
  Translations are a very usefull feature in multidimensional cubes. We can translate not only the cube structure, but also the data. Of course we ...
19:24 26-Jul-2015
SQLServerCentral - Blogs
Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of …Continue reading →
17:17 26-Jul-2015
SQLServerCentral - Blogs
Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about products, downloads, and pricing, ...
12:00 26-Jul-2015
SQLServerCentral - Blogs
Transparent Data Encryption in Azure SQL DatabaseJULY 26, 2015 IntroductionTransparent Data Encryption (TDE) is a security feature of SQL Server that ...
00:49 26-Jul-2015
SQLServerCentral - Questions
The mdx below is returning the correct data in sms, But the issue is that the first 2 columns the caption are blank I need regcode and regname . Also, ...
00:33 26-Jul-2015
SQLServerCentral - Blogs
  Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database ...
23:27 25-Jul-2015
SQLServerCentral - Questions
Hello, receive an error: "Cannot perform a differential backup for database ..., because a current database backup does not exist." Can't fully understand ...
07:35 25-Jul-2015