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


Find all triggers in a SQL Server Database
Do you know what triggers lurk in your database? Triggers can be implemented to enforce business rules or referential data integrity in database applications. There are even triggers that allow data modifications to multiple base tables of a view. read more...

Microsoft launches Azure cloud in a box
Microsoft is teaming with Dell to create an Azure cloud in a box offering for customers who want to run their own, on-premises datacenters. read more...

Microsoft delivers first update to its Windows 10 Technical Preview
Microsoft has made available for download several new Windows 10 features to those running the Windows 10 Technical preview release. read more...

Microsoft SQL Server 2012 Internals: Special Storage
A sample chapter from from Microsoft SQL Server 2012 Internals looks at how SQL Server stores data that doesn’t use the typical FixedVar record format and data that doesn’t fit into the usual 8 KB data page. read more...

SQL–More memory and CPU is not always a win
Granting more to one program (or service), will take it away somewhere else. SQL is no exception, in fact it will happily consume all the resources you grant it – at the risk of starving other systems, including the OS. read more...

Database Lifecycle Management
Grant Fritchey on why you need to do is start thinking about mechanisms for automating your database deployments. read more...

Getting the Best Performance From an Intel DC P3700 Flash Storage Card
Windows Server 2012 R2 has native NVMe support, with some generic, default drivers. These drivers let Windows recognize and use an NVMe device, but they do not give the best performance. Installing the native Intel drivers makes a huge difference in performance from these cards. read more...

Career planning: What is your path?
Do you have a career plan at all? An easy way to check that is asking: “What are you going to do in 3 years, in 7 years and in 20 years from now?” read more...

Azure Blob Storage Part 4: Uploading Large Blobs
Two ways to upload a file in blocks. One way is to use the parameters that can be changed when calling the UploadFile method on the CloudBlockBlob object. The other way is to programmatically break the file into blocks and upload them one by one, then ask Azure to reassemble them. read more...

Multi-column statistics and exponential backoff
Kimberley Tripp explains multi-column statistics and how both the legacy and new CE would calculate selectivity, using the Credit sample database. read more...

Parameter Sniffing, Part 1
Klaus Aschenbrenner describes the scope of the Parameter Sniffing problem, arising when you work with parameterized SQL statements like stored procedures in combination with the plan caching mechanism of SQL Server. read more...

Can I Quote You on That? Quoting and Variable Expansion in PowerShell
Variable expansion with double quotes isn’t always easy. This is something else that often trips up beginners. read more...

Google Unveils ‘Inbox’, Its Next-Generation Gmail
Google have announced "Inbox," which seems to be an email client for Android, iOS and the web. read more...

5 Ways to Move Virtual Machines into Microsoft Azure
5 methods you can consider for migrating your virtual machines into Microsoft Azure, including Manual Upload of VHDs and Microsoft Virtual Machine Converter 3.0. read more...

PowerShell Problem Solver: Copy Files with Credentials Revisited
Proxy functions can be great problem solvers because you can take advantage of all the cmdlet’s features with the benefit of adding your own customizations. I expect will see proxy functions solving future PowerShell problems. read more...

How to Use Virtual Desktops in Windows 10 Technical Preview
While virtual desktops still need some refinement, if you want to experiment or have jumped in at the deep end and installed Windows 10 on your PC (not recommended), read on to see how virtual desktops work. read more...

SQL CLR assembly fails verification with “Unable to resolve token”
A SQL CLR assembly fails to register when upgrading from SQL Server 2008 R2 to SQL Server 2012. read more...

Add Database File on Database invloved in DB Mirroring
Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically. read more...

Reducing the size of the distribution database & improving transactional replication performance: Part 3
Chris Jenkins on the choice between replicating stored procedure calls and replicating the data modified by stored procedure calls. read more...

The MidnightDBAs release Minion Reindex
Minion Reindex is a free tool designed to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client sites. read more...