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
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 ...
20:00 31-Aug-2015
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking to test some ...
18:55 31-Aug-2015
SQLServerCentral - Questions
I have the following two queries: Select {[Year],[Month]} on 0, {[Measures].[Sales Amount1],[Measures].[Sales ...
15:56 31-Aug-2015
SQLServerCentral - Blogs
Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my ...
15:24 31-Aug-2015
SQLServerCentral - Questions
Hi good people any one can help me I am stack here. I am working on SQL database I want to display three ...
14:39 31-Aug-2015
SQLServerCentral - Blogs
The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are mostly one thing, or at least one thing ...
13:00 31-Aug-2015
SQLServerCentral - Blogs
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but hold on because I’m ...
11:00 31-Aug-2015
SQLServerCentral - Blogs
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov there and we ended up in a discussion ...
10:34 31-Aug-2015
SQLServerCentral - Blogs
Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For testing I will use a virtual ...
07:10 31-Aug-2015
SQLServerCentral - Questions
I have three tables like the following : Date Part_ID Inventory_count 1st jan 2015 123 1 31st jan 2015 123 2 table ...
05:02 31-Aug-2015
SQLServerCentral - Blogs
Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at work, could attend only ...
01:37 31-Aug-2015
SQLServerCentral - Editorials
Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.
23:00 30-Aug-2015
SQLServerCentral - Main Articles
Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+
23:00 30-Aug-2015
SQLServerCentral - Main Articles
If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering ...
23:00 30-Aug-2015
SQLServerCentral - Main Articles
References and Links to using the Managed Backup feature in SQL Server 2016
23:00 30-Aug-2015
SQLServerCentral - Main Articles
Designing databases to use distributed tables effectively will help you to achieve the storage and query ...
23:00 30-Aug-2015
SQLServerCentral - Blogs
Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model ...
10:33 30-Aug-2015
Simple-Talk - Blogs
Typoglycemia is the ironic name, (derived from Hypoglycemia) given to the phenomenon that many readers can understand the meaning of words in a sentence ...
09:37 30-Aug-2015
SQLServerCentral - Blogs
Hi Folks,Comments play an important part in writing any code. Especially when somebody else reads your code. So the other day I was writing a stored procedure ...
01:37 30-Aug-2015
SQLServerCentral - Questions
i supposed to concatenate areacode and phone number field and have this inner joined with other table but it only gave me the phone data. I used open ...
23:41 29-Aug-2015
SQLServerCentral - Questions
Hello Techie, may any one please help me how to solve this puzzle Please. /* Rules The resultset should appear only when fulfill ...
17:06 29-Aug-2015
SQLServerCentral - Questions
I am doing my term Project and I need to create a Performance Evaluation System.I have Created a UML ...
12:19 29-Aug-2015
SQLServerCentral - Blogs
I am super excited to announce that I have recently been accepted as an author for Pluralsight. My audition was on Monitoring AlwaysOn Availability Groups ...
10:35 29-Aug-2015
SQLServerCentral - Questions
Does anyone know of a program/option/tool to repair a microsoft access database that can be run from command line (I don't want any user interaction, ...
07:54 29-Aug-2015
SQLServerCentral - Blogs
After a couple months of fun with Power BI, I've picked up a few little tricks along the way that have helped me to be able to create some pretty cool ...
02:12 29-Aug-2015
SQLServerCentral - Blogs
Dear friends, In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in practical session where we will try ...
01:58 29-Aug-2015
SQLServerCentral - Blogs
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based on the users executing those ...
22:05 28-Aug-2015
SQLServerCentral - Blogs
SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee Chair's recap of the event.Here's ...
21:17 28-Aug-2015
SQLServerCentral - Questions
The problem sounds much less complex than it is. I am using a legacy stored procedure previously used ...
18:47 28-Aug-2015
SQLServerCentral - Questions
Greetings, We have a table that contains, for this example, links to demographic questions (questionID) ...
17:22 28-Aug-2015
DatabaseWeekly - Newsletter
Data visualization has become an integral part of data science work flow. Hence, your main tool needs to have strong capabilities on both the fronts - ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
Paul Randal reports on the cause of a connection error when trying to use the Dedicated Admin Connection ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
They don't teach you this in college, but the fundamental theorem of the software industry is the idea that everything needs to be rewritten all the time. ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
Have you ever experienced that moment in an exam, frantically scribbling your answer to the final question, when the invigilator looks sternly across ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
There is a real danger that developers who see these SQL-like languages as an implementation of SQL are in for a world of pain as they try to leverage ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype, I found that those needed to be combined ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
Defra has a lot of data. Its roles within farming, the rural economy, and management of the natural environment mean it collects all sorts of data about ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
Our taxes fund government to do a number of jobs, during which government collects data, so haven't we already paid for it? And beyond the risk to individuals' ...
15:48 28-Aug-2015
DatabaseWeekly - Newsletter
SQL Server 2016 brings support for JSON. For those of you who don't know, JSON is JavaScript Object Notation - it's a way of representing application ...
15:48 28-Aug-2015