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
Ive installed sql server 2014 developer edition on my pc (windows 8) I included the complete management tools but I cant find the enterprise manager. ...
12:43 30-Jul-2015
SQLServerCentral - Questions
I am not able to dynamically configure the method name using Expressions in the Property of a WebService ...
10:00 30-Jul-2015
SQLServerCentral - Blogs
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems ...
08:38 30-Jul-2015
SQLServerCentral - Questions
I am faced with an issue where I need to make a backup of a database to a URL. Can you help me? I'm on Sql Server 2012. Thanks in advance.
06:55 30-Jul-2015
SQLServerCentral - Blogs
HI ALL In One Of the Group the question was asked that How to list all the Servers in which SQL is installed? It is genuine query. There are many scenario ...
06:18 30-Jul-2015
SQLServerCentral - Blogs
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little ...
00:19 30-Jul-2015
Simple-Talk - .NET Articles
In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2105 and DNX Microsoft have ...
by Clive Tong
00:00 30-Jul-2015
SQLServerCentral - Editorials
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
Detecting file differences on two different web servers using T-SQL.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
23:00 29-Jul-2015
SQLServerCentral - Main Articles
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
23:00 29-Jul-2015
SQLServerCentral - Blogs
I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was ...
22:38 29-Jul-2015
SQLServerCentral - Questions
Hi SQL Gurus, I can't seem to find the answer to this simple problem. I am trying to convert a datetime to a numeric(5,2). I only want the minutes converted. Here ...
18:16 29-Jul-2015
SQLServerCentral - Questions
I need to be able to add a hyphen '-' to the end of a date column based on certain criteria. If field3 has more then one 'VISIT' value. Based on account ...
16:31 29-Jul-2015
SQLServerCentral - Blogs
Alternate Title: I’m traveling a bunch. Let’s get together and talk. A bunch of trips and presentations coming up, so I thought I’d ...
15:48 29-Jul-2015
SQLServerCentral - Questions
Hi all , I opened transaction in master package level like ' begin transaction ' in execute sql task for this i used project level connection and set ...
13:57 29-Jul-2015
SQLServerCentral - Blogs
This year's PASS Summit will end on Oct 31, which is Halloween in the US. I'm sure lots of people will have some fun on Friday, though I also suspect ...
12:20 29-Jul-2015
SQLServerCentral - Blogs
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of ...
12:00 29-Jul-2015
SQLServerCentral - Blogs
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of my other favorites. Shft+Arrow ...
11:00 29-Jul-2015
SQLServerCentral - Blogs
Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over ...
11:00 29-Jul-2015
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