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
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
HI Can anybody please provide me link or reference where can I get a good amount of examples of SSIS (like For each,Data flow ,Something that combines ...
02:53 28-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. FREE eBook - "45 Database Performance ...
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
SQLServerCentral - Questions
Hi Team, I have been working with SQL for quite some time. I am looking out for some dynamic solution if any one can help me out. Below is the scenario. I ...
06:40 25-Jul-2015
SQLServerCentral - Questions
I have a table that is basically records of items, with columns for each day of the month. So basically each row is ITEM A, Day1, Day2, Day3, ....I have ...
06:33 25-Jul-2015
SQLServerCentral - Questions
Backup database AdventureWorks2012 to disk = 'C:\Backups\AdventureWorks2012_full_062720151415.bak' How to run this backup in standby mode?
03:13 25-Jul-2015
SQLServerCentral - Questions
DECLARE db_cursor CURSOR FOR SELECT name FROM MASTER.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') How to drop this cursor ...
01:57 25-Jul-2015
SQLServerCentral - Blogs
Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query …Continue ...
00:24 25-Jul-2015
SQLServerCentral - Questions
I have a database on a hosted server environment. I noticed several of my tables have had their identity values incremented by more than the "identity ...
19:19 24-Jul-2015
SQLServerCentral - Questions
Hi we have an SQL Server running under Hyper V VM and we are planning to make use of log shipping and ...
18:32 24-Jul-2015
SQLServerCentral - Blogs
ERROR : Error Message 1 : Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: ...
15:34 24-Jul-2015
SQLServerCentral - Blogs
Yesterday I participated in PASS Performance Palooza. I had a lot of fun delivering my session Columnstore ...
15:33 24-Jul-2015
SQLServerCentral - Blogs
Today Microsoft officially released the new development tool for Power BI called Power BI Desktop.  First of all let me share my excitement in what this ...
13:58 24-Jul-2015
SQLServerCentral - Blogs
I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few ...
13:24 24-Jul-2015