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
I have three tables like the following : Date Part_ID Inventory_count 1st jan 2015 123 1 31st jan 2015 123 2 table 2 : date ...
05:02 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:44 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:41 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:41 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:41 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:40 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel ...
02:40 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:39 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:39 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:38 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:38 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:38 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:38 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:37 31-Aug-2015
SQLServerCentral - Questions
QQ/??147-3277-057???????????????????????,????,????. ????*??????:????,????,????,????! ????:Angel QQ/??:1473277057 ??:1473277057@qq.com ??????????(?????????????): ...
02:36 31-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 - 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 - 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
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 - 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 - 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