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 ALL I Have a column in a table with comma seperated strings on each row of one column like that ...
00:13 29-Mar-2017
SQLServerCentral - Questions
We have a customer that owns businesses in multiple markets across geographic regions. They want to run our POS system in a single database using schemas ...
21:10 28-Mar-2017
SQLServerCentral - Blogs
A database recovery process is an essential requirement for database systems, It can be a tedious job ...
18:52 28-Mar-2017
SQLServerCentral - Questions
Hey, I would like to create a function that takes the values of a date column (varchar) in yyyymmdd format from a view and changes the values to a mm/dd/yyyy ...
18:36 28-Mar-2017
SQLServerCentral - Questions
I have a column name TIMESTAMP (varchar) which comes from a .dat file. I want to convert it to DATETIME. I know that varchar cannot be converted to a ...
15:31 28-Mar-2017
SQLServerCentral - Blogs
The first event I ever spoke at was SQLSaturday in Madison, Wisconsin, back in 2012. I was petrified – would anyone want to hear someone talk about ...
14:35 28-Mar-2017
SQLServerCentral - Blogs
The European General Data Protection Regulation (GDPR) is coming, bringing new rules about the protection of Personally Identifiable Information (PII). For ...
13:51 28-Mar-2017
SQLServerCentral - Questions
Memory related query
13:22 28-Mar-2017
SQLServerCentral - Blogs
I made a mistake the other day. For some reason I got it into my head that I was flying to Albuquerque when I was actually flying to Phoenix. I’ve ...
13:07 28-Mar-2017
SQLServerCentral - Blogs
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don't worry you might use sooner than later. ...
10:58 28-Mar-2017
SQLServerCentral - Blogs
TweetG’day, Saturday 8th April 2017 will see the biggest ever SQL Saturday South Island New Zealand. The event started in 2013 as SQL Saturday Christchurch ...
08:54 28-Mar-2017
SQLServerCentral - Questions
I have a serious issue on my database since last few days. The **total size of the database is 286 GB** ...
08:19 28-Mar-2017
SQLServerCentral - Questions
We are currently on SQL Server 2014, V12.0.5203.0. We use SSRS as our core reporting tool. Most of our report datasets are set up as shared datasets ...
08:19 28-Mar-2017
SQLServerCentral - Blogs
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never ...
05:30 28-Mar-2017
SQLServerCentral - Blogs
SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it ...
03:11 28-Mar-2017
SQLServerCentral - Editorials
Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.
23:00 27-Mar-2017
SQLServerCentral - Main Articles
Age calculation based on the right method used in real life.
23:00 27-Mar-2017
SQLServerCentral - Main Articles
Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how ...
23:00 27-Mar-2017
SQLServerCentral - Blogs
Welcome to the 4th Interview of Data Channel. We have Mr.Martin Catherall, 3 time Data Platform MVP from Australia / New Zealand discussing "In Memory ...
20:10 27-Mar-2017
SQLServerCentral - Blogs
If you are a SQL Server professional and are interested in spending a day with ...
19:00 27-Mar-2017
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I thought this would make ...
18:34 27-Mar-2017
DatabaseWeekly - Newsletter
More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it's not always clear what's the best ...
15:43 27-Mar-2017
Simple-Talk - SQL Articles
Entity Framework (EF) is Microsoft's Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In this article ...
13:58 27-Mar-2017
Simple-Talk - .NET Articles
Entity Framework (EF) is Microsoft's Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In this article ...
13:58 27-Mar-2017
Simple-Talk - SQL Articles
When you are automating a number of tasks, or performing a batch of tests, you want a way of automating ...
13:55 27-Mar-2017
SQLServerCentral - Blogs
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, I’m sure all of you have been holding ...
13:00 27-Mar-2017
SQLServerCentral - Blogs
People love taking shortcuts because it's the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, ...
12:25 27-Mar-2017
Simple-Talk - Blogs
If you roll out DevOps across an organization before it is culturally prepared for it, you will see warning signs that the initiative is failing. These ...
11:30 27-Mar-2017
SQLServerCentral - Blogs
I’ll be attending and speaking at Orlando Code CampĀ  on April 8th. Come by and say hello if you’re attending, maybe we can talk career paths, ...
10:00 27-Mar-2017
SQLServerCentral - Blogs
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a lot was covered. I don’t ...
10:00 27-Mar-2017
Simple-Talk - .NET Articles
Model binders work under the covers in ASP.Net MVC to provide the data for the action methods on a controller class. This data is held by the incoming ...
09:48 27-Mar-2017
SQLServerCentral - Questions
CREATE TABLE #tempIDs(ID INT) GO CREATE TABLE tblMobileNumbers ( ID INT IDENTITY(1,1),Mobile VARCHAR(100),Messagebody VARCHAR(MAX) ...
09:27 27-Mar-2017
Simple-Talk - SQL Articles
The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone ...
09:11 27-Mar-2017
Simple-Talk - Cloud Articles
The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone ...
09:11 27-Mar-2017
SQLServerCentral - Blogs
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot of good information. I wish there as more context about some ...
09:00 27-Mar-2017
SQLServerCentral - Blogs
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts. With SQL Server vNext CTP 1.4 now available and ...
08:36 27-Mar-2017
SQLServerCentral - Blogs
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which is just over a week away. ...
07:04 27-Mar-2017
SQLServerCentral - Blogs
Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy! I’ve said before that SQL Saturday Iceland ...
06:57 27-Mar-2017
SQLServerCentral - Blogs
To understand RLS (ROW LEVEL SECURITY) let's understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website and ...
00:43 27-Mar-2017