Database Weekly is the seven-day roundup from SQLServerCentral. 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.

Sign up to our newsletter now, to keep up to date with all the latest news.

Latest Database Weekly Newsletter Articles


Database CI and automated deployment with Jenkins: a Step by Step Tutorial
CI reduces your feedback loop such that changes that cause errors and break the build are caught as soon as they are committed to source control. Additionally, it is very easy to automate unit or integration tests. While CI started with application code you should apply the same principles to databases by automating your standard deployment tool to deploy your source control commit to a CI database. read more...

Is Android Microsoft’s Plan B for Mobile?
With Windows falling behind Android and iOS in mobile, Microsoft has found itself in the awkward position of supporting these rival platform with mobile apps and services. Sure, it will do what it can to make Windows 10 a success in mobile. But if that doesn’t work? read more...

PowerShell Problem Solver: PowerShell String Parsing with Named Captures and REGEX
Extract the parts of my name from the string using a regular expression feature called named captures, with which you can assign a name to a matching pattern. read more...

Creating a Function to Test and Compare PowerShell Commands
As you work with PowerShell, and especially when you begin developing scripts, you’ll realize there may be several ways to achieve the same result. How do you decide which is the better option? read more...

The shaky bug in SSIS
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Sometimes when you drag or move tasks/components on the canvas, they start to shake. A lot. And very annoyingly as well. (Quite impossible to take a screenshot of that, so sorry). This behaviour emerged after applying CU6. read more...

The SQL Empire Strikes Back To Claim Agility
Many of the justified criticisms of the SQL world really no longer apply if you employ the technologies mentioned in Dan Woods' article. There is no reason that SQL technology need be a bottleneck. It can be as agile as ever if you take the right approach. read more...

Performance Considerations (Entity Framework)
Performance characteristics of the ADO.NET Entity Framework and provides some considerations to help improve the performance of Entity Framework applications. read more...

SQL Server Dapper
Dapper has emerged as one of the more powerful micro-ORMs out there. Its main focus is mapping database tables to POCOs (Plain Old CLR Objects). read more...

Creating a multi-option parameter report for SQL Server Reporting Services
I have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values. How can I do this in a Reporting Services report? read more...

NoSQL startup Couchbase will launch ‘SQL for documents’ this summer
Couchbase, one startup selling commercially supported NoSQL database software, will be introducing to its subscription database this summer a new tool for querying that’s compatible with the widely used SQL query language. read more...

Software Architecture - Examples
Examples of application designs ranging from the complete lack of architecture to an architecture bound to a technology and also an architecture that I consider unbound to technologies and their limitations. read more...

0 to Speaker
Kenneth Fisher on how and why he wrote an abstract and submitted a session for the 2015 Pass Summit, with zero previous speaker experience. read more...

Clean out all bad characters from a string
A non-RBAR way to clean a string. Jeff Moden would be so proud. read more...

Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come up again several times recently. The issue relates to the line terminators used in data files. Occasionally, changes to the systems generating these data files, or perhaps even manual edits, can change the way the file marks the end of a line. These changes can cause a failure of package execution, or even worse, they can be loaded successfully and cause data quality issues in the target. read more...

Parsing XML Child Nodes and Converting to DateTime with PowerShell
On extracting session details from SQL Saturday XML data using PowerShell. read more...

Identifying Start Dates not Aligned with End Dates on a Prior Row
Due to design choices you will often find effective dates applied to rows in a table including both start and end dates. This can lead to data anomalies, which can be avoided by a constraint-based strategy, or simply identified and corrected after the fact. read more...

SQL Cop and SQLServerCentral
Steve Jones undertakes a bit of testing work on the SQLServerCentral databases, using the tsqlt framework, SQL Test and the SQL Cop tests. read more...

Analysing SQLBlog using Power Query
Power Query is, to all intents and purpose, a draggy-droppy-pointy-clicky UI over a functional language called M. Jamie Thomson uses it to create a Power BI dashboard that shows information pertaining to http://sqlblog.com. read more...

SQL Server DML Triggers - Tips & Tricks - Part 3 ("Trigger debug")
Debugging a Trigger with Microsoft Visual Studio development tool. read more...

Indexed View Maintenance in Execution Plans
Though they come with many restrictions and some important implementation caveats, indexed views are still a very powerful SQL Server feature when correctly employed in the right circumstances. One common use is to provide a pre-aggregated view of underlying data, giving users the ability to query results directly without incurring the costs of processing the underlying joins, filters, and aggregates every time a query is executed. read more...