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
Learn T-SQL with the StackOverflow Database
You work for a company that’s got a lot of data in Microsoft SQL Server, and you want to work with it – but you’re not sure how to start. You’re also afraid that your queries might be “bad,” and you don’t want to cause problems on someone else’s server – even when you need to work with a lot of data
When Algorithms Go Astray
The tale of Marc Elliott's algorithm raises a specter about which we all have to be concerned in this era when companies are generating models and algorithms by the truckload.
Database Changes - Build Once, Deploy Anywhere
A core concept of continuous delivery is build once, deploy anywhere. The idea behind it is simple, code is built once and deployed to all the servers throughout the various environments. For example, if you had a development, testing, staging and production server, you would build once before deploying to development. Once verified, that same package would then be deployed to testing and the process would repeat itself.
Events By Feature
Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.
The Dropbox hack is real
Motherboard reported on what had been rumoured for some time, namely that Dropbox had been hacked. Not just a little bit hacked and not in that "someone has cobbled together a list of credentials that work on Dropbox" hacked either, but proper hacked to the tune of 68 million records.
Building a Desktop Workstation for SQL Server Development and Testing
With the current selection of high-performance and very affordable desktop computer components, it is not very difficult to assemble an extremely high performance workstation for SQL Server development and testing at a very reasonable cost. Depending on how much performance you want and what your available budget is, you can take several different routes to get this accomplished.
What’s New in SQL Server 2016 Analysis Services?
SQL Server 2016 Analysis Services (SSAS) includes many new enhancements providing improved performance, easier solution authoring, automated database management, enhanced relationships with bi-directional cross filtering, parallel partition processing, and much more. At the heart of most enhancements for this release is the new 1200 compatibility level for tabular model databases.
Data-Driven Power BI Desktop Parameters Using List Queries
The July 2016 update for Power BI Desktop included the ability to make parameters data-driven, by giving the option to bind the Suggested Values property of a parameter to the output of a query that returns a list. if you’re wondering what a list is and how to get query to return one so you can use it in a parameter, then read on.
Data, Information, Knowledge Discovery, and Knowledge Representation
The use of SQL databases (confused with relational databases) is often questioned for certain analytical purposes. For example, scientific research experiments that “requires assignment of data to tables, which is difficult when the scientists do not know ahead of time what analysis to run on the data, a lack of knowledge that severely limits the usefulness of relational databases.