Hacking Data
A new series of attacks were proven recently using music files to attach embedded systems in cars. Could this be another attack vector that we need to worry about?
Partitioning on a Budget
Enterprise Edition customers enjoy the manageability and performance benefits offered by table partitioning, but this feature is not available in Standard Edition. Aaron Bertrand explains his idea for achieving at least some of partitioning's upsides on any edition.
Running as SysAdmin
Today we have a guest editorial from Andy Warren. We still have many applications runnning under sysadmin accounts, often "sa". Why do people do this? Andy has a few thoughts on the subject.
Azure Data Lakes
The Data-lake is basically a large repository of data for 'big data' analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require new skills to use, and a heightened attention to Data Governance if it is to appeal to the average enterprise. Rob Sheldon takes a look.
Cursor-Killing: Accessing Data in the Next Row
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.
Jodie Beay and the Production Database Drift
You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you're worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of guilt. What would the Devs say? Somehow databases take on lives of their own, populated by the lost souls of users, Developers and DBAs. Has the Redgate DLM Team's practice Forex database somehow come alive?
Daily Database Backup Scripts
Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.
SQL Server 2016 : In-Memory OLTP Enhancements
Aaron Bertrand takes a look at the changes in store for In-Memory OLTP (the feature formerly known as "Hekaton").
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers