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 Debunkings Weekly Update
Relational table naming convention, Database relationships and more. read more...

SQL and Hadoop: It's complicated
With the 1.0 release of Apache Drill and a new 1.2 release of Apache Hive, everything you thought you knew about SQL-on-Hadoop might just have become obsolete read more...

Behaviour change for delete … output … into in SQL Server 2014
After upgrading a server from SQL 2012 to SQL 2014, a job started failing with "Cannot insert explicit value for identity column in table... when IDENTITY_INSERT is set to OFF. read more...

DB_Owner Querying for Database Options
What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, assign permissions, back up the database, etc). However someone asked recently about whether someone could read database properties. I’d assume they can, but I needed to check. read more...

Adding new users & groups in windows
I do a lot of testing with security in SQL Server. As well as SQL Server logins, I need to be able to create and delete windows users and groups. I could do this with the GUI, but first of all I’m a command line kind of guy and second if I’m creating a dozen or more users at once then the GUI is just too slow. read more...

Database unit testing, are we all doing it wrong?
This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery. When we started talking about database unit testing, we realized we both meant something fundamentally different when we called something a database unit test. Have I been doing it wrong all these years? read more...

It’s ethical hacking with SQL injection on Pluralsight!
Troy Hunt has long been a proponent of “hacking yourself first”, that is the idea of building up some offensive skills such that you can actually take a good shot at ethically breaking apps for the betterment of society. read more...

Creating PowerShell Scheduled Jobs With The New-JobTrigger Cmdlet
You may have a daily task that runs each morning to check servers for errors in the system event log. If you were smart, you learned PowerShell and wrote a script to do the work. But why should you have to manually run the script every morning when you could set it to run as a scheduled task? read more...

The Logjam (and Another) Vulnerability against Diffie-Hellman Key Exchange
Logjam is a new attack against the Diffie-Hellman key-exchange protocol used in TLS. read more...

PowerQuery – The power of M
Simon Sabin compares using PowerQuery and SSIS for the simple task of splitting a column that contains filename into the file and the extension. read more...

Using CLR to replace xp_cmdshell for specific tasks
As we have discussed before, xp_cmdshell is a mechanism to execute arbitrary calls into the system and because of the flexibility of its nature, it is typically abused and leads to serious security problems in the system. read more...

Heap Memory Settings for Analysis Services Tabular 2012 / 2014
The default memory settings for Analysis Services Tabular might be less than optimal. This article describes why this might happen, and guides you choosing the right configuration. read more...

Database In Recovery Update
Jason Brimhall offers an update for SQL 2012 and 2014, to his script that investigates what's happening when a database is “In Recovery”. read more...

Incremental Statistics are NOT used by the Query Optimizer
No documentation exists to state that incremental statistics will, or will not, be used by the Query Optimizer. So how do you know? You have to test it. read more...

SQL Server 2014 Service Pack 1 is available (again)!
As previously communicated, the Service Pack 1 release on April 15 was recalled very shortly after going live on the Microsoft Download Center (only) to address a recall issue. That issue has been resolved, and after complete re-certification is now available. read more...

Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008
Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance. read more...

Cumulative Update #16 for SQL Server 2012 SP1
The final Cumulative Update for SQL Server 2012 Service Pack 1. SQL Server 2012 SP1 exits service pack support on July 14, 2015. read more...

Cumulative Update #6 for SQL Server 2012 SP2
The 6th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all hotfixes which have been available since the initial release of SQL Server 2012 SP2. read more...

It’s Hard To Destroy Data
It is surprisingly difficult to delete data permanently. SQL Server has sophisticated features that prevent all kinds of data loss, but the opposite is not true. SQL Server has very few features that help you destroy data. read more...

Bug in sys.fn_hadr_backup_is_preferred_replica
While testing backups in SQL Server 2014 Availability Groups I hit a bug in a system function that is used to determine which replica is the most appropriate to be backed up. read more...