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


Microsoft Business Predictions for 2015
IoT matures, cybersecurity bulks up, and machine learning gives businesses a big advantage. read more...

PowerShell Problem Solver: Importing CSV Files into PowerShell
PowerShell will happily turn any imported CSV file into a collection of objects, but working with those objects can be a little confusing if you don’t completely understand the process. read more...

Determining your session’s transaction isolation level
If you don't know how to determine the current transaction isolation level, that detail is available in the sys.dm_exec_sessions DMV. read more...

Namco to open Pac-Man-themed restaurant in Suburban Chicago
Music has the Hard Rock Cafe. Film has Planet Hollywood. It's high time the game industry had its own cheesy, tourist-trappy theme restaurant to part visiting rubes from their money. Apparently, Namco agrees with that sentiment, given the company's plans to open Level 257, "a brand new restaurant and entertainment destination inspired by Pac-Man". read more...

Tweaking the Defaults for Ola Hallengren’s Maintenance Scripts
Brent Ozar walks you through configuring Ola Hallengren's popular maintenance scripts for your SQL Server environment. read more...

Data Quality Is in the Shifting Eye of the Beholder
Quality still matters in business, which is why no company slogan reads, "Shoddy is Job One." Data quality is no different, which is also why no CEO touts, "Facts, we don't need them." read more...


Tribal Awards 2014 Finalists
Nominations have been tallied and we have an official list of the Tribal Awards Finalists! Head over to vote now. read more...

Rename table, columns, and measures in #ssas #tabular without breaking existing #dax
A feature that many people require in SSAS Tabular is the ability to refactor existing names, doing a correspondent rename in all existing objects in the model. read more...

Six Benefits to Planning for SQL Server 2005 and Windows Server 2003 End of Support Now
As the end of 2014 nears, now is the perfect time to review IT infrastructure plans for the coming year. If you haven’t made supportability a key initiative for 2015, there are some important dates that you should know about. read more...

How to Do a Successful Lightning Talk
Ten-minute presentations aren’t easier than 60-75 minute sessions. They’re much, much harder. read more...

The Most Confusing Words, Phrases, and Acronyms in SQL Server
Words are hard. Acronyms are even harder. Here’s the words that give me the most trouble when talking to people about SQL Server. read more...

Why You Should Benchmark Your Storage
You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And next week. read more...

RegEx Those Dates
When you need dates for testing, some work with regular expressions can save a lot of hassle. read more...

High Availability and Disaster Recovery for Small Businesses
Too often in the past , High Availability and Disaster Recovery have been marketed as expensive choices for businesses with deep pockets. The truth is that, with careful planning, there are sensible and economic solutions for small businesses that can maintain business continuity when disaster strikes. read more...

Database Build Automation – The First Step to Continuous Integration
So you're keen to take the first steps to the continuous integration of your database. You have to start by getting your database into source control. You can then begin to automate your build processes in order to generate and test a database. By doing this regularly, you'll be much better prepared for the deployment process because you'll have solved integration issues when they happen, and facilitated the broader testing process. read more...

Sony Threatens News Media over Stolen Data
Sony Pictures Entertainment was warned by hackers to "obey" or else, now the entertainment giant is warning news organizations how to treat its stolen data in the wake of the attack. read more...

Proving that the Source of the Problems aren’t Tied to the Database
Being an application developer can always be demanding. You never know what situations we will get pushed into the next day. Here is one such situation which was just like a detective work. read more...

The Value of Writing Good
If you stink at writing, you might be wasting money, wasting time, and possibly hurting your paycheck, says Tracy McKibben. read more...

Now Available: Updated SQL Server PHP and JDBC Drivers
As part of SQL Server’s ongoing interoperability program, Microsoft have announced the general availability of two SQL Server drivers: the Microsoft JDBC Driver for SQL Server and the SQL Server Driver for PHP. read more...