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
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
DatabaseWeekly - Newsletter
When you go to generate execution plans, you have a choice, Estimated or Actual. Well, who would want an estimated measure when you can get an actual ...
15:48 28-Aug-2015
SQLServerCentral - Blogs
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. ...
14:14 28-Aug-2015
SQLServerCentral - Questions
Can someone show me how to run some "server level" diagnostics on SQL SERVER make sure the box is generally in good health? Our SQL server seems to be ...
13:47 28-Aug-2015
SQLServerCentral - Blogs
In just two short months - exactly sixty days from today - the SQL PASS Summit will begin. Although it's still a couple of months away, this is a great ...
13:32 28-Aug-2015
SQLServerCentral - Questions
i am trying to feed a number to database in this case my reference number which is of a (AAA/BBB/28AUG2015 - 4082) format, which should be selected by ...
13:30 28-Aug-2015
SQLServerCentral - Blogs
Reading Time: 2 minutes Thinking Like A Manager In WOxPod!, episode # 017 - “Thinking Like... The post 017 – Thinking Like A Manager appeared ...
12:30 28-Aug-2015
Simple-Talk - Blogs
Have you ever experienced that moment in an exam, frantically scribbling your answer to the final question, when the invigilator looks sternly across ...
11:23 28-Aug-2015
DatabaseWeekly - Newsletter
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 ...
09:48 28-Aug-2015
Simple-Talk - Blogs
The editors of Simple-Talk are not above a snifter of sherry (some even say it fires up the mind), but they’ve never studied it with the grim determination ...
09:28 28-Aug-2015
SQLServerCentral - Blogs
Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised ...
06:42 28-Aug-2015
SQLServerCentral - Questions
DECLARE @MyDate1 DATETIME='2014/04/28 15:15:15'; return DATE(@MyDate1.day,@MyDate1.Month, @MyDate1.year, ...
05:06 28-Aug-2015
SQLServerCentral - Blogs
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 ...
04:47 28-Aug-2015
SQLServerCentral - Questions
Warning: I am a beginner. I want to group event_timestamp so I can see distinct actions rolled up on a daily basis. How do I do this? This is the query ...
04:11 28-Aug-2015
SQLServerCentral - Questions
Tables has the following columns: dept_name, varchar last_name, varchar first_name, varchar salary, money I need to run a query to list top 5 paid employees ...
23:24 27-Aug-2015
SQLServerCentral - Editorials
A guest editorial from Andy Warren looks at the traits of problem solvers.
23:00 27-Aug-2015
SQLServerCentral - Main Articles
Create a professional looking HTML table from T-SQL, not SSRS.
23:00 27-Aug-2015