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 - Blogs
Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in …Continue reading →
01:40 03-May-2016
SQLServerCentral - Questions
Is there a way in a stored procedure to display a message if record count from a table is >= 3000000 and stop the stored procedure from running? Or display ...
23:17 02-May-2016
SQLServerCentral - Editorials
Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others. ...
23:00 02-May-2016
SQLServerCentral - Main Articles
Ability to enable Instant File Initialization during the installation of SQL Server 2016.
23:00 02-May-2016
SQLServerCentral - Main Articles
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database ...
23:00 02-May-2016
SQLServerCentral - Blogs
By Steve Bolton ....As mentioned in previous installments of this series of amateur self-tutorials, ...
22:22 02-May-2016
SQLServerCentral - Questions
,I have an insert trigger that selects multiple rows from inserted. I am trying to use a cursor to process the data - is this the correct approach?
20:39 02-May-2016
Simple-Talk - Blogs
Blocked processes are often a big problem to DBA’s. They are difficult to monitor. We receive desperate calls saying “Everything is slow!” ...
19:10 02-May-2016
SQLServerCentral - Questions
I have an ssis package with filename format as xxxxx_201605020937 (date and timestamp). There will be 2 files on Friday with same format but different ...
18:38 02-May-2016
SQLServerCentral - Blogs
Gotta love Mondays.  At least the weather here in Minnesota is clearing up, the last two weeks have been cold and overcast.  To get things started for ...
17:00 02-May-2016
SQLServerCentral - Questions
I have a SQL Server 2008 R2 table with a Full-Text index, covering four columns. If I run a CONTAINS query against that table, searching all columns i.e.: where ...
15:12 02-May-2016
SQLServerCentral - Blogs
There are a multiple ways to suppress and remove the first line from text file. The first scenario would ...
13:18 02-May-2016
SQLServerCentral - Questions
table1 Product | company | Demand bike | honda bike | suzuki bike | hero bike | ktm table2 ...
13:10 02-May-2016
SQLServerCentral - Blogs
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL Saturdays over the last couple ...
13:07 02-May-2016
SQLServerCentral - Blogs
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve decided that you don’t actually ...
13:00 02-May-2016
SQLServerCentral - Blogs
Microsoft dropped it on us this morning:Get ready, SQL Server 2016 coming on June 1sthttps://media.makeameme.org/created/yes-finally.jpgI read the article ...
09:56 02-May-2016
SQLServerCentral - Main Articles
Your SQL Agent Jobs may be silently failing when using Linked Servers.
23:00 01-May-2016
SQLServerCentral - Main Articles
Join Andy Leonard the week of May 9-13 for 5 free days of Biml training. How to track every change to your SQL Server databaseSee ...
23:00 01-May-2016
SQLServerCentral - Main Articles
Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert ...
23:00 01-May-2016
SQLServerCentral - Blogs
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading ...
22:56 01-May-2016
SQLServerCentral - Questions
i had 5 connections to the database(sqlserver2012)among first 2 connections executed the connections ...
18:54 01-May-2016
SQLServerCentral - Blogs
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s extended support life on April 12th of ...
13:08 01-May-2016
SQLServerCentral - Blogs
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First, it starts ...
22:52 30-Apr-2016
SQLServerCentral - Questions
I want to implement a system in sql server that will automatically delete each record after 10 minutes. ...
10:30 30-Apr-2016
SQLServerCentral - Questions
to create xml file i use the follow script bcp "SELECT xml_data from Xmltable" queryout C:\Test\1.xml -S '+@@servername+' -T -t -w; checking the created ...
08:41 30-Apr-2016
DatabaseWeekly - Newsletter
The website belonging to Maisto International, a popular maker of remote-controlled toy vehicles, has ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
I've just been reading Kingpin by Kevin Poulsen which sheds some really interesting light on criminal credit card fraud in the mid 2000's. Towards the ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
It's not an overstatement to say that, at least for me personally, Edward Tufte's book The Visual Display of Quantitative Information was transformative. ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
With the most recent announcement of Power BI's inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
The StackOverflow XML Data Dump was recently updated with 2016-03 data, so I've updated our torrent of the SQL Server database version of the Stack Overflow ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
SQL Server event alerts that respond by notifying operators can lead to too much noise in your email inbox. There is a built-in option to specify a number ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
If you were given the chance to build the ultimate server, what would you draft first?
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
Since I have started my consulting engagements with customers around the world, I have been asked interesting queries from time to time. In a recent customer ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to learn more. So the other day we ...
17:44 29-Apr-2016
DatabaseWeekly - Newsletter
Seagate has started volume shipments of its first helium-filled hard drives. They were announced earlier ...
17:44 29-Apr-2016
SQLServerCentral - Questions
I have a very simple Concat query, it works on Standard Edition , but when I am migrating to Web Edition, this query does not work. (it does not concatenate) ...
14:39 29-Apr-2016
SQLServerCentral - Questions
i have more data with many columns in excel,how to store all data into sql server database. thanks in advance
14:20 29-Apr-2016
SQLServerCentral - Blogs
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have built big data solutions.  When ...
14:00 29-Apr-2016
SQLServerCentral - Questions
Can you suggest best options/tools to do the SQL Server data encryption after sending data(encrypt format) from database to application(decrypt data),it ...
07:37 29-Apr-2016