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
SQLintersection coming up in May
This time SQLIntersection is in Scottsdale (Phoenix), Arizona (May 18-21). The speaker lineup includes Brent Ozar, Allen White, Aaron Bertrand, Kevin Kline, Shep Shephard, Denzil Ribeiro, David Pless, Tim Chapman, and four from SQLskills (Paul, Kimberly, Erin, and Tim).
Project Elysium wants to use VR to revive deceased loved ones
How far is too far when it comes to pushing the boundaries of virtual reality? As VR devices grow ever more sophisticated—and the tools to create software for them ever more accessible—where do we draw the line between what’s ethically acceptable in the real world and what’s ethically acceptable in the virtual world?
The Read Uncommitted Isolation Level
Read uncommitted is the weakest of the four transaction isolation levels defined in the SQL Standard. It allows dirty reads, non-repeatable reads, and phantoms. Most database people are aware of these phenomena, but not everyone realises that they do not fully describe the isolation guarantees on offer; nor do they intuitively describe the different behaviours one can expect in a specific implementation like SQL Server.
An Incredibly Insecure Voting Machine
Virginia election officials have decertified an electronic voting system after determining that it was possible for even unskilled people to surreptitiously hack into it and tamper with vote counts.
Time Slots - An Essential Extension to Calendar Tables
After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain Camps dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft.
Ruminations on Writing Great T-SQL
Depending on the problem being addressed, oftentimes there are just a few very elegant solutions, and probably a bunch of solutions that are not nearly as elegant. In simplicity there is often elegance. Simplicity, elegance and speed may unfortunately not all play well together. But if you can come up with a solution that is elegant, simple and fast, that’s usually going to get you a lot closer to writing great T-SQL.
Squaring big data with database queries
Although next-gen big data tools such as Hadoop, Spark, and MongoDB are finding more and more uses, most organizations need to maintain data in traditional relational stores as well. Deriving the benefits of both key/value stores and relational databases takes a lot of juggling.
T-SQL HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement. You can use this to record what workstation the transaction came from in your application or business intelligence processes.
Intel: Fifty Years Under Moore's Law
To celebrate the50th anniversary of Moore's Law, Intel published several web pages dedicated to the history of Intel and how Moore's Law has contributed to the advancement of the company. In a video, Moore also spoke about his predictions and his surprise at how far it has gone.