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


Simple-Talk - Blogs
How do you quickly clear a room-full of application developers, short of shouting 'fire' and setting off a smoke-bomb? The answer, of course, is to stand ...
13:33 30-Jun-2016
SQLServerCentral - Questions
Hi all, I want to group the rows based on the parameter value selected by user. In parameters,i have a checkbox called "Show Detailed ". My table structure ...
09:30 30-Jun-2016
SQLServerCentral - Blogs
This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control  and I've tested ...
08:38 30-Jun-2016
SQLServerCentral - Blogs
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput ...
03:40 30-Jun-2016
SQLServerCentral - Editorials
Knowing what is happening on your systems, and being told when a system is not behaving normally is very important for administrators. Steve Jones has ...
23:00 29-Jun-2016
SQLServerCentral - Main Articles
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
23:00 29-Jun-2016
SQLServerCentral - Main Articles
It is a good time to get familiar with Azure SQL Data Warehouse. The first objective must be to get data into it. SSIS is a good way to start, and it's ...
23:00 29-Jun-2016
SQLServerCentral - Blogs
I've had this blog post in my mind to write for the past month or so and I'm finally just getting around to it while I'm waiting to board my flight back ...
22:45 29-Jun-2016
SQLServerCentral - Blogs
This is the last part of this series, at least for now. If you haven't seen Part 1 and Part 2, feel free to check them out. After I got through Part ...
17:37 29-Jun-2016
SQLServerCentral - Blogs
Please entertain this thought for a moment - If today was your last day working with SQL how would you spend it? Now, this post is assuming you, as the ...
17:00 29-Jun-2016
SQLServerCentral - Blogs
I've got a high dpi display on my laptop. The recommended resolution is 2560×1704. That's small. I have had all kinds of issues with SSMS, VS, and ...
14:20 29-Jun-2016
SQLServerCentral - Blogs
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great quote above. When I heard that statement I stopped ...
12:30 29-Jun-2016
SQLServerCentral - Blogs
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if you have to reload data in ...
12:00 29-Jun-2016
SQLServerCentral - Blogs
I had a note (or 'action item') to make sure that people were informed regarding the 'uninstall' of ...
09:26 29-Jun-2016
SQLServerCentral - Questions
Dear All I want to merge the below statements in one querry select * from table1 where col1=@col select * from table1 where col2=@col I want ...
08:59 29-Jun-2016
SQLServerCentral - Blogs
In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up the SQL Server stack. One of those products ...
07:00 29-Jun-2016
SQLServerCentral - Blogs
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new features.  Being that I am the founder of the High ...
04:30 29-Jun-2016
SQLServerCentral - Blogs
I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th. I cannot convey just how much ...
23:10 28-Jun-2016
SQLServerCentral - Editorials
One of the things that can be an issue in database design is the data used to identify a user.
23:00 28-Jun-2016
SQLServerCentral - Main Articles
Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.
23:00 28-Jun-2016
SQLServerCentral - Main Articles
Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running ...
23:00 28-Jun-2016
SQLServerCentral - Main Articles
With PowerShell playing a more important role in administration of various types of servers, more SQL Server DBA candidates should have PowerShell knowledge ...
23:00 28-Jun-2016
SQLServerCentral - Questions
Hi! I'm stuck with this sql filtering... I have a column that is a varchar with values like: 000112-1234 020112-1233 040112-1231 050112-1534 ...
22:11 28-Jun-2016
SQLServerCentral - Questions
Been at the SQL DBA thing for 15+ yrs now. Management Studio is 2nd nature. However my coworker swears by DBVisualizer even for SQL Server connections. ...
20:40 28-Jun-2016
SQLServerCentral - Questions
Hi , I have certain values such as 'Test123' , 'a3456' , 'cgf999' Which i need to split into string and numerics in sql server 2012. Examples: ...
19:45 28-Jun-2016
DatabaseWeekly - Newsletter
Originally posted on: http://blog.crip.ch/darrengosbell/archive/2016/06/04/179446.aspxOften when you have a requirement to show a measure for the TopN ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
Set based operations means you should put everything into a single statement, right? Well, not really. People seem to think that having two queries is ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
If you believe figures from the technology research firm Gartner, there will be 25 billion network-connected ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
We've released the first fully open source version of our SQL Server First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzRS, sp_BlitzTrace, ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
DECLARE @start INT, @end INT, @increment INTSELECT @start=0, @end=100000000, @increment = 50000 ;WITH NumberList ( Number ) AS( SELECT @start as Number ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
Today's Pluralsight course review is Stacia Misner Vargas's Building Blocks of Biml. The course is just over 4 hours long, and it is completely worth ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
Recently I was creating a parameter in Power BI Desktop and had it configured something like this: I didn't bother to choose anything in the Default ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
In the previous blog post on Changes in default behavior for autogrow and allocations for tempdb and user databases, we discussed how some of the commonly ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
Over recent months, Redgate's development teams have been busy updating the tools in the SQL Toolbelt to support the valuable new functionality released ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
In this module you will learn how to use the KPI Indicator (This is kind of like saying "ATM Machine" isn't it?), a Power BI Custom Visual. Power BI comes ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
As hardware trends change over the years, customer environments move to newer hardware with larger number of cores per socket and TBs of memory, performance ...
16:46 28-Jun-2016
DatabaseWeekly - Newsletter
Several years ago I was introduced to UserVoice, the online forum that enables direct contact with users, allowing you to collect their feedback and build ...
16:46 28-Jun-2016
SQLServerCentral - Blogs
Over the years I have come to see that every database has what I call data type drift. Simply put, data type drift is when you have columns with the same ...
15:54 28-Jun-2016
SQLServerCentral - Questions
I have a dataset of bushmeat consumption for a list of households. It has columns for date, household ID (hh_id), meal_type (breakfast, lunch, or dinner ...
14:54 28-Jun-2016