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.bak file about 35mb, a database backup. I want to open this file so that I can view its contents. Fileviewer software can not do this. Could someone ...
08:55 29-Jul-2015
SQLServerCentral - Questions
I have a table with date fetched from SQL. I would like to plot line graph with month on x axis (bottom) and values division wise (4-5 lines) as per ...
03:59 29-Jul-2015
SQLServerCentral - Questions
I have my data (attached) in cloumns and I like to transpose them into rows. I tried Unipovt but since most of the fileds are dynamics and not fixed, ...
00:14 29-Jul-2015
SQLServerCentral - Editorials
Steve Jones discusses the decision to hire someone that fits in with your culture at work, and what that means.
23:00 28-Jul-2015
SQLServerCentral - Main Articles
Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level ...
23:00 28-Jul-2015
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 28-Jul-2015
SQLServerCentral - Main Articles
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, ...
23:00 28-Jul-2015
SQLServerCentral - Questions
I have a query against a table with 31 million rows in it that is very slow performing. I am including below the structure of the table and the query ...
20:08 28-Jul-2015
SQLServerCentral - Blogs
I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts. Security is important for our database servers. One ...
18:10 28-Jul-2015
SQLServerCentral - Blogs
Get a better name Define my personal goals for the course I won't be sharing these with you. I may share them with my Inner Circle (defined below). ...
17:38 28-Jul-2015
SQLServerCentral - Blogs
Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The premise is that some companies allow a relaxed ...
17:36 28-Jul-2015
SQLServerCentral - Questions
Hi All, I am new to queries. I am looking for a query to pull data from table, below is the requirement. (stat holidays have to be taken into consideration). If ...
15:51 28-Jul-2015
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. ...
15:04 28-Jul-2015
SQLServerCentral - Blogs
Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the previous version, I had it ...
14:00 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 ways of aggregating, ...
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